Bts Ontime MCP server

@pipeworx/bts-ontime

US domestic airline on-time performance and delay causes: monthly on-time %, average arrival delay, cancellations, diversions, and delay minutes broken down by cause (carrier, weather, air-traffic-control/NAS, security, late aircraft) — by route, by carrier, and by arrival airport. Fleet #2953.

Part of Pipeworx — an MCP gateway connecting AI agents to 1779+ live data sources. This is an independent, unofficial integration — not affiliated with, endorsed by, or published by the upstream provider.

Tools

performance for one origin->destination route, optionally scoped to one carrier. Each month carries flights, completed flights, on-time arrivals and on-time %, average arrival delay, cancellations, diversions, and delay minutes by cause.

• route_ontime(origin, dest, carrier?, months?) — monthly on-time

aggregated across one airline's whole network (or just the flights touching one airport).

• carrier_ontime(carrier, airport?, months?) — the same monthly shape,

delay-cause breakdown by carrier for flights ARRIVING at one airport, optionally scoped to a year and/or month. limit defaults to 50 (max 200); a response with more matching rows than returned carries truncated: true and total_matching rather than silently dropping them.

• btsairportdelays(airport, year?, month?, limit?, offset?) —

delay-cause rows, organized by year first, for scanning a whole year across carriers or airports. Same limit/truncated/totalmatching pagination as btsairport_delays.

• delay_causes(year, carrier?, airport?, limit?, offset?) — the same

Call this first if you're not sure a given period is covered.

• list_coverage() — the earliest/latest month actually loaded, and when.

Carrier accepts either the 2-letter reporting-carrier code ("DL") or a common airline name ("Delta"). Airport codes are validated against what is actually loaded (not a static list) — an unrecognized code is refused with a clear error, never an empty success.

Auth

Keyless. The tools answer only through the Pipeworx gateway, which holds the data; a standalone npm install has no data to read, and every tool throws a clear "not bound in this runtime" error there instead of returning an empty list.

Data sources

Carrier On-Time Performance" monthly bulk data. US federal government work: public domain (17 U.S.C. §105). The agency publishes bulk files only (no live query API for this dataset), so this pack builds a copy (scripts/bts-ontime/load-data.mjs) rather than proxying — raw flight-level rows (~600k/month) are never stored; the loader aggregates each month down to two small tables and discards the raw file before moving to the next one.

• US DOT Bureau of Transportation Statistics (BTS), TranStats — "Reporting

What delay_cause is, and is not

BTS separately publishes its own "Airline Delay Cause" product, which apportions each delayed flight's minutes into fractional per-cause counts via a methodology this pack does not reimplement. The delaycause table here is derived from the same underlying per-flight delay-minute fields (carrier/weather/NAS/security/late-aircraft) as routemonth, rolled up by carrier x arrival-airport x month, and reported as minute sums, not fractional counts. It will be consistent with BTS's own published cause breakdown but is not guaranteed to match it row-for-row — this is one pipeline over one raw source, not a second download of BTS's own aggregate.

Known gaps — read before extending this pack

Shortened. The full README is on GitHub.