Q. Where can I find data on average fares using the Airline Origin and Destination Survey (DB1B)?
Answer
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): a 10% sample of airline tickets from reporting carriers including origin, destination and other itinerary details of passengers transported
-
Origin and Destination Survey: DB1BMarket: average fares by airport pairs (or city pairs)
-
Select the following fields:
-
Origin
-
OriginCityMarketID
-
Dest
-
DestCityMarketID
-
Passengers
-
MktFare
-
-
Filter:
-
Geography (by either origin or destination state),
-
Year
-
Quarter (Note: you can only download one quarter at a time)
-
-
Download data and multiply Passengers x Market Fare for each row to get Total Fare
-
Sum the Passengers column and sum your newly created Total Fare column
-
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.
Comments (0)
Contact Us
NTL Reference Librarians provide services for the transportation community and general public. Specific services are:
- Basic research assistance with Bureau of Transportation Statistics (BTS) publications and data products
- Assistance with access to information resources in ROSA P
- Referrals to operating administrations within US DOT
These FAQs cover topics related to BTS. Please see the DOT homepage for access to all DOT Administrations.
Can't find the answer you're looking for in the FAQs? Contact us for help.