airport_fleet_mix

com.airsidelabs/aviation-tools · Verify this server

What aircraft types fly from (or into) an airport, how often, with how many seats, and at what load factor, over the last N months of BTS T-100 data? Returns each type's departures performed and share of the airport's departures, seats, passengers, load factor, seats per departure, and how many carriers and destinations it serves, plus airport totals. `direction` is `departures` (default) or `arrivals`. `months` defaults to the last 12 of the window; pass null for the whole window. Scheduled passenger service only. This is the fleet-mix question a planner asks before sizing a route or a gate: what the airport is actually flown with, from the census of segments carriers file, not from a schedule or a fleet list. Reading the answer: `status` is resolved or no_service. `totals` and `monthly` are sums of BTS-reported departures performed, seats and passengers; `load_factor` is passengers over seats. `provenance.edition` is the latest month held and `provenance.window` the months summed -- BTS publishes about three months in arrears, so this is accurate for its period and NOT current. Aircraft are given as the ICAO designator where the BTS type code is verified against FAA JO 7360.1K, otherwise as BTS's own description with `icao_designator` null and a note; never invent the designator. Pass an ICAO designator to resolve_aircraft_type for the type's certified and typical seating. Coverage is T-100's: US carriers everywhere, foreign carriers only to and from the US. Fares are not held; report_unmet_need records what was wanted.