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.

N77635Fairchild 24R-46A · S/N R46-335Cancelled Mar 3, 1953 · Exported to Canada · K G Anderegg O Cokliss And C S CrutcherN36003Taylorcraft BC12-65 · S/N 2968Cancelled Jan 14, 1953 · Mazurk Robert LN1447HAeronca 15AC · S/N 15AC-516Cancelled Dec 31, 1952 · Baranowski George AN92306Piper J3C-65 · S/N 16759Cancelled Dec 22, 1952 · Chicago Seaplane Base IncN6718KRepublic RC-3 · S/N 1001Cancelled Nov 20, 1952 · Exported to Canada · English Edward CN740Republic Aviation Corp USA SEABEE RC-3 · S/N 757Cancelled Nov 18, 1952 · United States Department Of InteriorN36881Aeronca 65-CA · S/N CA17911Cancelled Oct 31, 1952 · Built 1941 · Ruzek ArthurN6506KRepublic RC-3 · S/N 772Cancelled Aug 29, 1952 · Isle Royale Air Service IncN34672Stinson 10A · S/N 7972Cancelled Jul 2, 1952 · Robert N CrowN10585Star CAVALIER · S/N 131Cancelled Jun 30, 1952 · Hubiak Joe RN88810Cessna T-50 · S/N 4985Cancelled Jun 25, 1952 · International Airlines IncN2318BTemco GC-1B · S/N 3618Cancelled Jun 13, 1952 · Langan Harley BN2360KLuscombe 8A · S/N 5087Cancelled Jun 13, 1952 · North Shore Flying Club IncN5185KRyan NAVION A · S/N NAV-4-2085Cancelled Apr 15, 1952 · Exported to Cuba · Sullivan Dennis JrN79982Curtiss Wright C-46D · S/N 33564Cancelled Mar 20, 1952 · Built 1945 · Monarch Air ServiceN37222Interstate S-1A · S/N 65Cancelled Feb 26, 1952 · Ralph Defalco JrN17109Douglas DC3A · S/N 4999Cancelled Jan 16, 1952 · United Air Lines IncN81005Commonwealth 185 · S/N 1801Cancelled Dec 4, 1951 · Wall Grover AN8139HHiller UH-12A · S/N 139Cancelled Nov 29, 1951 · Exported to Egypt · Fastener CorporationN55383Boeing A75N1 · S/N 75-749Cancelled Oct 24, 1951 · Built 1941 · Curran Dick/Fritz Jung/Lindholm DickN2137EAeronca 7AC · S/N 7AC-5708Cancelled Sep 7, 1951 · Southern Illinois Airways IncN9508HTimm N2T-1 · S/N 150Cancelled Sep 7, 1951 · Oddo Anthony GN38650Piper J5B · S/N 5-1035Cancelled Sep 5, 1951 · Renn Paul L And Clifford WestfallN53338Stinson AT-19 · S/N 77-118Cancelled Aug 24, 1951 · Built 1943 · Kasallis Joseph J/Fabianski GeorgeN702Grumman J4F-2 · S/N 1320Cancelled Aug 14, 1951 · United States Of AmericaN51170Cessna T-50 · S/N 4882Cancelled Aug 2, 1951 · Monarch Air ServiceN51449Cessna T-50 · S/N 5982Cancelled Aug 2, 1951 · Monarch Air ServiceN39677Fairchild PT-26 · S/N FZ 308Cancelled Aug 1, 1951 · Trans American Aviation Service Co IncN16088Douglas DC3A · S/N 1927Cancelled May 15, 1951 · United Air Lines IncN16492Porterfield 35-70 · S/N 192Cancelled Feb 28, 1951 · Chicago Air ClubN25613Douglas DC-3A-S1C3G · S/N 3257Cancelled Feb 16, 1951 · Exported to Mexico · United Air Lines IncN79984Cessna T-50 · S/N 2760Cancelled Jan 2, 1951 · Built 1943 · Eppler John WN39000Luscombe 8A · S/N 1761Cancelled Oct 25, 1950 · Binks Flying ClubN7144KPiper PA-18 · S/N 18-364Cancelled Sep 21, 1950 · Exported to Canada · Moody Bible InstituteN53733Fairchild M-62A · S/N T41-1171Cancelled Aug 25, 1950 · Built 1941 · Kilfoy Edward J And Morgan Edward FN31MLockheed VEGA 1 · S/N 98Cancelled Jul 29, 1950 · Built 1929 · Beardsley & PiperN41358Douglas DC3C · S/N 9649Cancelled Jul 26, 1950 · Exported to Mexico · Built 1943 · United Air Lines IncN1969KLuscombe 8E · S/N 4696Cancelled Jun 27, 1950 · Harvath Betty SN37510Douglas DC-6 · S/N 42875Cancelled Jun 6, 1950 · United Air Lines IncN3265KGlobe GC-1B · S/N 1258Cancelled Mar 6, 1950 · Sirovatka BerniceN8974Mono MONOSPORT 1 · S/N 2002Cancelled Feb 21, 1950 · Benke Alfred PN39678Fairchild PT-26 · S/N FZ 213Cancelled Jan 16, 1950 · John W EpplerN38953Boeing A75N1 · S/N 75-1995Cancelled Jan 11, 1950 · Hawkeye Flying ClubN9846HCessna T-50 · S/N 1849Cancelled Jan 11, 1950 · Barnett WilliamN49489Cessna T-50 · S/N 1486Cancelled Dec 22, 1949 · Mc Nabb GertrudeN51464Taylorcraft DCO-65 · S/N L-5758Cancelled Dec 19, 1949 · Thompson A CN8104Curtiss Wright TRAVEL AIR C-4000 · S/N 875Cancelled Dec 8, 1949 · Dowell MaynardN37506Douglas DC-6 · S/N 42871Cancelled Dec 1, 1949 · Built 1947 · United Air Lines IncN3177VBeech 35 · S/N D-611Cancelled Nov 7, 1949 · Meyer And Turner Painting CoN2322HErcoupe 415-C · S/N 2947Cancelled Aug 15, 1949 · Built 1946 · Turner K D
Back to Chicago, IL