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.

N5106BFairchild C-82 · S/N 45-57773Cancelled Oct 8, 1970 · Bankers Life & Casualty CoN5110BFairchild C-82 · S/N 45-57741Cancelled Oct 8, 1970 · Bankers Life & Casualty CoN5123BFairchild C-82 · S/N 45-57808Cancelled Oct 8, 1970 · Bankers Life & Casualty CoN5124BFairchild C-82 · S/N 45-57817Cancelled Oct 8, 1970 · Bankers Life & Casualty CoN5125BFairchild C-82 · S/N 45-57825Cancelled Oct 8, 1970 · Bankers Life & Casualty CoN5126BFairchild C-82 · S/N 45-57800Cancelled Oct 8, 1970 · Bankers Life & Casualty CoN4764ZPiper PA-22-108 · S/N 22-8322Cancelled Oct 7, 1970 · Beverly BankN5122BFairchild C-82 · S/N 45-57795Cancelled Oct 2, 1970 · Bankers Life & Casualty CoN5501NConsolidated Vultee SNV-2 · S/N 79-1404Cancelled Sep 30, 1970 · Urbanus Ralph AN79177Fairchild M-62A-3 · S/N FV-139Cancelled Sep 25, 1970 · Olivi Fred J And Stange Robert CN63982Fairchild M-62C · S/N 160SLCancelled Sep 24, 1970 · Built 1943 · Kladis DannyN2315YCessna 177 · S/N 17700115Cancelled Sep 16, 1970 · Air Investments IncN309YGreat Lakes 2T-1A · S/N 196Cancelled Sep 10, 1970 · Built 1931 · Gatz Rboert EN6024PPiper PA-24-250 · S/N 24-1119Cancelled Sep 3, 1970 · Jedrocha Julion JN3251EAeronca 11AC · S/N 11AC-1618Cancelled Sep 1, 1970 · Francis X SkinnerN4470HPiper PA-15 · S/N 15-258Cancelled Sep 1, 1970 · Pollard Bennett CN5468ACessna 310B · S/N 35668Cancelled Sep 1, 1970 · A Lakin & Sons IncN64918Cessna T-50 · S/N 3947Cancelled Aug 31, 1970 · Eppler John WN9694SChampion 7ECA · S/N 427Cancelled Aug 28, 1970 · Built 1966 · Civil Air Patrol IncN79469Consolidated Vultee SNV-1 · S/N 7172Cancelled Aug 24, 1970 · Anderson Arnold JN5111BFairchild C-82 · S/N 44-23053Cancelled Jul 14, 1970 · Bankers Life & Casualty CoN30062Douglas C-54B · S/N 18389Cancelled Jul 2, 1970 · Built 1946 · United Air Lines IncN37512Douglas DC-6 · S/N 43001Cancelled Jul 2, 1970 · United Air Lines IncN5777TCessna 172E · S/N 17251677Cancelled Jul 2, 1970 · Bev-Aire Leasing IncN7405Vickers VISCOUNT 745-D · S/N 103Cancelled Jul 2, 1970 · United Air Lines IncN7431Vickers VISCOUNT 745-D · S/N 129Cancelled Jul 2, 1970 · United Air Lines IncN7434UBoeing 727-22C · S/N 19891Cancelled Jul 2, 1970 · United Air Lines IncN37587Douglas DC-6B · S/N 45492Cancelled Jun 30, 1970 · Exported to Mexico · United Air Lines IncN4878PPiper PA-23-250 · S/N 27-458Cancelled Jun 30, 1970 · Illinois Aircraft CorpN1545YCessna 172C · S/N 17249245Cancelled Jun 29, 1970 · Fidelity Properties IncN35777Cessna 172I · S/N 17256960Cancelled Jun 29, 1970 · Garnello John LouisN3881VCessna 195 · S/N 7350Cancelled Jun 29, 1970 · Pullman Bank And Trust CoN4025MPiper PA-12 · S/N 12-2908Cancelled Jun 29, 1970 · Wisneski Carol JN7455Vickers VISCOUNT 745-D · S/N 210Cancelled Jun 29, 1970 · United AirlinesN89554Cessna 120 · S/N 8594Cancelled Jun 29, 1970 · Gehrig Ralph EN7716FCessna 150F · S/N 15063816Cancelled Jun 25, 1970 · Williams Jasper FN9362BCessna 175 · S/N 55162Cancelled Jun 24, 1970 · Small Bros Oil CoN74696Howard DGA-15P · S/N 953Cancelled Jun 12, 1970 · Somers LeonN286KBeech D18S · S/N A-130Cancelled Jun 5, 1970 · Ross Manufacturing CoN1007USud SE 210 CARAVELLE VIR · S/N 92Cancelled May 18, 1970 · Exported to Netherlands · United Air Lines IncN6237ACessna 182 · S/N 33037Cancelled May 4, 1970 · Pradelski William WN7463Vickers VISCOUNT 745-D · S/N 287Cancelled Jan 26, 1970 · United Air LinesN35117Piper J3C-65 · S/N 6127Cancelled Jan 16, 1970 · C Patrick CoffeyN4932UCessna 210E · S/N 21058632Cancelled Jan 16, 1970 · Begner Maurice KN37504Douglas DC-6 · S/N 42869Cancelled Jan 4, 1970 · United Air Lines IncN6113DPiper PA-22-150 · S/N 22-4757Cancelled Nov 20, 1969 · Moore Kenneth JN2547ZCessna 185B · S/N 185-0547Cancelled Nov 3, 1969 · Exported to Brazil · Built 1963 · Redemptorist FathersN97248Stinson 108 · S/N 108-248Cancelled Jun 10, 1969 · Exported to Canada · Air Exchange IncN9758YBeech 35-D33 · S/N CD615Cancelled Jan 24, 1969 · Exported to Australia · Built 1963 · Phillips BobN7926MBeech 95-C55 · S/N TE-184Cancelled Nov 8, 1968 · Exported to Zambia · Built 1966 · Air Exchange Inc
Back to Chicago, IL