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.

N7464Vickers VISCOUNT 745-D · S/N 285Cancelled Apr 11, 1974 · United Air Lines IncN101FTAmerican AA-1 · S/N AA1-0403Cancelled Apr 8, 1974 · Built 1970 · Flightech IncN293FWBell 206A · S/N 576Cancelled Apr 5, 1974 · Exported to United Kingdom · Air Associates IncN7927HPiper PA-12 · S/N 12-832Cancelled Mar 20, 1974 · Exported to Canada · Wisneski Marvin EN6268KRepublic RC-3 · S/N 478Cancelled Feb 22, 1974 · Exported to Canada · Krone Francis MN85681Aeronca 7AC · S/N 4426Cancelled Feb 14, 1974 · Exported to Canada · Built 1946 · Mortimer J S JrN566ELockheed 1049H · S/N 4838Cancelled Jan 13, 1974 · Muhammads Temple #2 Of The Holy Nation Of Islam InN7899SBell 206A · S/N 257Cancelled Jan 10, 1974 · Exported to Canada · Air Associates IncN98013Piper PA-28-140 · S/N 28-25997Cancelled Nov 15, 1973 · Justus V RN3249PPiper PA-23-160 · S/N 23-1194Cancelled Oct 1, 1973 · Edison L HoardN42613Cessna 182L · S/N 18259106Cancelled Jul 6, 1973 · Exported to Canada · Arcy Aircraft Sales IncN7705Dehavilland DHC-6 · S/N 5Cancelled Jun 25, 1973 · Otter Amalgamated Joint Venture 2N9302GCessna 182P · S/N 18260842Cancelled Jun 25, 1973 · Trans Union Aircraft Leasing CorporationN713EMBell 206A · S/N 144Cancelled Jun 4, 1973 · Exported to Italy · Built 1968 · Air Associates IncN7612YPiper PA-30 · S/N 30-684Cancelled May 25, 1973 · Leaner George WN4588LCessna 340 · S/N 340-0156Cancelled May 11, 1973 · Exported to United Kingdom · Norman AircraftN2261WBell 206A · S/N 464Cancelled Apr 2, 1973 · Exported to United Kingdom · Air Associates IncN83236Bell 206B · S/N 960Cancelled Mar 19, 1973 · Exported to United Kingdom · Air Associates IncN95412Piper PA-28-140 · S/N 28-25931Cancelled Mar 9, 1973 · Exported to Canada · Flightech IncN114JBeech D18S · S/N A-976Cancelled Nov 15, 1972 · Kearby RichardN1532PPiper PA-22-135 · S/N 22-2397Cancelled Nov 15, 1972 · Ohare Aero ClubN200DLCessna 337 · S/N 337-0234Cancelled Jun 2, 1972 · Exported to Canada · Arcy Aircraft Sales IncN88NTemco D-16 · S/N TTN-14Cancelled May 11, 1972 · Built 1949 · Rafael RichardN425DDehavilland DH104 DOVE 6A · S/N 04320Cancelled May 8, 1972 · Built 1951 · Fidelity Properties IncN7843SBell 206A · S/N 43Cancelled Apr 19, 1972 · Exported to Canada · Chicago Helicopter Industries IncN4029PPiper PA-23-160 · S/N 23-1504Cancelled Apr 7, 1972 · Dupage Aviation CorpN1009USud SE 210 CARAVELLE VIR · S/N 94Cancelled Mar 22, 1972 · Exported to Denmark · United Air Lines IncN1006USud SE 210 CARAVELLE VIR · S/N 91Cancelled Mar 7, 1972 · Exported to Denmark · United Air Lines IncN1020USud SE 210 CARAVELLE VIR · S/N 114Cancelled Mar 6, 1972 · Exported to Denmark · United Air Lines IncN420DDehavilland DH104 DOVE 6A · S/N 04414Cancelled Feb 28, 1972 · Fidelity Properties IncN71672Luscombe 8A · S/N 3099Cancelled Feb 28, 1972 · Moody Bible Institute Of ChicagoN5341Bensen B-8M · S/N L468Cancelled Feb 25, 1972 · Revoked, canceled · Gelas John J PtnrN7055GCessna 172K · S/N 17258755Cancelled Feb 23, 1972 · Myers Harry AN5863MCessna T-310P · S/N 310P0163Cancelled Feb 10, 1972 · Exported to Germany · Norman Aircraft SalesN1018USud SE 210 CARAVELLE VIR · S/N 103Cancelled Feb 9, 1972 · Exported to Denmark · United Air Lines IncN1019USud SE 210 CARAVELLE VIR · S/N 104Cancelled Feb 9, 1972 · Exported to Denmark · United Air Lines IncN93361Ercoupe 415-C · S/N 684Cancelled Feb 7, 1972 · Built 1946 · Estaver James BN1005USud SE 210 CARAVELLE VIR · S/N 90Cancelled Jan 28, 1972 · Exported to Denmark · United Air Lines IncN1016USud SE 210 CARAVELLE VIR · S/N 101Cancelled Jan 28, 1972 · Exported to Denmark · United Air Lines IncN7156TCessna 172A · S/N 46756Cancelled Jan 27, 1972 · Willard JoelN2303NCessna 140 · S/N 12543Cancelled Jan 25, 1972 · Exported to Canada · Built 1947 · Hovde C AN1013USud SE 210 CARAVELLE VIR · S/N 98Cancelled Jan 6, 1972 · Exported to Denmark · United Air Lines IncN34409Aeronca 65-TC · S/N CA14221Cancelled Dec 31, 1971 · Herzeg StephenN61666Douglas B-23 · S/N 2727Cancelled Dec 17, 1971 · Harris Trust And Savings BankN525WDouglas DC3C · S/N 20054Cancelled Dec 16, 1971 · International Harvester CoN1014USud SE 210 CARAVELLE VIR · S/N 99Cancelled Dec 8, 1971 · Exported to Denmark · United Air Lines IncN7867PPiper PA-24-250 · S/N 24-3092Cancelled Dec 7, 1971 · Howard Fred EN7906YPiper PA-30 · S/N 30-995Cancelled Dec 7, 1971 · Obrian Robert WN8405MCessna A150K · S/N A15000105Cancelled Nov 29, 1971 · T K Aviation IncN671HBryan HP-11-A · S/N 64Cancelled Nov 24, 1971 · Harrison Kingsley Howe
Back to Chicago, IL