|Quoting Iowaman (Reply 8):|
www.faremeasure.com, and the DOT has more updated numbers on their website.
Watch out when using Faremeasure.com. See this link for details:
For the same data, only in a more recent and accurate format, go to this site:
Table 6 is the same data as FareMeasure. If you care to compare FareMeasure to these quarterly tables you'll see the data on FareMeasure is several quarters old. Also, take a look at more than one quarter to get an idea of the seasonality of travel. That's something FareMeasure doesn't take into account or disclose to the user at all.
Finally...and I hope I can explain this clearly enough if this is new to you, the datasources talked about in this thread give two related but *different* pieces of information on routes.
The DoT stats shown in the consumer air fare report (which is the same stuff as FareMeasure, only newer and better-defined) talks about the TOTAL MARKET for travel between two cities. This information is quarter-by-quarter. Let's use San Diego-Seattle as an example to illustrate what this data is and what makes it distinctive. This datasource will tell you how many people flew each day where SAN
was their origin and SEA
was their final destination, and vice versa. Doesn't matter if they bought a ticket for an Alaska nonstop, or if they took a Southwest flight stopping in Oakland, or bought a Southwest ticket that required changing planes in Sacramento, or a USAirways ticket that required changing planes in Phoenix, or whatever. So what this datasource is trying to capture is the demand for air travel between two cities. (It has nothing to do with telling you how many people are onboard airplanes or what load factor is.)
The other widely-used data source mentioned in this thread are the T100's. They are at this link:
The T100's are all about flight segments and reported data on them like the cargo carried, passengers carried, aircraft type, etc. It is month by month. This is the best datasource to find load factor (how full aircraft were) because you can pull seats and passengers and do the math. This data is under the link T-100 Domestic Segment (US Carriers). Let's go back to the San Diego-Seattle example. This data will tell you, for a given month, how many people were onboard planes the took off from San Diego and landed nonstop in Seattle. That is NOT the same number as the total people whose total trip started in San Diego and ended in Seattle. Not everybody starting out in SAN
and ending in SEA
flew on nonstop flights for various reasons (cheaper fare, nonstops sold out, preferred a different flight time, airline brand preference, etc.) The flip side of the coin is not everybody sitting onboard a SAN
nonstop was actually flying just from San Diedo to Seattle. They could have been flying SAN
-Anchorage, or SAN
-Spokane, or SAN
-Tokyo, etc. Or maybe even flying from Mexico to Seattle via SAN
So it depends on what you're looking for, whether the T100 or the DoT quarterly stats really have what you are looking for.
A final word on using the T100's. The files can easily get too large to work with, so you're best off choosing one month at a time and one state at a time. I prefer to open then with Excel, and that can only handle about 65,000 records. If you try to pull a whole year, or data for all the states in one file, the file may get too big. And finally, there is usually about a four month lag on the data, so for example you will get an empty file if you ask for OSeptember 2006 right now. I think July 2006 is the most recent out there at this time.
Why are these two different?