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.
N3818DBeech 77 · S/N WA-221N17109Cessna 150L · S/N 15073629N8652UCessna 172F · S/N 17252554N7697RBeech A24 · S/N MA-364N182BHCessna 182B · S/N 51741N19863Cessna 172M · S/N 17260814N2859RCessna 182K · S/N 18258459N2874TPiper PA-34-200 · S/N 34-7250179N6106KCessna 150M · S/N 15077528N1690YCessna 172C · S/N 17249390N9853TCessna 172A · S/N 47653N3120JCessna 150G · S/N 15065820N1550QCessna 150L · S/N 15072850N9101HCessna 172M · S/N 17265945N1044UPiper PA-34 · S/N 34-7250028N80624Cessna 172M · S/N 17266675N8382XCessna 172C · S/N 17248882N8512CPiper PA-22-135 · S/N 221223N704LBCessna 150M · S/N 15078686N6964GCessna 150L · S/N 15072464N1035JAero Commander 112 · S/N 35N5851BCessna 182A · S/N 33851N10239Cessna 150L · S/N 15074823N93644Cessna 152 · S/N 15285530N2175XCessna 337 · S/N 337-0075N9745GCessna A188B · S/N 18801585TN9896VCessna A188 · S/N 188-0146N704MECessna 150M · S/N 15078713N6709TCessna 310C · S/N 39009N7428MCessna 175 · S/N 55728N2929LPiper PA-23-250 · S/N 27-3215N8630SCessna 150F · S/N 15061930N8374UCessna 172F · S/N 17252274N8530ABeech A35 · S/N D-1952N7986UCessna 150M · S/N 15077875N79918Cessna 172K · S/N 17258246N8159VCessna A150M · S/N A1500546N779VMPiper PA-28-180 · S/N 28-4699N1063UPiper PA-34-200 · S/N 34-7250049N6982HCessna 172M · S/N 17265680N6829HCessna 172M · S/N 17265598N65559Cessna 152 · S/N 15281617N60731Cessna 150J · S/N 15070532N5518DCessna 172N · S/N 17272590N5531YPiper PA-23-250 · S/N 27-2629N4724RCessna A188B · S/N 18802306TN55VHRockwell International 112A · S/N 246N2971ACessna 180 · S/N 30171N1308WMooney M20E · S/N 196N35274Cessna 177B · S/N 17702304
Back to Staunton, IL