Moderators: jsumali2, richierich, ua900, PanAm_DC10, hOMSaR
Quoting knope2001 (Thread starter): 6 ……. 6,719,600 ….. Boston (BOS+PVD+MDW) |
Quoting FlyPNS1 (Reply 1): Quoting knope2001 (Thread starter):6 %u2026%u2026. 6,719,600 %u2026.. Boston (BOS PVD MDW) I assume you mean MHT, not MDW. |
Quoting FlyPNS1 (Reply 1): Looking at this list, you can see why places like CLE and MEM are losing their hubs. Particularly MEM...abysmal O&D numbers. |
Quoting knope2001 (Thread starter): 56 ……. 467,370 ….. Myrtle Beach |
Quoting knope2001 (Thread starter): 49 ……. 573,420 ….. Charleston SC 50 ……. 573,150 ….. Memphis |
Quoting adamh8297 (Reply 7): DEN is the biggest surprise for me being the 16th largest CSA but 6th in overall O+D. However, geography is a big factor here. |
Quoting a380787 (Reply 2): this table really highlights how CLT is battling far above its natural base |
Quoting knope2001 (Thread starter): Philadelphia (PHL+TTN+ILG+ACY) |
Quoting BCEaglesCO757 (Reply 11): Six of our 7 hubs are located in the top ten, 7 in the top 15. |
Quoting knope2001 (Thread starter): 21 ….. 2,660,310 ….. Portland |
Quoting knope2001 (Thread starter): nor any international traffic. That also means airport like SJU, HNL and LIH are not included. |
Quoting Flytravel (Reply 10): Since Trenton is considered part of the New York CSA and not the Philadelphia MSA or CSA, shouldn't it be a NYC region airport? |
Quoting Flytravel (Reply 10): ABE also is part of New York's combined statistical area, but Lehigh Valley joined more recently to that CSA, and the ABE airport is more of a regional high fare except for G4, likely not drawing traffic from too far. |
Quoting TWA902fly (Reply 13): Why aren't HI AK + PR numbers included? They make up a good chunk of domestic O&D at airports like LAX, SEA, and MIA... |
Quoting knope2001 (Reply 3): FYI, Pensacola just missed the 250k cutoff...PNS, FAT, COS and BLI are between 200k and 250k. The reason I didn't go any lower than 250k is that the DoT stats I used had a few omissions |
Quoting knope2001 (Thread starter): 8 ……. 6,385,310 ….. Denver 9 ……. 6,183,600 ….. Dallas/Fort Worth (DFW+DAL) 10 ….. 5,806,080 ….. Miami/Fort Lauderdale (MIA+FLL+PBI) 11 ….. 5,426,630 ….. Orlando (MCO+SFB+DAB) 12 ….. 5,228,640 ….. Atlanta 13 ….. 4,963,370 ….. Seattle 14 ….. 4,284,080 ….. Houston (IAH+HOU) |
Quoting adamh8297 (Reply 7): DEN is the biggest surprise for me being the 16th largest CSA but 6th in overall O+D. However, geography is a big factor here. |
Quoting knope2001 (Reply 17): 23 ….. 2,023,634 ….. Salt Lake City (SLC+PVU) |
Quoting knope2001 (Reply 17): 1 ….. 13,319,802 ….. New York (LGA+EWR+JFK+ISP+HPN+ABE+TTN+SWF+HVN) 2 ….. 11,675,670 ….. Los Angeles (LAX+LGB+BUR+ONT+SNA+PSP) 4 ……. 8,781,600 ….. Chicago (ORD+MDW) 5 ……. 8,331,696 ….. Washington DC (DCA+BWI+IAD+HGR) 9 ……. 6,183,600 ….. Dallas/Fort Worth (DFW+DAL) 10 ….. 5,806,080 ….. Miami/Fort Lauderdale (MIA+FLL+PBI) 15 ….. 3,902,782 ….. Phoenix (PHX+AZA) 17 ….. 3,686,990 ….. Philadelphia (PHL+ILG+ACY) 22 ….. 2,195,030 ….. Charlotte |
Quoting knope2001 (Reply 17): 1 ….. 13,319,802 ….. New York (LGA+EWR+JFK+ISP+HPN+ABE+TTN+SWF+HVN) 2 ….. 11,675,670 ….. Los Angeles (LAX+LGB+BUR+ONT+SNA+PSP) 3 ……. 9,480,216 ….. San Francisco (SFO+OAK+SJC+STS+SCK) 4 ……. 8,781,600 ….. Chicago (ORD+MDW) 5 ……. 8,331,696 ….. Washington DC (DCA+BWI+IAD+HGR) 8 ……. 6,385,310 ….. Denver 14 ….. 4,284,080 ….. Houston (IAH+HOU) |
Quoting knope2001 (Reply 17): 1 ….. 13,319,802 ….. New York (LGA+EWR+JFK+ISP+HPN+ABE+TTN+SWF+HVN) 2 ….. 11,675,670 ….. Los Angeles (LAX+LGB+BUR+ONT+SNA+PSP) 12 ….. 5,228,640 ….. Atlanta 13 ….. 4,963,370 ….. Seattle 18 ….. 3,378,240 ….. Minneapolis/St Paul 19 ….. 3,021,126 ….. Detroit (DTW+FNT) 23 ….. 2,023,634 ….. Salt Lake City (SLC+PVU) 43 ……. 722,910 ….. Cincinnati |
Quoting MesaFlyGuy (Reply 6): Wow, I just flew out of CHS and when I think of how many people I saw there it's amazing that an airport that, until very recently, was a Delta hub had virtually the same amount of O&D, it makes me wonder how MEM ever became a hub in the first place! |
Quoting bobnwa (Reply 23): At the time the MEM hub was created by NC, it was strictly a connecting hub and did not plan on large O+D I worked quite well for a number of years as a connecting hub. |
Quoting a380787 (Reply 22): |
Quoting knope2001 (Thread starter): |
Quoting knope2001 (Reply 17): |
Quoting adamh8297 (Reply 7): DEN is the biggest surprise for me being the 16th largest CSA but 6th in overall O+D. |
Quoting adamh8297 (Reply 7): However, geography is a big factor here. |
Quoting EricR (Reply 8): I am sure geography plays a minor role, |
Quoting EricR (Reply 8): The additional competition greatly reduced fares out of DEN which significantly stimulated demand. |
Quoting EricR (Reply 8): DEN is now one of the lower fare airports in the country and thus the main reason for the high O&D relative to population size. |
Quoting a380787 (Reply 2): Even without the small markets, this table really highlights how CLT is battling far above its natural base |
Quoting USAirALB (Reply 9): The main problem CLT is geography |
Quoting FlyPNS1 (Reply 18): Yeah, I wondered about PNS. Based on the numbers I have PNS would make the cut, but those numbers would include travel to places like Hawaii and international, so I'm guessing that's why PNS doesn't make your cut off. |
Quoting Coronado (Reply 19): Great work. Are there any estimates on how much O&D is actually fictitious? |
Quoting redzeppelin (Reply 21): Quoting knope2001 (Reply 17):23 ….. 2,023,634 ….. Salt Lake City (SLC+PVU) Should OGD also be included in this count? |
Quoting adamh8297 (Reply 7): However, geography is a big factor here. |
Quoting a380787 (Reply 22): |
Quoting mercure1 (Reply 32): Interesting analysis, but ranking it seems does not quite match other similar threads we've had over years. Actually quite severe differences in top city rankings. The 52 Largest Domestic O&D Markets (by MAH4546 Mar 26 2008 in Civil Aviation) Top US O&D Markets (by LAXintl Aug 20 2010 in Civil Aviation) Top US O&D Airports (by LAXintl Jun 19 2013 in Civil Aviation) Is this possibly because you only analyse a single quarter, and not annual time period? Clearly there is large seasonality involved with some markets. |
Quoting ultrapig (Reply 33): Thanks-I was wondering though if there were a searchable database accessable to us mere mortals where we could see the O&D traffic form x to Y |
Quoting knope2001 (Reply 34): If I were smart I’d keep this information in a document and just cut and paste it when someone asks! The O+D stats are at this link and they come out quarterly. There are other sources on the web (both paid and free) but I believe they ultimately roll back to these same core quarterly stats. They are extrapolated from a 10% overall sample if I’m not mistaken, but I think they are the most complete and accurate out there. Within these stats are multiple tables. The one I tend to use most is Table 6. It lists O+D markets with 10 or more average daily passengers for the quarter. That “10” is both ways combined, so if you see AAA-BBB has 78 daily passengers, that’s an average of 39 each way. The table also lists the average fare, the market share and fare of the largest carrier, and the market share and fare of the cheapest carrier. A key thing to know about Table 6 is that it gives *combined numbers* for some select multi-airport communities. It combines IAH and HOU as “Houston Area”, for example. If you’re looking at Atlanta-Houston, for example, you won’t find O+D between Atlanta and Houston Hobby or Houston Intercontinental in table 6, you’ll find Atlanta-Houston combined. What can make it more confusing is that when you look at the airport codes in Table 6, you might find that combined Atlanta-Houston number listed as ATL-IAH *or* as ATL-HOU. If you see in Table 6 ATL-HOU listed as 1200 you might think 1200 people travel between Atlanta and Hobby, but in fact that both Hobby and Bush combined. If you see in table 6 ATL-STL listed as 850 that is accurate for daily travel between Atlanta Hartsfield and St Louis Lambert because each of those cities has one airport. When you see CMH-MCO in table 6 listed as 900 you may think that includes Columbus-Orlando International and Columbus-Sanford/Orlando Airport, but in fact the DoT does *not* combine MCO and SFB into “Orlando” in table 6. It can be confusing. I believe these are the ones currently combined in table 6: Boston = BOS+MHT+PVD, New York = LGA+JFK+EWR+ISP+HPN+SWF, Washington = DCA+BWI+IAD, Norfolk = ORF+PHF, Miami = MIA+FLL, Houston = IAH+HOU, Dallas = DFW+DAL, Cleveland = CLE+CAK, Chicago = ORD+MDW, Los Angeles = LAX+SNA+BUR+ONT+LGB, San Francisco = SFO+OAK+SJC. To get O+D from individual airports within a combined reporting entity, use table 1a. It has the same data as Table 6, but it gives individual airport breakdowns for cases where table 6 rolls them together. In 1a you’ll find ATL-HOU and ATL-IAH separate. You’ll find ORD-HOU, ORD-IAH, MDW-HOU and MDW-IAH as separate where in table 6 they were all lumped into a single “Chicago-Houston” number. But you won’t find ATL-STL in table 1a because neither Atlanta nor St Louis is a multi-airport entity in table 6. How do you know when you can use table 6 and when you must instead look at 1a? Check table 1a if there’s any doubt. Let’s say you want just Cleveland Hopkins numbers and are concerned Akron might be rolled into the CLE numbers in Table 6. Look at table 1a. When you look in there you’ll see dozens and dozens of both CLE-xxx and CAK-xxx numbers to all sorts of cities which are not multi-airport. For example you’ll see both CLE-RSW and CAK-RSW, CLE-DEN and CAK-DEN, CLE-MSP and CAK-MSP, etc. That’s a sure sign that in Table 6 CLE and CAK are combined and Table 1a is the place to get the individual airport date. Now let’s say you want Detroit Metro numbers and are worried that Flint might be rolled in. Look again at Table 1A. You will find a fair number of DTW and FNT entries in Table 1a, but they are all to cities with multiple airports. You’ll see DTW-DAL, DTW-DFW, FNT-DAL and FNT-DFW, but that’s because Dallas is multi-airport. You won’t see DTW-ATL and FNT-ATL in Table 1a, which tells you the airports are not combined in Table 6 – that data is separate. And…just to keep you on your toes if you go back in the data you’ll find some differences. If you go a few years back you’ll find CLE and CAK were not always combined. And maybe in a future release you’ll see DTW and FNT are. Using the smell test can sometimes help. If in a *future* quarterly release you are looking at Denver numbers in Table 6 and you notice DEN-FNT shows 975/day but DEN-DTW seems missing, that’s a good sign that now Detroit and Flint have been combined and it so happens Denver-Detroit Area was listed as FNT. It’s not always the largest or obvious city code listed. You may see in table 6 that 3800 people per day are listed flying from Providence to Ontario, which would be quite a feat. But in fact that is the combined total of all 15 unique city pairs linking (BOS-PVD-MHT-) with (LAX-SNA-BUR-ONT-LGB) Table 7 which I used for this list shows total O+D for the quarter, and then also breaks it down between short and longer haul and focuses on % offered by low-cost carriers. But the totals should be accurate for the whole O+D market – you can’t say 46% of all O+D traffic at airport XYZ was on low cost carriers without having the total O+D, of course. Table 5 is the other one I use sometimes. It shows all the carriers with a significant number of passengers in large markets, and instead of average daily it shows total number for the quarter – again, both directions combined. What’s nice about this versus Table 6 and Table 1a is that you can get the market share and fare of multiple airlines in a competitive market. Table 6 and 1a just give you the largest and cheapest carrier, and sometimes that’s the same one. But 5 will show you that in STL-DEN that United did X, Frontier did Y, and Southwest did Z. Roughly speaking you’ll find the nonstop carriers in markets with fairly substantial local traffic – MSP-BOS yes but MSP-FAR no. The definition of “significant number” and “larger markets” is fuzzy, however. I’ve never been able to find a cutoff, and sometimes it doesn’t seem everybody is listed. So table 5 is one of those I find interesting and useful but may not have everything I want. Note that Table 5 is like 6 in combining airports is deems to be a single entity. Two additional caveats on these numbers. 1. There have periodically been issues when a regional carrier did not show up in these numbers for whatever reason. The classic example is for something like 5 out of 6 consecutive quarters a few year back ExpressJet did not. So if you looked at a market like CLE-BDL – a market served nonstop by Express Jet at CO* with multiple daily RJ’s – you’d see bad information. For those six quarters, one of the six quarters you’d see CLE-BDL as 150 passengers with CO* having 80% of the market, and the other five quarters the stats would say CLE-BDL had 30 passengers per day and the largest carrier was Delta or USAirways. I’ve seen this a number of times over the years with regionals including Chautauqua and Mesaba too. When there’s a decent-sized market served by one regional, an issue like this can stick out like a sore thumb. But what’s a little scary is that with how much regions are swapped by the majors you can’t always notice an issue like this. Let’s say one quarter DAY-ORD on United is mostly UA*Skywest and they report. Then the next quarter it happens to be UA* 80% TranStates and 20% Skywest flights operating DAY-ORD (this is not too uncommon a swap) and TranStates numbers are for whatever reason not in the reports. The reported DAY-ORD UA number would plummet. And it’s not clear how DAY-ORD-LAX (for example) would be affected if the DAY-ORD leg was UA* on TranStates, but you can see how things could get messed up. I had hoped that this sort of problem was in the past, but I was disheartened to notice that US* point-to-point RJ nonstops from PIT to BDL, STL and RDU are clearly not shown in these Q3 status. They’re operated by TranStates (AX) which makes me wonder if any US* operated by them show, or if these don’t because they are at-risk flying. Anyway…this is something to be a bit wary of, especially if you’re working with these numbers in the smaller markets. It can help to use the “smell test”. If you’re looking at numbers from Montgomery…which only has DL* to ATL, US* to CLT and AA* to DFW…and Delta has 85% market share to places like Washington, New York, etc, that might not make sense. And if you see MGM-CLT is listed at 11 passengers per day and Delta has 81% market share even though US* flies MGM-CLT nonstop, that’s a clear sign US* isn’t being fully reported. 2. There’s a tendency, especially when you’re first playing with these numbers, to perhaps read too much into them. You see Louisville-Austin as 80 passengers per day and can’t figure out why someone can’t fly a nonstop CRJ in the market because that’s only 50 seats each way so it would be 80% full. Or even worse you think it’s 80 each way. The problem is that travelers stick with their preferred airline, or they want to fly at a different time than the nonstop goes, or there are 130 people on Mondays but only 30 on Tuesdays, or the 80 people are not paying fares high enough to cover the high CRJ cost. On the flip side people will sometimes pronounce doom on a new market because only X people fly between those two cities. That can be equally misguided because new nonstop flying sometimes serves a lot more passengers than the city pair previously reported – check out my explanation in the DEN-NRT thread if you care you on how that works. So bottom line…enjoy and learn from these numbers but avoid using them as gospel because you’ll be proven wrong plenty of times. Been there, done that! |
Quoting LAXintl (Reply 37): Domestic Rank / City / Pax(mil) / Revenue(mil) / Avg yield cents 6. DAL / 25.8 / $4,835 / 19.09 8. SF / 25.1 / $4,795 / 12.43 10. WAS / 22.2 / $4,434 / 16.99 |
Quoting LAXintl (Reply 37): International Rank / City / Pax(mil) / Revenue(mil) 1. NYC / 32.6 / $20,357 2. LA / 15.6 / $11,292 3. MIA/ 14.2 / $6,348 4. SFO / 9.4 / $7,437 5. CHI / 6.8 / $4,816 6. WAS / 6.0 / $4,652 7. ORL / 5.4 / $2,253 7. BOS / 5.3 / $3,533 8. HNL / 4.9 / $5,491 9. LAS / 4.6 / $2,009 10. HOU / 4.2 / $3,763 |
Quoting LAXintl (Reply 41): knope2001 opted to use much broader census bureau CSA definitions. My data using DOT market definition which can split large metro areas with multiple airports into individual markets. More specifically, for example, the DC area in my list excludes BWI. Same thing with other large metro areas like Bay Area, LA basin, and South Florida where separate individual markets are created when airports are split. |
Quoting LAXdude1023 (Reply 43): Do you have beyond the top 20? |
Quoting a380787 (Reply 44): So MIA and FLL are 2 markets from DOT's viewpoint ? No wonder domestically it's not even in the Top 10 |
Quoting LAXintl (Reply 45): 18. DEN / 1.7 / $1,011 |
Quoting point2point (Reply 46): Wow! DEN now ranks in the top 20 with internationals? Domestic very high is expected, and international here is kinda sorta not the best..... but they're in the top 20? The DEN managers have been having a big push for ex-boarder flights.... maybe this year they'll go up another spot or two and have some decent numbers to show..... at least 3%-4% of the traffic.... not something like it's been around 1.5%..... |
Quoting LAXdude1023 (Reply 47): Looks like DEN took a step back from 2011. There were closer to the 2.0 million mark. |
Quoting point2point (Reply 48): |