Open Trips Activity
Open Trips tracks all changes made to trips available in the open trips pool — additions, removals, and modifications. Daily row counts reflect how actively the scheduling operation is managing open trips across bid groups on any given day. High activity can indicate operational disruptions, heavy re-crewing, or period-end schedule adjustments.
Monthly Open Trips Activity
Daily Open Trips row count for the selected month and filters. High activity can indicate operational disruptions, heavy re-crewing, or period-end schedule adjustments. Red bars exceed the 1.5σ threshold — computed across all historical days in the filtered dataset — flagging days with unusually high scheduling activity. The dashed threshold line recalculates each time a filter changes.
Recent Open Trips Activity (60 days, all bases)
60-day rolling view of total daily Open Trips rows across all bases — unfiltered, showing the broad trend. Day markers help identify weekly patterns in scheduling activity.
Database Summary
| Database | Total Rows | Reserve Count | Premium Count | First Scrape | Last Scrape |
|---|---|---|---|---|---|
| 320_CA | 58,258 | 6,514 | 965 | 2026-04-25 | 2026-05-01 |
| 320_FO | 63,235 | 7,380 | 976 | 2026-04-25 | 2026-05-01 |
| 737_CA | 54,451 | 6,308 | 1,577 | 2026-04-25 | 2026-05-01 |
| 737_FO | 59,884 | 7,007 | 1,170 | 2026-04-25 | 2026-05-01 |
About This Site
This site displays aggregated Open Trips flight data statistics. No individual pilot information is shown. Navigate using the menu above to explore Daily Open Trips counts, Premium trips, Reserve trips, and Aggressive Pickup trips.