Chicago, IL
Cancelled registrations · 1,693
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 = 'CHICAGO' 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 = 'CHICAGO' 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.
N35044Piper J5A · S/N 5-555N41823Cessna T-50 · S/N 5927N47683Taylorcraft DCO-65 · S/N L-5405N9535HConsolidated Vultee BT-13A · S/N 8241N4723HPiper PA-11 · S/N 11511N6164KRepublic RC-3 · S/N 352N4893VDouglas C-47 · S/N 27069N61867Cessna T-50 · S/N 3852N75292Curtiss Wright C-46D · S/N 30498N4731VDouglas DC3C-S1C3G · S/N 33573N1938MBeech C18S · S/N 29586N206BBell 47D · S/N 72N58776Douglas DC3C · S/N 13048N4673VDouglas DC3C-S1C3G · S/N 4756N4892VDouglas DC3C-S1C3G · S/N 43-49808N4908VDouglas C-47 · S/N 20193N208BBell 47D · S/N 74N63118Consolidated Vultee BT-13A · S/N 6183N62526Cessna T-50 · S/N 5501N63706Consolidated Vultee BT-13A · S/N 10820N47216Fairchild M-62A · S/N T43-7113N75293Curtiss Wright C-46A · S/N 30622N9518HFairchild M-62A-3 · S/N FT-703N1067DCessna 195 · S/N 7679N51115Cessna T-50 · S/N 5588N4888VDouglas C-54 · S/N 27323N9534HConsolidated Vultee SNV-1 · S/N 6368N2378DCessna 170B · S/N 20530N2248VCessna 140 · S/N 14479N60005Consolidated Vultee SNV-1 · S/N 7082N62BCulver V · S/N V-92N4637MPiper PA-11 · S/N 11-145N9161KStinson 108-2 · S/N 108-2161N2534CCessna 170B · S/N 26178N4668VDouglas C-47 · S/N 5994N31229Boeing 377 · S/N 15969N8470ABeech A35 · S/N D-1888N4670VDouglas C-47B · S/N 348911N88393Piper J3C-65 · S/N 16011N1360HAeronca S15AC · S/N 15AC-407N1863KLuscombe 8E · S/N 4590N9537HBeech C18S · S/N 1152N4972KRyan NAVION A · S/N NAV-4-1972N9928HConsolidated Vultee BT-13A · S/N 7415N6663NTaylorcraft 15A · S/N 5-14009N2039KLuscombe 8E · S/N 4766N2167HEngineering & Research ERCOUPE 415-C · S/N 2790N7082KPiper PA-20 · S/N 20-188N1511BLuscombe 8F · S/N 6138N77649Fairchild 24R-46 · S/N R46349
Back to Chicago, IL