Ask a Librarian & FAQs

Office of Aviation Analysis

• Domestic Airline Consumer Airfare Report: provides information about average prices being paid by consumers in the top 1,000 domestic city pair markets in the continental United States

Questions? Contact Randall Keizer

• ​Phone: 202-366-2347

• Email: Randall.Keizer@dot.gov

• Mail:

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

Bureau of Transportation Statistics (BTS)

• Airline Origin and Destination Survey (DB1B) - click on "Aviation" then "Airline Origin & Destination Survey" - a 10% sample of airline tickets from reporting carriers including origin, destination and other itinerary details of passengers transported. As of July 2025, carriers will begin reporting 40% of their tickets, rather than 10%.

• Origin and Destination Survey: DB1BMarket (click "Download"): average fares by airport pairs (or city pairs) 

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. Filter out fares below a certain value (e.g. $50) to eliminate flights that just contain taxes and fees but no actual base fare. This is how BTS calculates the average fares. 

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

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

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