Q. How do I obtain data on average fares using DB1B Market?
The Consumer Air Fare Report provides information about average prices being paid by consumers in the top 1,000 domestic city pair markets in the continental United States: http://www.dot.gov/policy/aviation-policy/domestic-airline-consumer-airfare-report
You can also obtain data on average fares by airport pairs (or city pairs) through the Origin and Destination Survey DB1B Market database at http://www.transtats.bts.gov/DL_SelectFields.asp?Table_ID=247&DB_Short_Name=Origin%20and%20Destination%20Survey
1) Select the following fields: Origin (or OriginCityMarketID), Dest (or DestCityMarketID), Passengers, MktFare
2) Filter for Geography (by either origin or destination state), Year, and Quarter.
Note that you can only download one quarter at a time.
3) Depending on your filters, the file you download may be too large to open in Microsoft Excel. You will need to extract it to your computer and open it with a program such as Microsoft Access, SPSS or SAS. For instructions on how to open the file in Microsoft Access, filter your data, and transfer it to Excel, see the following
4) Once you have pasted or imported your data into Excel, 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.
For additional information on obtaining air fare data, please see the following