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.
N5622BCessna 182 · S/N 33622N2885BBell 47G-2 · S/N 2429N8013UDouglas DC-8 · S/N 45290N879Sikorsky S-58C · S/N 58420N28128Piper J3C-65 · S/N 4600N1488YCessna 172 · S/N 17249188N500YLockheed PV-1 · S/N 5551N6790CBeech C18S · S/N 44-47117N3327PPiper PA-23 · S/N 23-1278N6386PPiper PA-24-250 · S/N 24-1496N91712North American NAVION · S/N NAV-4-446N8106KStinson 108-2 · S/N 108-3106N4791BCessna 180 · S/N 31689N63004Douglas A-20G · S/N 21847N8040UDouglas DC-8-12 · S/N 45307N4215PPiper PA-23-160 · S/N 23-1708N1326PPiper PA-23-150 · S/N 23-369N4404PPiper PA-23-160 · S/N 23-1916N4165EAeronca 11CC · S/N 11-CC-68N9619BCessna 180A · S/N 32916N3433PPiper PA-23-160 · S/N 23-1400N5763ECessna 150 · S/N 17263N6252BAero Commander 500 · S/N 500-656-16N5897ECessna 150 · S/N 17397N9418BCessna 175 · S/N 55218N27812Piper J4A · S/N 4-1029N7196DPiper PA-18-150 · S/N 18-5664N8251BCessna 172 · S/N 36051N1800PPiper PA-22 · S/N 22-2578N80363Beech D18S · S/N AA-17N6235BAero Commander 680-E · S/N 680E-623-1N3994FCessna 172 · S/N 36894N5101BFairchild C-82 · S/N 4557788N688DBeech C35 · S/N D2964N9807ACessna 190 · S/N 7486N3428PPiper PA-23-160 · S/N 23-1393N6436BCessna 172 · S/N 29636N1389PPiper PA-23 · S/N 23-439N6363KRepublic RC-3 · S/N 592N72629Cessna 140 · S/N 9805N4795BCessna 180 · S/N 31693N647DBeech C35 · S/N D-2913N9239CCessna 180 · S/N 31338N5100BFairchild C-82 · S/N 45-57789N9774BCessna 180A · S/N 50072N4475CCessna 195B · S/N 16084N4709APiper PA-18A · S/N 184927N9701BCessna 180A · S/N 32998N3559EAeronca 7AC · S/N 7AC-6907N8786CPiper PA-18 · S/N 18-3254
Back to Chicago, IL