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.
N54322Cessna T-50 · S/N 2756N744KWallace B-330 · S/N 14N201HFairchild KR-31 · S/N 297N17841Piper J-2 · S/N 1276N39320Aeronca 65-CA · S/N CA18122N630EAmerican Eagle 101 · S/N 367N37090Luscombe 8A · S/N 1751N87297Erco 415-C · S/N 470N10546Swanson W15 · S/N 1N47330Taylorcraft DCO-65 · S/N L-5174N19505Piper J-2 · S/N 1705N34224Mead GLIDER · S/N G-212N9633Buhl CA-6 · S/N 48N40005Stinson L-5 · S/N 76-628N9533HFairchild M-62C(PT-23A) · S/N FE-53N1957PPeter W Kramer PA18 · S/N 18-4184N93937Ercoupe 415-C · S/N 1260N51398Fairchild M-62A · S/N T42-3868N287Boeing 40B · S/N 898N22085Luscombe 8A · S/N 907N16233Waco EQC-6 · S/N 4440N25611Douglas DC-3A-S1C3G · S/N 3255N25618Douglas DC3A · S/N 3262N25615Douglas DC-3A-S1C3G · S/N 3259N225Waco UPF-7 · S/N 5308N16456Commonwealth REARWIN 7000 · S/N 481N14065Waco YKC · S/N 3989N179NBellanca CH400 SKYROCKET · S/N 601N907KCurtiss Wright ROBIN · S/N 505N16090Douglas DC3A-SC3G · S/N 1929N8704Travel Air A-6000-A · S/N 981N8820Stearman C3-B · S/N 235N17311Lockheed 12A · S/N 1211N17743Waco YKS-7 · S/N 4669N721MRyan B-7 · S/N 253N9036Travel Air 4000 · S/N 837N23469Piper J3F-50 · S/N 3190N14502Buhl CA-6 · S/N S-420N9419Laird LCR-300 · S/N 179N960KParks P-1 · S/N 198-12N31600Howard DGA-18 · S/N 600N13339Boeing 247D · S/N 1721N16072Douglas DC3A · S/N 1912N25678Douglas DC-3A-S1C3G · S/N 2175N203WStinson SM-8A · S/N 4018N8153Travel Air 2000 · S/N 917N16086Douglas DC3A · S/N 1925N3962Waco GXE · S/N 1261N25421Porterfield CP-50 · S/N 595N378KRyan B-5 · S/N 215
Back to Chicago, IL