OpenAirDocs.org
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.

N73989Bell 47G-2A-1 · S/N 2879Cancelled Nov 22, 1971 · Chicago Helicopter Industries IncN9874ZBeech C-45H · S/N AF-304Cancelled Nov 18, 1971 · Exported to Canada · Built 1953 · Rezman Norman J/ DBA Norman AircraftN37591Douglas DC-6A · S/N 44906Cancelled Nov 3, 1971 · Exported to Ecuador · United Air Lines IncN4722JBeech A23-19 · S/N MB-180Cancelled Nov 2, 1971 · Built 1966 · National Air IncN2466BBell 47H-1 · S/N 1357Cancelled Sep 14, 1971 · Butler Aviation-Helicopter Flight IncN35606Piper J5A · S/N 5-699Cancelled Aug 27, 1971 · Majdrich DanN22532Cessna 150H · S/N 15068342Cancelled Jul 17, 1971 · Built 1968 · Dohnal Robert F DBAN35541Cessna 172I · S/N 17256822Cancelled Jul 15, 1971 · Aero Training Activities IncN4148TCessna 320D · S/N 320D0048Cancelled Jul 15, 1971 · Aviation Sales ConsultantsN1058CBeech 99 · S/N U-21Cancelled Jul 13, 1971 · Exported to France · Built 1968 · American National Bank And Trust Co Of Chicago TrN4922VDehavilland DH104 DOVE 7AXC · S/N 04285Cancelled Jul 8, 1971 · Fischback & Moore Electrical And ContractingN609TBeech 35 · S/N D-5749Cancelled Jun 7, 1971 · Casement Hardware CoN164UBeech D18S · S/N A-940Cancelled Apr 8, 1971 · Exported to Canada · Levitt Ed M DBA Walworth Equipment LeasingN1012USud SE 210 CARAVELLE VIR · S/N 97Cancelled Mar 9, 1971 · Exported to Belgium · United Air Lines IncN2433VCessna 140 · S/N 14682Cancelled Mar 5, 1971 · Wolatz EdwardN6351CDouglas DC-7 · S/N 45484Cancelled Mar 3, 1971 · United Air Lines IncN1410Fairchild F-27F · S/N 84Cancelled Mar 1, 1971 · Exported to Canada · Weiss Harold AN7889PPiper PA-24-250 · S/N 24-3118Cancelled Feb 10, 1971 · Stalzer Edward V MdN7477HPiper J3C-65 · S/N 20744Cancelled Feb 9, 1971 · Rogers Raymond FN9049JPiper PA-28-180 · S/N 28-3080Cancelled Feb 9, 1971 · Becker Norman JosephN1011USud SE 210 CARAVELLE VIR · S/N 96Cancelled Feb 2, 1971 · Exported to Belgium · United Air Lines IncN5128BFairchild C-82 · S/N 45-57804Cancelled Jan 26, 1971 · Bankers Life & Casualty CoN50029Cessna T-50 · S/N 5334Cancelled Jan 25, 1971 · Levy Richard RN5104BFairchild C-82 · S/N 45-57776Cancelled Jan 25, 1971 · Bankers Life & Casualty CoN5105BFairchild C-82 · S/N 45-57775Cancelled Jan 25, 1971 · Bankers Life & Casualty CoN5107BFairchild C-82 · S/N 45-57770Cancelled Jan 25, 1971 · Bankers Life & Casualty CoN5108BFairchild C-82 · S/N 45-57765Cancelled Jan 25, 1971 · Bankers Life & Casualty CoN5127BFairchild C-82 · S/N 45-57803Cancelled Jan 25, 1971 · Bankers Life & Casualty CoN42315Piper J3C-75 · S/N 14565Cancelled Jan 12, 1971 · Built 1945 · Hoyt William MN1748EAeronca 7AC · S/N 7AC5315Cancelled Jan 5, 1971 · Don Dewirr HerzegN8821CPiper PA-20 · S/N 20-1020Cancelled Jan 4, 1971 · Glenn K ManacherN9037TCessna 182C · S/N 52937Cancelled Jan 4, 1971 · Fidelity Properties IncN37505Douglas DC-6 · S/N 42870Cancelled Dec 31, 1970 · United Air Lines IncN37516Douglas DC-6 · S/N 43005Cancelled Dec 31, 1970 · United Air Lines IncN818RBeech K35 · S/N D-5981Cancelled Dec 31, 1970 · Built 1959 · The Evangelical Covenant Church Of AmericaN6836NMooney M20C · S/N 680125Cancelled Dec 30, 1970 · Van De Sande George AN1019ZEaa Chapter 101 CONTESTER A · S/N 1Cancelled Dec 29, 1970 · Tefft LeonN549LKMitsubishi MU-2B · S/N 022Cancelled Dec 21, 1970 · Built 1967 · Lbk Investments CoN86183Aeronca 11AC · S/N 11AC-613Cancelled Dec 14, 1970 · Francis KroneN2492BBell 47H-1 · S/N 1364Cancelled Dec 4, 1970 · Helicopter Air Lift IncN1060MBoeing 247D · S/N 1692Cancelled Nov 30, 1970 · Built 1933 · Atlas Airways IncN378CStinson 108-2 · S/N 108-3378Cancelled Nov 23, 1970 · Bassett George LN7425UBoeing 727-22C · S/N 19200Cancelled Nov 23, 1970 · United Air Lines IncN7460Vickers VISCOUNT 745-D · S/N 215Cancelled Nov 18, 1970 · United Airlines IncN9005UBoeing 737-222 · S/N 19043Cancelled Nov 17, 1970 · United Air Lines IncN1015USud SE 210 CARAVELLE VIR · S/N 100Cancelled Nov 16, 1970 · Exported to Netherlands · United Air Lines IncN7438Vickers VISCOUNT 745-D · S/N 136Cancelled Nov 9, 1970 · United Air LinesN93558Ercoupe 415-C · S/N 881Cancelled Oct 14, 1970 · Built 1946 · Ferdinand M RN6061VAeronca 7BCM · S/N 7BCM-24Cancelled Oct 9, 1970 · Civil Air Patrol Incillinois WingN5103BFairchild C-82 · S/N 45-57778Cancelled Oct 8, 1970 · Bankers Life & Casualty Co
Back to Chicago, IL