By the Numbers: Methodolgy

Updated:9/30/2019 - M. Lawder
The data used for these posts is sourced from a couple of different databases and tables obtained from the Beraeu of Transportation website. The tables used include: The T-100 data is used to calculate the departures, the passenger totals and the load factors. The DB1B Coupon Data is used to map regional carrier flights to their mainline airlines based on the ticketing airline. The DB1B Market data is used for all of the O&D calculations. Both DB1B tables are only use 10% of all airline ticket and therefore are only an estimation and info for based on these numbers contains a small margin of error.

Metrics
  • Direct Route Stats (using T-100 segment data selected for the Main airport & Airline and then aggregated by Destination [either Origin field or Dest field depending on Arrival or Departure])
    • Passengers - Sum of Passengers field
    • Load Factor - Sum of Passengers field divided by Sum of Seats field
    • Departures - Sum of DepPerformed field
    • Avg Trip Time - Sum of RampTime field divided by Sum of DepPerformed field
    • Avg Taxi Time -(Sum of RampTime field minus Sum of AirTime field) divided by DepPerformed field
  • Aircraft Type Stats (using T-100 segment data selected for the Main airport & Airline and then aggregated by AircraftType field)
    • Departures - Sum of DepPerformed field
    • % Departures - Sum of DepPerformed field divided by Total Departures
    • Passengers - Sum of Passengers field
    • % Passengers - Sum of Passengers field divided by Total Passengers
    • Load Factor - Sum of Passengers field divided by Sum of Seats field
  • Origin and Destination Stats (using DB1B Market table selected for the Main airport & Airline and then aggregated by Destination)
    • Passengers (OD) - Sum of Passengers field
    • OD Dest Rank at STL - rank of airline based on Passengers (OD) compared to all airlines with routes from Main airport
    • Avg Fare - After removing all fares less than $15, Sum of MktFare field divided by Sum of Passengers field
    • Pct Free - After selecting only fares less than $15, Sum of Passengers field divided by Sum of Passengers field (Total Passengers, without any fare selection)