Average Departure Delay by Month
Monthly average `DepDelay` for completed AA flights with non-null departure delay values.
OnTime Network Dashboard
American Airlines peak network delay month and contributors
This dashboard finds American Airlines’ worst monthly departure-delay period from the live monthly series, then drills into the origins and routes that carried the largest share of that peak-month delay burden.
Awaiting token and query execution.
Enter a valid JWE token in the footer, then run the saved SQL. The page keeps the header visible before data loads and records every executed query in the ledger.
Peak-Month KPIs
Derived directly from the monthly American Airlines series and the live peak-month drill-down.
Network-Wide Trend
The time series covers every AA month returned by the primary query. The worst month is derived from the fetched ranking, then highlighted and annotated.
Interpretation
This panel bridges the network-wide series to the peak-month contributor breakdown.
Peak-Month Drilldown
Origins and routes below are fetched only after the peak month is identified from the primary series.
Top Origin Contributors
Delay-minute share is measured against the full AA network total for the peak month.
Route Contribution Table
Route shares remain relative to the full peak-month AA network, with a readability threshold and interactive row export.
| Route | Origin | Destination | Flights | Avg Dep Delay | % DepDel15 | Delay Minutes | Delay Share |
|---|
Query Ledger
Every browser query is registered immediately, updated with status and row count, and can be expanded to reveal the full SQL text.