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.
N9141KStinson 108-1 · S/N 108-2141N7891DPiper PA-22-150 · S/N 22-5513N8332BCessna 172 · S/N 36132N83335Aeronca 7AC · S/N 7AC-2002N9755EAeronca 11AC · S/N 11AC-1401N3136DCessna 180 · S/N 31934N6387ACessna 182 · S/N 33187N360AMooney M-18L · S/N 21N8828CPiper PA-22-135 · S/N 22-1441N6451ACessna 182 · S/N 33251N1122PPiper PA-23 · S/N 23-132N3856PPiper PA-22-150 · S/N 22-3548N989BBell 47G · S/N 1404N974BBell 47G · S/N 1377N6856MStinson 108-3 · S/N 108-4856N777VBeech D18S · S/N A-46N978BBell 47G · S/N 1379N9789BCessna 180A · S/N 50087N2655BAero Commander 560 · S/N 155N80269Culver V · S/N V-188N39245Taylorcraft BC12-D · S/N 6499N250BColonial C-1 · S/N 10N3869CCessna 180 · S/N 31017N6534ACessna 180 · S/N 32431N3447CCessna 170B · S/N 26490N4173BAero Commander 520 · S/N 52079N999SNorth American NAVION · S/N NAV-4-90N3420DCessna 170B · S/N 26963N2119CCessna 195B · S/N 16104N6688HPiper J3C-65 · S/N 19898N4820APiper PA-22-150 · S/N 22-3973N6219ACessna 182 · S/N 33019N12365Curtiss-Wright T-32-C CONDOR II · S/N 25N91667North American NAVION · S/N NAV-4-165N856BMooney M20 · S/N 1017N64001Lockheed PV-1 · S/N 5326N4349KRyan NAVION · S/N NAV-4-1349N8016KStinson 108 · S/N 108-3016N89549Cessna 140 · S/N 8589N3383Curtiss Wright JN4C · S/N 21N4133MPiper PA-12 · S/N 12-3030N75387Curtiss Wright C-46A · S/N 26945N78190Globe GC-1B · S/N 2190N79588Cessna T-50 · S/N 5441N59236Boeing A75N1 · S/N 75-2851N88866Cessna T-50 · S/N 6260N34668Stinson 10A · S/N 7968N72124Cessna 140 · S/N 9291N1930PPiper PA-22 · S/N 22-2681N5651NConsolidated Vultee BT-15 · S/N 1109
Back to Chicago, IL