Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('2072420')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('2072420')
ORDER BY n_numberRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N6097RBravo Charlie One LLC · Redkey, INN61LVHolt Daniel E Jr · Fayetteville, TNN65WBMckamey Robert S · Tullahoma, TNN707JYBest Glide LLC · Davie, FLN711SNSkywatch Aviation LLC · French Village, MON724LCDixon Jody S · Chancellor, ALN724TJPellow James A · Dixie, WAN727KDReich Brad Roy · Rohnert Park, CAN727LCBurmaster Christopher R · Murfreesboro, TNN72PFKuck Russell W · Aguila, AZN814DEDickinson Dennis D · St Pete Beach, FLN885DERoberts James A · Hamburg, ARN888HHanley Michael · Paw Paw, MIN88KWDonnell James C · Crowville, LAN890PGCp Air LLC · Indianapolis, INN891SROmalley Benjamin P · River Falls, WIN901RJMiller James A · Granada Hills, CAN9029DKemp Ted · Pleasant Shade, TNN94CAYoung James W · Seattle, WAN979JFGoodspeed Air Service LLC · Oxford, CTN991NADatkuliak Michael C · Beallsville, OHN994NACurry Lloyd F · Karnack, TX
Back to Cessna 172G