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.

N263KStar CAVALIER · S/N 108Cancelled Sep 1, 1940 · Miller Charles HN9878Travel Air 2000T · S/N 1107Cancelled Aug 15, 1940 · Ebbesen A EN416MStinson SM-8A · S/N 4005Cancelled Jul 26, 1940 · Built 1931 · Johnson GraceN12193Stinson U · S/N 9019Cancelled Jun 15, 1940 · Lenard JosephN14829Sport Flugzenbau GOPPINGEN WOLF · S/N 4Cancelled Jun 15, 1940 · Steinhauser JosephN436MStinson JR. R · S/N 8511Cancelled Mar 15, 1940 · Walter L ThielmanN5348Swallow SWALLOW · S/N 937Cancelled Feb 15, 1940 · Rinehart Charles EN13617Aero-Lloyd BALLOON HH · S/N 80Cancelled Sep 1, 1939 · Built 1933 · Aero-Lloyd IncN19EKeystone K84 COMMUTER · S/N A-15064Cancelled Jun 26, 1939 · Built 1930 · Dolan DoloresN12390Curtiss Wright AT-32 CONDOR · S/N 42Cancelled Jun 9, 1939 · American Airlines IncN18393Welch OW5M · S/N 119Cancelled May 23, 1939 · Built 1937 · Mahrt Harvey HN572KJoseph Steinhauser S2 GLIDER · S/N 1Cancelled May 15, 1939 · Joseph SteinhauserN783KWaco GXE · S/N 2088Cancelled May 15, 1939 · Luther MooreN8520Waco GXE · S/N 1865Cancelled Mar 3, 1939 · Nichols Dwight ON6697Meadowcroft Balloon & Airship ZEPPLIX A D BALLOON · S/N E-3Cancelled Mar 1, 1939 · Built 1928 · Aero-Lloyd IncN307Curtiss JN4D · S/N NOT KNOWNCancelled Feb 20, 1939 · John PerezN18226American Mignet HM-21 · S/N 1Cancelled Dec 15, 1938 · Built 1937 · American Mignet Aircraft CorpN16066Douglas DC3A · S/N 1906Cancelled Nov 29, 1938 · United Air Lines Transport CorpN7137Boeing 80-A · S/N 1032Cancelled Nov 1, 1938 · Lenard JosephN8690Curtiss Wright FLEDGLING · S/N B-21Cancelled Oct 3, 1938 · Woznicki John EmilN12087Mead Gliders MEAD RR-1 · S/N G-1200Cancelled Sep 15, 1938 · Bruce K Craig JrN8490Parks P-2-A · S/N 106Cancelled Sep 15, 1938 · The United Hetman Organizations IncN4080Waco GXE · S/N 1302Cancelled Sep 1, 1938 · Witt Arthur EN285Boeing 40B · S/N 896Cancelled Aug 12, 1938 · United Air Lines Transport CorpN15829Rearwin 7000 · S/N 452Cancelled May 4, 1938 · Built 1936 · Estate Of Don E DuttN10009Fairchild KR-31 · S/N 234Cancelled Apr 17, 1938 · James H EN3057Lockheed 3 AIR EXPRESS · S/N 75Cancelled Apr 1, 1938 · Built 1929 · Turner RoscoeN10722Church Airplane & Mfg MIDWING · S/N JC-4Cancelled Mar 1, 1938 · Adcock Merle DN16074Douglas DC3A · S/N 1914Cancelled Oct 17, 1937 · United Airlines Transport CorpN12091Liquid Fire Glider Club LIQUID FIRE RHON RGR · S/N G-777Cancelled Sep 1, 1937 · Soaring And Gliding Club Of Chicago IncN1181Waco GXE · S/N 875Cancelled Jul 27, 1937 · Vallow David RN284Boeing 40B · S/N 895Cancelled Jul 1, 1937 · United Airlines Transport CorpN4520Waco GXE · S/N 1360Cancelled May 30, 1937 · Oscar WaldvogelN292Boeing 40B · S/N 903Cancelled May 22, 1937 · Built 1927 · United Air Lines TransportN10344Boeing 40-B-4 · S/N 1425Cancelled May 10, 1937 · Exported to Honduras · United Airlines Transport CorpN10349Boeing 40-B-4 · S/N 1430Cancelled May 10, 1937 · Exported to Honduras · United Airlines Transport CorpN272Boeing 40B · S/N 883Cancelled May 10, 1937 · Exported to Honduras · Built 1927 · United Air Lines Transport CorpN833MBoeing 40-B-4 · S/N 1158Cancelled May 10, 1937 · Exported to Honduras · United Air Lines Transport CorporationN13938Bellanca CH300 PACEMAKER · S/N 149Cancelled Apr 30, 1937 · Exported to Mexico · Ossie C ZollarN226MBoeing 80-A1 · S/N 1084Cancelled Apr 13, 1937 · United Air Lines Transport CorpN16073Douglas DC3A · S/N 1913Cancelled Mar 11, 1937 · United Airlines Transport CorpN13349Boeing 247D · S/N 1731Cancelled Jan 19, 1937 · United Air Lines Transport CorpN12383Curtiss Wright AT-32-C CONDOR · S/N 40Cancelled Dec 30, 1936 · Built 1933 · American Airlines IncN12391Curtiss Wright AT-32 CONDOR · S/N 43Cancelled Dec 30, 1936 · Exported to Mexico · American Airlines IncN12396Curtiss Wright AT-32 CONDOR · S/N 48Cancelled Dec 30, 1936 · Exported to Mexico · Built 1934 · American Ailines IncN12398Curtiss Wrightairplane AT-32-D · S/N 50Cancelled Dec 30, 1936 · Exported to Mexico · American Airlines IncN12399Curtiss Wrightairplane AT-32-D · S/N 51Cancelled Dec 30, 1936 · Exported to Mexico · American Airlines IncN3165ECurtiss Wright T-32-C · S/N 40Cancelled Dec 30, 1936 · Exported to Mexico · Built 1933 · American Airlines IncN13355Boeing 247D · S/N 1737Cancelled Dec 27, 1936 · Built 1933 · United Air Lines Transport CorpN15266Aeronca C-3 · S/N A-587Cancelled Dec 10, 1936 · Alford Harold Laforest
Back to Chicago, IL