| layout | dashboard |
|---|
from flights select
count() as flights,
count(distinct carrier) as carriers,
count(distinct origin) as airports,
count(distinct tail_num) as aircraft
An analytical record of FAA commercial flight operations — every departure, delay, and cancellation from the first half of the decade.
2000 — 2005 · FAA On-Time Performance Data
Flights
Carriers
Airports
Aircraft
PLATE 01
Top-line KPIs, monthly volume, a delay heatmap by hour and day-of-week, and a ranked table of carriers.
PLATE 02
Any airline's rank, fleet, delay distribution, and monthly trend measured against the rest of the industry.
PLATE 03
A notebook investigating what actually predicts a late departure — hour of day, airline, origin airport, day of week. One factor dominates.
carriers
one airline
code · name · nickname
carrier
flights
one scheduled flight
dep_delay · arr_delay · cancelled · aircraft_age
origin · dest
airports
one FAA facility
code · city · state · lat / long · major
tail_num
aircraft
one registered tail number
tail_num · year_built · owner
model
aircraft_models
one aircraft model
manufacturer · model · seats · engines · speed
Fig. 1 — Five tables in /tables, joined into a star around flights.
Built with Graphene · GSQL models define the joins, dimensions, and measures used across every page.