frequentfryer
Topic Author
Posts: 32
Joined: Sat Nov 17, 2012 4:21 am

O&D Data Sources

Thu Dec 20, 2012 3:11 am

I'm dealing with a bit of data overload regarding open source O&D data for the domestic US. I hope this thread will assist the next person learning how to pull O&D data as well.
I want to see the daily average number of passengers traveling directly from origin(a) to all direct destinations by quarter with average fares.

On one end of the spectrum there is a tool on the Airline Empires site called "paxdata" that has a very simple UI and maps the data for you, but customized queries do not seem to be functioning and It appears that you can't look at data over time. Also did not see documentation on how timely the data is.

http://paxdata.airlineempires.net/

Transtats is highly sited here. I am attempting to decode the process to get the information I am looking for. I'm sure it looks intuitive to someone already familiar with the too. I'm not sure if I need to build out my own access DB and insert their tables or if there is a way to select a city and timeline and export a spreadsheet with relevant O&D data.

http://www.transtats.bts.gov

There are others of course. I'm not sure which are applicable to the US market and some seem to deliver different data sets than others.

Thanks for your help!
 
jetmatt777
Crew
Posts: 2808
Joined: Sun Jun 26, 2005 2:16 am

RE: O&D Data Sources

Sun Dec 23, 2012 4:11 am

Try this:

http://www.dot.gov/policy/aviation-p...stic-airline-fares-consumer-report

Table 6 has every U.S. Domestic city pair with more than 10 pax per day avg. This is total traffic, divide the number by 2 to get an each way estimate (but not precise)
Lighten up while you still can, don't even try to understand, just find a place to make your stand and take it easy
 
tdscanuck
Posts: 8572
Joined: Wed Jan 11, 2006 7:25 am

RE: O&D Data Sources

Sun Dec 23, 2012 5:19 am

Quoting jetmatt777 (Reply 1):
Table 6 has every U.S. Domestic city pair with more than 10 pax per day avg. This is total traffic, divide the number by 2 to get an each way estimate (but not precise)

Just be very careful that that the DOT data is for individual legs, not O-D markets. There is no rigorous way to figure out how much of, say, Allentown-DFW traffic is really in the Allentown-DFW O-D market and how much is in the Allentown-Los Angeles market (with a connection in DFW).

Sometimes you can identify routes where this is an issue by major fare discrepancies...for example, the average fare on Allentown-Detroit is $346...there is zero chance that much of that traffic is really just going to Detroit (it's only a one hour flight and it's not that competitive so the fare is too high for just Detroit)...most of those people are connecting through Detroit to somewhere else.

Tom.
 
jetmatt777
Crew
Posts: 2808
Joined: Sun Jun 26, 2005 2:16 am

RE: O&D Data Sources

Sun Dec 23, 2012 10:53 am

Right, which is why I said city pair and not non-stop market.

The data would be too large and complex if O/D was specific to each route, flight, and carrier. The city pair, passenger traffic, and market share coupled with some other data (schedules, etc.) should give a fair representation of that route, but by no means scientific.
Lighten up while you still can, don't even try to understand, just find a place to make your stand and take it easy

Who is online

Users browsing this forum: No registered users and 14 guests