U.S. Airport Pair Airfare and Passenger Traffic Data

Airfare and passenger traffic data aggregated for directionless markets between U.S. airport pairs. Records are limited to airport pairs where at least one airport shares its city with other commercial airports. The dataset is published by the U.S. Department of Transportation's Office of Aviation Analysis and was last updated in April 2026.

Use Cases

• Analyze fare_lg and fare_low price differences between competing airports in the same city using airport_1 and airport_2.
• Model passenger traffic volume based on nsmiles (distance) and carrier_lg presence for specific airport pairs.
• Track quarterly fare and passengers trends over time using the Year and quarter columns.
• Compare market share of large carriers (large_ms) versus medium carriers (lf_ms) across different Geocoded_City markets.

Strengths

• Includes data for airport pairs where cities have multiple commercial airports, enabling competition analysis.
• Provides aggregated directionless market data combining traffic in both directions for a complete view.

Limitations

• Dataset size and row count are unknown, preventing assessment of statistical power.
• Sample data is unavailable, making initial data validation and structure inspection impossible.

Provenance

Source

U.S. Department of Transportation, Office of Aviation Analysis.

Collection Method

Aggregated from commercial air traffic reports.

Time Range

null

Freshness

Last updated April 2026.

Geography

United States airport pairs.