Staunton, IL
Cancelled registrations · 199
Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_state = 'IL' AND d.registrant_city = 'STAUNTON' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"
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 d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_state = 'IL' AND d.registrant_city = 'STAUNTON' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
Run 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.
N5142DCessna 182A · S/N 51242N50021Cessna 150H · S/N 15069016N7648MCessna 175 · S/N 55948N4824BCessna 152 · S/N 15283657N733YACessna 172N · S/N 17268644N738UBCessna 172N · S/N 17270238N6342APiper PA-38-112 · S/N 38-78A0390N6634RBeech C23 · S/N M-2203N6013ACessna 172 · S/N 28613N4915QCessna A188B · S/N 18802650TN4946GCessna 172N · S/N 17273493N5328WPiper PA-28 · S/N 28-385N9441JCessna T188C · S/N T18803806TN4628PPiper PA-23-250 · S/N 27-146N33828Piper PA-28R-200 · S/N 28R-7535201N3941SCessna 172E · S/N 17251141N3746XAero Commander 100-180 · S/N 5057N6301ZPiper PA-25 · S/N 25384N3088TPiper PA-28-140 · S/N 28-7225544N2864VBeech 35 · S/N D-269N152AJCessna 150 · S/N 15283988N1409FCessna 172H · S/N 17254904N36066Piper PA-28R-201 · S/N 28R-7837263N3586QCessna 172M · S/N 17261686N52528Boeing A75N1(PT17) · S/N 75-4617N3084TPiper PA-34-200 · S/N 34-7250339N6568ZPiper PA-25-235 · S/N 25-2116N19823Cessna 177B · S/N 17702604N98376Piper J3C-65 · S/N 18555N2309WBeech A23A · S/N M-911N3236YPiper PA-28-180 · S/N 28-1161N1729KCessna 310D · S/N 39263N24674Beech B19 · S/N MB-571N2035YCessna 172C · S/N 17249535N93SPBeech E-55 · S/N TE-1064N8292NPiper PA-28-140 · S/N 28-25510N7628VCessna 177RG · S/N 177RG0896N1109FCessna 172G · S/N 17254704N1156FCessna 172G · S/N 17254751N2961RPiper PA-28-161 · S/N 28-7916593N150SSCessna 150 · S/N 17991N1140UCessna 172M · S/N 17266869N5272WPiper PA-28-160 · S/N 28-318N58117Bell 206B · S/N 3851N450SBeech 35 · S/N D-1157N37634Taylorcraft DCO-65 · S/N 5367N776GTCessna 152 · S/N 15282789N6299GCessna A188B · S/N 18801182TN6222MStinson 108-3 · S/N 108-4222
Back to Staunton, IL