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.
N3857Dehavilland 4B (MAIL) · S/N 348N2797Standard STANDARD J-1 · S/N A-1118N27Curtiss Aeroplane & Motor CARRIER PIGEON · S/N 1N790Douglas M-4 · S/N 653N1829Dehavilland 4B (MAIL) · S/N 376N792Douglas M-3 · S/N 650N4623Pheasant H-10 · S/N 115N5008National Airways System AIR KING 28 · S/N 159N5595Curtiss Wright JN4C · S/N 125N1360Swallow Airplane Mfg SWALLOW LAND PLANE · S/N A-1942N5331Curtiss JN4C · S/N C 1222N2187Curtiss JN4D · S/N 259N3156Waco 10 · S/N 819N2799Standard J-1 · S/N A-1120N2622Waco 9 · S/N 376N1595Swallow Airplane Mfg K · S/N 223N2098Butte Gorenflo & Brady BGB MIDWING · S/N 295N201Curtis Oriole Club C-6 ORIOLE · S/N C-6N18633Curtiss Wrightaeroplane CARRIER PIGEON 2 · S/N K-5015-7N2173Laird CABIN BIPLANE · S/N A-371N1032Curtiss Aeroplane & Motor LAND PLANE · S/N 8N1002Douglas M-3 · S/N 621N10VSikorsky S-38-C · S/N 314-14N1134Curtiss Wright JN4C · S/N A-132N1160E M Laird LAIRD COMMERCIAL · S/N 148N1275Likosiak Kazimir LIKOSIAK BIPLANE · S/N A-1880N1487HAeronca 15AC · S/N 15AC-557N17152Stinson SR-9B · S/N 5113N2295Standard J-1 · S/N 7078N2303Allred Earl F THOMAS MORSE BIPLANE · S/N A-570N2354Curtiss JN4D · S/N A-621N2583Canuck BIPLANE · S/N A-885N5863Pitcairn PA-5 · S/N 25N60166Cessna T-50 · S/N 5066N61379Cessna T-50 · S/N 6433 (43-32495)N61805Cessna T-50 · S/N 6048N64221Cessna T-50 · S/N 4642N650Standard J-1 · S/N 120N6605U S U S BIPLANT NO 11 · S/N 11N6797Lincoln LINCOLN PAGE 3 · S/N 234N69404Cessna T-50 · S/N 5616N69704Cessna T-50 · S/N 2687N730NConsolidated 17 FLEETSTER 2-H · S/N 7
Back to Chicago, IL