Q. Where can I find data on average fares using the Airline Origin and Destination Survey (DB1B)?

Answer

Office of Aviation Analysis

Questions? Contact Mark Raggio

Office of Aviation Analysis
1200 New Jersey Ave, SE
Washington, DC 20590
United States


Bureau of Transportation Statistics (BTS)

  1. Select the following fields:

    • Origin

    • OriginCityMarketID

    • Dest

    • ​DestCityMarketID

    • Passengers

    • MktFare

  2. Filter:

    • Geography (by either origin or destination state),

    • Year

    • Quarter (Note: you can only download one quarter at a time)

  3. Download data and multiply Passengers x Market Fare for each row to get Total Fare

  4. Sum the Passengers column and sum your newly created Total Fare column

  5. Divide the Total Fare by the total number of Passengers

  • Tip: The file you download may be too large to open in Microsoft Excel.  You may need to extract it to your computer and open it with a program such as Microsoft Access, SPSS or SAS. 

  • Tip: You may want to filter out fares below a certain value (e.g. $50) to eliminate flights that just contain taxes and fees but no actual base fare.

 

 

  • Last Updated Dec 07, 2017
  • Views 10
  • Answered By David Martin

FAQ Actions

Was this helpful? 0   0

Contact Us

Can't find the answer you're looking for in the FAQs? Contact a Reference Librarian for help.