Highest daily hops for one aircraft on one flight number

Tail number

Selected itinerary aircraft

Flight number

Selected itinerary flight number

Date

Selected itinerary flight date

Hop count

Distinct same-day legs in sequence

Route repetition

Historical repetition context for exact route string

Lead itinerary map

Airport-coordinate enrichment runs once per query refresh and is reused for row selection redraws.

Selected itinerary route

Lead itinerary context line

Airport markers from coordinate enrichment

The map card remains visible even before airport-coordinate enrichment succeeds.

Route sequence and detail

Sequence is derived by splitting the selected row’s Route string on “-”.

No itinerary selected yet.

Connector airports across the top itineraries

Supporting query: airport roles within the top unique high-hop routes.

Geographic extremes

Supporting query: route span, distance, state breadth, and time-zone spread.

Operational stress points

Supporting query: delays and 15+ minute disruption rates by stop position and leg.

Itinerary leaderboard

The first row returned by the primary query becomes the default selected itinerary on initial load. Clicking a row redraws the map, refreshes the KPI strip, and updates the route-detail panel while leaving the lead narrative anchored to Rank 1.

Rank	Tail	Flight	Carrier	Date	Hops	Recurrence	Route

Query ledger

Every live browser query appears here with role, date range, status, row count, and expandable SQL text.