OnTime Analyst Dashboard
Awaiting query run

Highest daily hops for one aircraft on one flight number

Lead itinerary map for the top-ranked daily hop chain, with route repetition context from the saved analytical query and airport-coordinate enrichment from ontime.airports_latest.

Lead Itinerary Map

The selected itinerary route redraws here. Airport coordinates are added by a separate enrichment query.

Map ready for itinerary enrichment

The first successful primary query will render the lead itinerary immediately and upgrade the map once airport coordinates are available.

Map stays visible even if enrichment is still pending or degraded.

Legend

Route styling and repetition context

Highlighted itinerary path
Selected aircraft-day route
Airport stop
Ordered stop sequence
Repeated-route context
Repeated within the ranked top 10
Max-hop cohort
Rows tied at the overall hop maximum

Route Sequence And Detail

Click an itinerary row to refresh this panel and redraw the selected route.

Top 10 Itineraries

Rows are ordered by hop count, date, and aircraft ID. Selecting a row updates the map and route details only.

Aircraft Flight Date Hops Route Repeated Route

Query Ledger

Primary and enrichment queries are tracked together. Expand any entry to review the full SQL text.