ACAfan
Topic Author
Posts: 690
Joined: Fri Apr 30, 2004 11:25 pm

How Do I Get O&D Numbers For A City?

Tue Dec 28, 2004 1:43 am

How do I get the O&D numbers for a city: the top destinations and the pax to each of them?

I am particularly interested in the top destinations from RIC.

Thanks in advance.
Freddie Laker ... May be at peace with his maker ... But he is a persona non grata ... with IATA
 
BoeingDrew
Posts: 45
Joined: Fri Dec 24, 2004 12:43 pm

RE: How Do I Get O&D Numbers For A City?

Tue Dec 28, 2004 2:00 am

This tool not only tells you the average airfare, but the amount of passengers that fly this route daily. http://www.gofox.com/tools/traveltools.php?pid=1213392&tool=farewatch. You will have to search each airport one by one, but it will give you a general idea. Enjoy!  Smile

-Drew
You can't build a reputation upon what you are GOING to do, but rather upon what you HAVE done!
 
Cubsrule
Posts: 11368
Joined: Sat May 15, 2004 12:13 pm

RE: How Do I Get O&D Numbers For A City?

Tue Dec 28, 2004 3:00 am

http://www.faremeasure.com is also a good tool. I've not used gofox, but I know that faremeasure uses the most recent DOT data and I imagine that site does too, so picking one is just a matter of which interface you like better. I like the ability to sort faremeasure data for a city by distance between city pairs, average fare, and number of passengers.
I can't decide whether I miss the tulip or the bowling shoe more
 
flyinryan99
Posts: 1423
Joined: Sat Feb 17, 2001 6:54 am

RE: How Do I Get O&D Numbers For A City?

Tue Dec 28, 2004 3:19 am

ACAfan,

Here's the one from the DOT itself....bare with me kind of difficult to get to

http://ostpxweb.dot.gov/aviation/index.html

You need to go "domestic issues">"consumer air fare report">"consumer air fare report" (again)>table 6

Table 6 is the one that comes out in a .txt...I liked it much better when it was downloadable in excel...but you can always cut and paste like me..hehe.

Enjoy,

Ryan
 
AeroWesty
Posts: 19551
Joined: Sat Oct 30, 2004 7:37 am

RE: How Do I Get O&D Numbers For A City?

Tue Dec 28, 2004 4:06 am

I liked it much better when it was downloadable in excel...but you can always cut and paste like me

Excel will give you a number of formatting options when you open .txt and .csv files from the File/Open menu. Saves cutting and pasting.  Smile

You can also build custom databases including historical information with the DOT information available here:

Data Library: Aviation

Cheers  Smile
International Homo of Mystery
 
flyinryan99
Posts: 1423
Joined: Sat Feb 17, 2001 6:54 am

RE: How Do I Get O&D Numbers For A City?

Tue Dec 28, 2004 4:39 am

Learn something new every day! Thanks, makes it a heck of a lot easier...now I can just find the ones I want. hehe  Smile

Ryan
 
san747
Posts: 4344
Joined: Sun Dec 19, 2004 10:03 am

RE: How Do I Get O&D Numbers For A City?

Tue Dec 28, 2004 9:16 am

Wow, what a great resource! This is very interesting, and as Flyinryan said, you learn something new everyday!

Thanks,
Alex
Scotty doesn't know...
 
User avatar
ERJ170
Posts: 5467
Joined: Thu Apr 15, 2004 11:15 am

RE: How Do I Get O&D Numbers For A City?

Tue Dec 28, 2004 9:31 am

Does anywhere offer international O&D? just wondering.. thanks in advance..
Aiming High and going far..
 
flack4ric
Posts: 37
Joined: Sat Sep 27, 2003 2:09 am

RE: How Do I Get O&D Numbers For A City?

Wed Jan 05, 2005 6:34 am

International O&D is considered Restricted Release Aviation Economic Information by USDOT.
 
AeroWesty
Posts: 19551
Joined: Sat Oct 30, 2004 7:37 am

RE: How Do I Get O&D Numbers For A City?

Wed Jan 05, 2005 6:53 am

International O&D is considered Restricted Release Aviation Economic Information by USDOT.

However, if you are a U.S. citizen and meet the use and non-disclosure terms, you may certainly access this information upon application.

See the general terms at the link below which includes a link for both the HTML and PDF formats of the form to request International O&D information from the DOT:

http://www.bts.gov/programs/airline_information/sources/

Cheers.
International Homo of Mystery
 
masseybrown
Posts: 4407
Joined: Wed Dec 11, 2002 2:40 pm

RE: How Do I Get O&D Numbers For A City?

Wed Jan 05, 2005 5:46 pm

ERJ170, the Brits have a good data operation at

http://www.caa.co.uk/

Look under "Economic" and then "Statistics." Good data by route. Airline-specific data are for UK airlines only.

Who is online

Users browsing this forum: Alexa [Bot], Baidu [Spider], brilondon, dk44, Exabot [Bot], FarhanAzmi, FLJ, JeremyB, KarelXWB, klwright69, Moosfliege, NZdsgnr, samzkvh, SomebodyInTLS, spiplane, terrificturk, thomasphoto60, twincommander, zaphod42 and 301 guests