I was curious what each Regional Code-share System looked like amongst the majors. Especially, if it was broken down by partner and aircraft, and compared with Mainline fleet size.

Regional CodeShare Profiles | Audries Aircraft Analysis
Alaska Airlines Regional Codeshare | Audries Aircraft Analysis
American Eagle Regional Codeshare | Audries Aircraft Analysis
Delta Connection Regional Codeshare | Audries Aircraft Analysis
United Express Regional Codeshare | Audries Aircraft Analysis
US Airways Regional Codeshare | Audries Aircraft Analysis

As were seeing a lot of realignment amongst Regional Carriers it is being circulated that most Mainline carriers want a diversity of only a few regional carriers, between 3-5. One carrier that does the bread and butter, and that is able to run significant lift and perks when needed (more expensive). Two Mediocre carriers that may not have much flexibility or perks but add diversity (for a reasonable cost). Finally one carrier that is extremely cheap and small, and is understandably unable to offer much quality. This final carriers purpose is to keep the other carriers in check financially.

Perks might be considered Econ Fuel Profiles, Single Engine Taxi, special airport qualifications etc. Significant lift could be considered having sufficient capacity to handle most of the seasonal swings in traffic.

The Data is from the websites database and is fairly current but as always its difficult to keep it updated up to the month, so their may be slight errors in it. Hopefully it will be of help to those trying to determine where their regional might find itself over time with respect to the future of the 50 seater, and the 3-5 regional model.

The following is not mine but it is a very good resource on past trends.
Airline affiliates and CPA's

United is missing the C5 Dash 8's (Q200 and Q300). Otherwise, pretty interesting to see these numbers.

Delta is missing 170's flown by Republic (Shuttle America). Pinnacle also no longer flies SF340's or Q400's for United Express.

The one for American is going to be changing very rapidly since Skywest came in and took over the LAX flying and soon ExpressJet will be doing some DFW flying.

all of it will always be changing all the time, the poster said it was not completely up to date. This industry is a marry go round of a pony show. Today's hot date is tomorrows corner hooker, and next weeks funeral.

Good catches, they should be updated now. I'll make the SkyWest and ExpressJet Modifications as they happen next month. Current Shuttle America/Republic numbers are difficult pin down, what is the current number of E170's and E175's and how are the broken down amongst partners?

Well done.

13 -170
15-175

operated by Shuttle America for DL

Nice work! The United one is quite an eye opener. I think I read somewhere that 60% of UA flights is done by regionals!?

Republic is now operating the Q400 for United. I believe there are currently only 4 online right now but there will be 30 by probably January.