OnTime dynamic analyst dashboard

Highest daily hops for one aircraft on one flight number

Longest same-aircraft, same-flight-number itineraries across the most recent five analytical years.
Enter the MCP JWE token to run the verified SQL, then review the lead itinerary, selected route map, and operational stress signals.
The dashboard shell is ready. Enter a JWE token and run the queries from the footer controls. Main content appears after the primary query succeeds.
Anchored narrative

Lead itinerary narrative

Rank 1 anchor
Selection-driven itinerary detail

Selected itinerary

    Airport-coordinate lookup

    Selected itinerary map

    Awaiting coordinates
    selected itinerary route airport markers dashboard geography context

    Route sequence and leg detail

    Leg From To Coords
    Ranked itineraries

    Top 10 unique maximum-hop itineraries

    Click a row to redraw the map, update the KPI strip, refresh the route detail panel, and rerun the operational-stress lookup for that itinerary.
    Rank Flight date Tail Flight # Carrier Hops Route recurrence Route
    Pattern summary

    Broader geographic pattern

    Derived from current main result set
    Operational-stress lookup

    Connectors, origins, termini, and stress by selected itinerary

    Awaiting selected itinerary query
    Stop # Airport Role Total apps Origin Intermediate Final Share of top 10 Avg dep delay Avg arr delay 15+ dep rate Diversion rate Stress signal
    Unified query ledger

    Executed browser queries

    SQL text hidden until expanded