Sponsor Message:
Aviation Technical / Operations Forum
My Starred Topics | Profile | New Topic | Forum Index | Help | Search 
O&D Data Sources  
User currently offlinefrequentfryer From United States of America, joined Nov 2012, 32 posts, RR: 0
Posted (1 year 9 months 4 days 21 hours ago) and read 1813 times:

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!

3 replies: All unread, jump to last
 
User currently offlinejetmatt777 From United States of America, joined Jun 2005, 2788 posts, RR: 32
Reply 1, posted (1 year 9 months 1 day 20 hours ago) and read 1700 times:

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)



No info
User currently offlinetdscanuck From Canada, joined Jan 2006, 12709 posts, RR: 79
Reply 2, posted (1 year 9 months 1 day 19 hours ago) and read 1689 times:

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.


User currently offlinejetmatt777 From United States of America, joined Jun 2005, 2788 posts, RR: 32
Reply 3, posted (1 year 9 months 1 day 13 hours ago) and read 1658 times:

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.



No info
Top Of Page
Forum Index

Reply To This Topic O&D Data Sources
Username:
No username? Sign up now!
Password: 


Forgot Password? Be reminded.
Remember me on this computer (uses cookies)
  • Tech/Ops related posts only!
  • Not Tech/Ops related? Use the other forums
  • No adverts of any kind. This includes web pages.
  • No hostile language or criticizing of others.
  • Do not post copyright protected material.
  • Use relevant and describing topics.
  • Check if your post already been discussed.
  • Check your spelling!
  • DETAILED RULES
Add Images Add SmiliesPosting Help

Please check your spelling (press "Check Spelling" above)


Similar topics:More similar topics...
Data On Cabin Floor Area Of Commerical Aircraft? posted Fri May 11 2012 06:02:01 by MUC79
77W Self Dispatch Performance Data posted Tue May 8 2012 13:07:48 by tom355uk
CX Fleet And Engine Data. posted Tue Mar 20 2012 17:57:28 by Qantas747300
B734 NAV Data Base Loading posted Thu Jan 5 2012 13:20:15 by B727LVR
737-800 Flight Planning Data Needed For Dispatch posted Mon Aug 29 2011 13:36:06 by dispatch1979
Does Anybody Have Photos Of Data Plates? posted Sat Aug 21 2010 06:27:59 by warbirdplates
Flight Data Recorders - Why Have Just One? posted Tue Jul 20 2010 02:40:15 by MingToo
HKG-SIN Flight Profile/Data posted Sun Mar 7 2010 10:52:04 by DC10student
Need Traffic/Pax Data For CPT! posted Thu Feb 11 2010 03:39:36 by VikingA346
Legal Prescriptions Re Archiving Of Flight Data posted Thu Jul 2 2009 02:25:52 by Faro

Sponsor Message:
Printer friendly format