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.
N7VSikorsky S-38-C · S/N 314-11N192HAeromarine Klemm L 25 A · S/N 2-25N706MParks P-1 · S/N 1991N12354Curtiss-Wright T-32-C CONDOR II · S/N 22N13302Boeing 247-A SPECIAL · S/N 1683N18HRyan B-5 · S/N 203N957KParks P-1 · S/N 1989N12050Church Airplane & Mfg MIDWING · S/N R-3-31N710YPilgrim PITTS SPECIAL S-1 · S/N 6606N982MAmerican Airplane & Engine PILGRIM 100A · S/N 6611N12057South Park Glider Club SOUTH PARK GLIDER · S/N SPC-2N4329American Eagle 101 · S/N 101N13322Boeing 247D · S/N 1703N672Yackey SPORT · S/N 1N13304Boeing 247-A SPECIAL · S/N 1685N378VPitcairn PA-6 · S/N 142N9790Fokker F-10-A(FXA) · S/N 1036N12194Stinson U · S/N 9020N914KParks P-1 · S/N 1982N12994Byrd-Wendt BYRD-WENDT · S/N BW-7-1N10351Boeing 40-B-4 · S/N 1432N688EBellanca CH300 PACEMAKER · S/N 137N31WAdam Biolowski BIOLOWSKI · S/N 100-AN805EFokker F-10-A(FXA) · S/N 1034N451Star CAVALIER · S/N 104N10517Ketchum J/Youngquist A HIGH WING MONOPLANE · S/N A-10N10541North Side Glider Club NORTH GLIDER · S/N 1N12054Howard Butters/Hoy Cranston GLIDER · S/N 011N8799Cessna AW · S/N 184N10470Mead Gliders MEAD L-4 GLIDER · S/N G-5N732NAmerican Airplane & Engine PILGRIM 100A · S/N 6612N10469Mead Gliders MEAD L-3 GLIDER · S/N G-4N12075Loren D Mitchell MITCHELL BUZZARD · S/N A-106N2525Standard J-1 · S/N 10-SN401Standard J-1 · S/N 122SUBN3355Waco 9 · S/N J595N355MCurtiss Wright TRAVEL AIR 2000 · S/N 1289N2368Waco 9 · S/N 292N281MChurch James JC-2 · S/N LR-1N81NAlliance ARGO · S/N 118N738NAmerican Airplane & Engine PILGRIM 100B · S/N 6702N1872Curtiss Aeroplane & Motor CURTISS JN-4D · S/N 505N10542Trower Stallard PARASOL · S/N 1N3588Stinson SB-1 · S/N 102N39Swallow Airplane Mfg SWALLOW LAND PLANE · S/N 845N110NM W Z W LB 5D · S/N MWZ-1N66Curtiss Wright JN4D · S/N 6000N10481De Maeyer Florent PARASOL · S/N 1N3007Ryan B1 · S/N 31N801KGreat Lakes 2T-1 · S/N 62
Back to Chicago, IL