Highest daily hops for one aircraft on one flight number
Dynamic route dashboard for the top-ranked aircraft-day itineraries. The lead itinerary anchors the KPI strip,
while row selection redraws the itinerary map and route sequence without changing the headline ranking context.
Visual mode: dynamic
Visual type: html_map
Dataset scope: ontime.ontime + ontime.airports_latest
Awaiting token and query execution.
Lead-Itinerary Map
Airport-coordinate enrichment upgrades the plotted route when lookup rows are available. The map card remains present even in degraded state.
Selected itinerary
Load the primary result set to render the lead itinerary and queue airport-coordinate enrichment.
Airport stop
Selected itinerary path
Context route direction
Degraded map keeps non-map analysis active
Route Sequence
Selection-sensitive detail panel for hop order, airport names, and repetition context inside the loaded result set.
| Aircraft ID |
Flight Number |
Carrier |
Date |
Hops |
Route |
Query Ledger
Unified provenance for the primary analytical query and airport-coordinate enrichment query. Expand any row to inspect the exact SQL.