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.

N35044Piper J5A · S/N 5-555Cancelled Oct 10, 1955 · Howell Flying ServiceN41823Cessna T-50 · S/N 5927Cancelled Oct 10, 1955 · Haynes Robert EN47683Taylorcraft DCO-65 · S/N L-5405Cancelled Oct 10, 1955 · Leininger Clarence WN9535HConsolidated Vultee BT-13A · S/N 8241Cancelled Oct 5, 1955 · Rezich NickN4723HPiper PA-11 · S/N 11511Cancelled Oct 4, 1955 · Crea James PN6164KRepublic RC-3 · S/N 352Cancelled Oct 4, 1955 · Sobbe A JN4893VDouglas C-47 · S/N 27069Cancelled Sep 23, 1955 · Exported to Brazil · Bankers Life & Casualty CoN61867Cessna T-50 · S/N 3852Cancelled Sep 23, 1955 · Nocar RobertN75292Curtiss Wright C-46D · S/N 30498Cancelled Aug 19, 1955 · Exported to Brazil · Korer NormanN4731VDouglas DC3C-S1C3G · S/N 33573Cancelled Aug 11, 1955 · Exported to Brazil · Bankers Life & Casualty CoN1938MBeech C18S · S/N 29586Cancelled Aug 4, 1955 · Built 1951 · Robert J Willis CoN206BBell 47D · S/N 72Cancelled Jul 8, 1955 · Exported to Colombia · Helicopter Air Service IncN58776Douglas DC3C · S/N 13048Cancelled Jun 13, 1955 · Exported to Brazil · Bankers Life & Casualty CoN4673VDouglas DC3C-S1C3G · S/N 4756Cancelled Jun 6, 1955 · Exported to Brazil · Bankers Life & Casualty CoN4892VDouglas DC3C-S1C3G · S/N 43-49808Cancelled Jun 6, 1955 · Exported to Brazil · Bankers Life & Casualty CoN4908VDouglas C-47 · S/N 20193Cancelled Jun 6, 1955 · Exported to Brazil · Bankers Life & Casualty CoN208BBell 47D · S/N 74Cancelled Apr 25, 1955 · Exported to Canada · Built 1948 · Helicopter Air Service IncN63118Consolidated Vultee BT-13A · S/N 6183Cancelled Apr 8, 1955 · Coconate LouisN62526Cessna T-50 · S/N 5501Cancelled Apr 1, 1955 · Bankers Life & Casualty CoN63706Consolidated Vultee BT-13A · S/N 10820Cancelled Apr 1, 1955 · Sundmacher Herbert CN47216Fairchild M-62A · S/N T43-7113Cancelled Mar 31, 1955 · Vande Sande George AN75293Curtiss Wright C-46A · S/N 30622Cancelled Mar 30, 1955 · Exported to Colombia · Korer NormanN9518HFairchild M-62A-3 · S/N FT-703Cancelled Mar 15, 1955 · Wozsneske BarneyN1067DCessna 195 · S/N 7679Cancelled Mar 10, 1955 · Exported to Canada · Graubart EliN51115Cessna T-50 · S/N 5588Cancelled Mar 4, 1955 · Phillips John BN4888VDouglas C-54 · S/N 27323Cancelled Feb 15, 1955 · Exported to Colombia · Bankers Life & Casualty CoN9534HConsolidated Vultee SNV-1 · S/N 6368Cancelled Feb 15, 1955 · Oswald Joseph VN2378DCessna 170B · S/N 20530Cancelled Jan 25, 1955 · Exported to Canada · Graubart EliN2248VCessna 140 · S/N 14479Cancelled Dec 17, 1954 · Koretke C HN60005Consolidated Vultee SNV-1 · S/N 7082Cancelled Nov 30, 1954 · Stell George HN62BCulver V · S/N V-92Cancelled Nov 30, 1954 · Welcome WarrenN4637MPiper PA-11 · S/N 11-145Cancelled Nov 16, 1954 · Crea James PN9161KStinson 108-2 · S/N 108-2161Cancelled Nov 16, 1954 · Micheal John CN2534CCessna 170B · S/N 26178Cancelled Oct 28, 1954 · Exported to Canada · Graubart EliN4668VDouglas C-47 · S/N 5994Cancelled Sep 30, 1954 · Exported to Brazil · Bankers Life And Casuality CoN31229Boeing 377 · S/N 15969Cancelled Sep 28, 1954 · Exported to United Kingdom · United Air LinesN8470ABeech A35 · S/N D-1888Cancelled Sep 13, 1954 · Otis Hann Co IncN4670VDouglas C-47B · S/N 348911Cancelled Aug 10, 1954 · Exported to Brazil · Bankers Life & Casualty CoN88393Piper J3C-65 · S/N 16011Cancelled Jul 22, 1954 · Chicago Seaaplane Base IncN1360HAeronca S15AC · S/N 15AC-407Cancelled Jul 15, 1954 · Edgar Irving WN1863KLuscombe 8E · S/N 4590Cancelled May 28, 1954 · Capitol Construction CoN9537HBeech C18S · S/N 1152Cancelled May 28, 1954 · Exported to Brazil · Bankers Life And Casualty CoN4972KRyan NAVION A · S/N NAV-4-1972Cancelled May 13, 1954 · Dealers Transport CoN9928HConsolidated Vultee BT-13A · S/N 7415Cancelled Feb 18, 1954 · Aero Skywriting IncN6663NTaylorcraft 15A · S/N 5-14009Cancelled Dec 21, 1953 · Exported to Mexico · Reedy TaylorN2039KLuscombe 8E · S/N 4766Cancelled Aug 18, 1953 · Most Jr HowardN2167HEngineering & Research ERCOUPE 415-C · S/N 2790Cancelled Aug 13, 1953 · Built 1946 · Schulien Mathias RN7082KPiper PA-20 · S/N 20-188Cancelled Jul 7, 1953 · Ward A DN1511BLuscombe 8F · S/N 6138Cancelled May 11, 1953 · Exported to Canada · Built 1948 · Graubart EliN77649Fairchild 24R-46 · S/N R46349Cancelled Mar 5, 1953 · Exported to Canada · J Halstead & Co
Back to Chicago, IL