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.

N5622BCessna 182 · S/N 33622Cancelled Nov 22, 1963 · Exported to Mexico · Built 1956 · Malloy & CoN2885BBell 47G-2 · S/N 2429Cancelled Nov 6, 1963 · Chicago Helicopter Airways IncN8013UDouglas DC-8 · S/N 45290Cancelled Nov 4, 1963 · United Airlines IncN879Sikorsky S-58C · S/N 58420Cancelled Nov 4, 1963 · Chicago Helicopter AirwaysN28128Piper J3C-65 · S/N 4600Cancelled Sep 10, 1963 · Majewski Stanley JN1488YCessna 172 · S/N 17249188Cancelled Sep 3, 1963 · Exported to Canada · Smith Michael JN500YLockheed PV-1 · S/N 5551Cancelled Jul 25, 1963 · Natural Gas Pipeline Company Of AmericaN6790CBeech C18S · S/N 44-47117Cancelled May 23, 1963 · Riverton Uranium CorpN3327PPiper PA-23 · S/N 23-1278Cancelled Apr 17, 1963 · Exported to Canada · Cummings ThomasN6386PPiper PA-24-250 · S/N 24-1496Cancelled Jan 23, 1963 · Exported to Australia · National City Aircraft Leasing CompanyN91712North American NAVION · S/N NAV-4-446Cancelled Jan 23, 1963 · Mccarthy Daniel JN8106KStinson 108-2 · S/N 108-3106Cancelled Nov 21, 1962 · Olson Paul IrvingN4791BCessna 180 · S/N 31689Cancelled Jan 24, 1962 · Exported to Italy · Graubart Aviation IncN63004Douglas A-20G · S/N 21847Cancelled Dec 29, 1961 · Bankers Life And Casualty CoN8040UDouglas DC-8-12 · S/N 45307Cancelled Jul 27, 1961 · United Airlines IncN4215PPiper PA-23-160 · S/N 23-1708Cancelled Jul 17, 1961 · Exported to Denmark · Built 1959 · Graubart Aviation IncN1326PPiper PA-23-150 · S/N 23-369Cancelled Apr 17, 1961 · Exported to United Kingdom · Graubart EliN4404PPiper PA-23-160 · S/N 23-1916Cancelled Mar 13, 1961 · Exported to Argentina · Built 1960 · Lester B Knight International CorpN4165EAeronca 11CC · S/N 11-CC-68Cancelled Dec 12, 1960 · Fuessl Wilhelm LN9619BCessna 180A · S/N 32916Cancelled Nov 15, 1960 · Exported to Canada · Graubert Aviation IncN3433PPiper PA-23-160 · S/N 23-1400Cancelled Nov 14, 1960 · Exported to Canada · Built 1958 · Graubart EliN5763ECessna 150 · S/N 17263Cancelled Nov 7, 1960 · Exported to Canada · Graubart Aviation CorpN6252BAero Commander 500 · S/N 500-656-16Cancelled Nov 7, 1960 · Exported to Germany · Graubart EliN5897ECessna 150 · S/N 17397Cancelled Sep 10, 1960 · Exported to Canada · Gaubart Aviation IncN9418BCessna 175 · S/N 55218Cancelled Sep 10, 1960 · Exported to Canada · Graubart Aviation IncN27812Piper J4A · S/N 4-1029Cancelled Aug 31, 1960 · Exported to Canada · Duncan Gifford J & Anthony A DuncanN7196DPiper PA-18-150 · S/N 18-5664Cancelled Aug 24, 1960 · Exported to Germany · Graubart Aviation IncN8251BCessna 172 · S/N 36051Cancelled Aug 22, 1960 · Exported to Canada · Gaubart Aviation IncN1800PPiper PA-22 · S/N 22-2578Cancelled Jun 3, 1960 · Exported to Canada · Graubart Aviation IncN80363Beech D18S · S/N AA-17Cancelled May 25, 1960 · Built 1946 · Presbitero & Sons IncN6235BAero Commander 680-E · S/N 680E-623-1Cancelled May 9, 1960 · Exported to Germany · Graubart Aviation IncN3994FCessna 172 · S/N 36894Cancelled Apr 20, 1960 · Exported to New Zealand · Graubart Aviation IncN5101BFairchild C-82 · S/N 4557788Cancelled Mar 28, 1960 · Exported to Colombia · Bankers Life & Casualty CoN688DBeech C35 · S/N D2964Cancelled Feb 18, 1960 · Graubart EliN9807ACessna 190 · S/N 7486Cancelled Jan 29, 1960 · National City Truck Rental CoN3428PPiper PA-23-160 · S/N 23-1393Cancelled Nov 10, 1959 · Exported to Canada · Built 1958 · Graubart AviationN6436BCessna 172 · S/N 29636Cancelled Nov 10, 1959 · Exported to Canada · Graubart AviationN1389PPiper PA-23 · S/N 23-439Cancelled Oct 22, 1959 · Exported to Canada · Graubart EliN6363KRepublic RC-3 · S/N 592Cancelled Sep 24, 1959 · Exported to Germany · Built 1947 · Walker Wynkoop IncN72629Cessna 140 · S/N 9805Cancelled Jun 22, 1959 · Exported to Canada · Graubart Aviation IncN4795BCessna 180 · S/N 31693Cancelled May 27, 1959 · Exported to Cuba · Graubart Aviation IncN647DBeech C35 · S/N D-2913Cancelled Apr 15, 1959 · Lynwood Walter JN9239CCessna 180 · S/N 31338Cancelled Apr 13, 1959 · Exported to Nicaragua · Graubart EliN5100BFairchild C-82 · S/N 45-57789Cancelled Mar 31, 1959 · Exported to Colombia · Bankers Life & Casualty CoN9774BCessna 180A · S/N 50072Cancelled Mar 19, 1959 · Exported to Papua New Guinea · Graubert AviationN4475CCessna 195B · S/N 16084Cancelled Feb 17, 1959 · Exported to Canada · Graubart Aviation IncN4709APiper PA-18A · S/N 184927Cancelled Feb 17, 1959 · Exported to Canada · Graubart Aviation IncN9701BCessna 180A · S/N 32998Cancelled Nov 26, 1958 · Exported to Canada · Graubart EliN3559EAeronca 7AC · S/N 7AC-6907Cancelled Oct 10, 1958 · Exported to Canada · Graubart Aviation IncN8786CPiper PA-18 · S/N 18-3254Cancelled Sep 17, 1958 · Exported to Canada · Graubart Aviation Inc
Back to Chicago, IL