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.

N187EBoeing 95 · S/N 1050Cancelled Nov 4, 1936 · Built 1928 · Lane Technical High SchoolN14575Stinson SR-5A · S/N 9311ACancelled Oct 15, 1936 · Built 1934 · Peterkin Daniel JrN13761Northrop GAMA 2D2 · S/N 11Cancelled Oct 1, 1936 · Cochran JacquelineN959YLockheed VEGA 5C · S/N 170Cancelled Sep 29, 1936 · Caffarello M AN9671Ford 5-AT-B · S/N 28Cancelled Sep 22, 1936 · Exported to Honduras · Aviation Manufacturing CorpN363KParks P-1 · S/N 19712Cancelled Sep 1, 1936 · Barkstrom HaroldN12392Curtiss Wright AT-32 CONDOR · S/N 44Cancelled Aug 13, 1936 · American Airlines IncN6779Waco GXE · S/N 1577Cancelled Jul 22, 1936 · John P LinnertN13651Nemeth S P NEMETH 2 POLM · S/N 100Cancelled Jul 1, 1936 · Built 1933 · Nemeth Stephen PaulN14141Stinson A · S/N 9100Cancelled May 26, 1936 · Built 1934 · American Airlines IncN734NAmerican Airplane & Engine PILGRIM 100A · S/N 6614Cancelled Apr 20, 1936 · Exported to Mexico · Built 1932 · Aviation Manufacturing CorporationN277Boeing 40B · S/N 888Cancelled Apr 15, 1936 · United Air Lines Transport CorpN7168Stinson SM1-B · S/N M-260Cancelled Apr 15, 1936 · Built 1928 · Hederman LN15152Stinson A · S/N 9112Cancelled Apr 1, 1936 · Built 1935 · American Airlines IncN2156Hess HESS LAND PLANE · S/N UNKNOWNCancelled Mar 15, 1936 · Built 1926 · E M Laird Airplane CoN7086Laird LC-R 200 SPEEDWING · S/N 166Cancelled Mar 15, 1936 · E M Laird Airplane CoN12119Stinson U · S/N 9007Cancelled Feb 6, 1936 · American Airlines IncN13767Vultee V-1A · S/N 5Cancelled Jan 29, 1936 · Built 1934 · American Airlines IncN14274Douglas DC2 · S/N 1307Cancelled Jan 14, 1936 · American Airlines IncN12036R Plozay/N Buck/A Schmidt NORTHROP GLIDER · S/N NG-1Cancelled Nov 15, 1935 · Rumbaugh Edwin JN13627South Park Glider Club No 4 RHON RANGER GLIDER · S/N SPC-4Cancelled Nov 1, 1935 · Built 1933 · South Park Glider Club No 4N13643Martinez Jose L MARTINEZ-HEATH · S/N M-1Cancelled Nov 1, 1935 · Built 1933 · Martinez Jose LN487WStearman 4CM-1 · S/N 4035Cancelled Oct 24, 1935 · American Airlines IncN13684E M Laird LC-E · S/N LC-E-201Cancelled Oct 15, 1935 · E M Laird Airplane Co InN12372Curtiss Wright T-32-C · S/N 33Cancelled Oct 7, 1935 · Exported to Chile · Built 1933 · American Airlines IncN12377Curtiss Wright T-32-C · S/N 38Cancelled Oct 7, 1935 · Exported to Chile · Built 1933 · American Airlines IncN398VOgden Aeronautical OSPREY · S/N 102Cancelled Oct 1, 1935 · Built 1930 · Martin Robert WilliamN4461Waco GXE · S/N 1316Cancelled Oct 1, 1935 · Built 1928 · Pastor A MN926YLockheed VEGA 5C · S/N 134Cancelled Sep 22, 1935 · Built 1930 · American-Lithuanian Trans-Atlantic Flight AssociatN735NAmerican Airplane & Engine PILGRIM 100A · S/N 6615Cancelled Sep 20, 1935 · Exported to Mexico · Built 1932 · American Airways IncN968VAmerican Airplane & Engine PILGRIM 100A · S/N 6601Cancelled Sep 5, 1935 · Exported to Mexico · American Airways IncN13314Boeing 247D · S/N 1695Cancelled Sep 1, 1935 · United Air Lines Transport CorporationN717VFleet 1 · S/N 328Cancelled Aug 4, 1935 · Alford Harold LaforestN12393Curtiss Wright AT-32 CONDOR · S/N 45Cancelled Jul 27, 1935 · American Airlines IncN436HFord 5-AT-D · S/N 103Cancelled Jul 15, 1935 · United Air Lines Transport CorpN458MVerville AT · S/N 9Cancelled Jul 4, 1935 · Monarch Air Service IncN234MBoeing 80-A1 · S/N 1092Cancelled May 15, 1935 · United Air Lines Transport CorpN12113Stinson U · S/N 9001Cancelled May 9, 1935 · American Airways IncN439HFord 5-AT-D · S/N 106Cancelled Apr 24, 1935 · Built 1931 · United Air Lines Transport CorpN228MBoeing 80-A1 · S/N 1086Cancelled Apr 10, 1935 · United Air Lines Transport CorpN638KCessna DC-6A · S/N 209Cancelled Apr 4, 1935 · Monarch Air Service IncN415HFord 5-AT-C · S/N 75Cancelled Feb 28, 1935 · Exported to Honduras · American Airways IncN11155Stinson SM-6000-B · S/N 5022Cancelled Feb 11, 1935 · Built 1931 · American Airways IncN12287Lockheed ORION 9D · S/N 199Cancelled Jan 10, 1935 · Built 1933 · American Airlines IncN12395Curtiss Wright AT-32B · S/N 47Cancelled Dec 19, 1934 · American Airways IncN12285Lockheed ORION 9D · S/N 197Cancelled Nov 15, 1934 · Built 1933 · American Airways IncN11120Stinson SM-6000-B · S/N 5019Cancelled Nov 6, 1934 · Built 1931 · American Airways IncN871MBellanca CH300 PACEMAKER · S/N 163Cancelled Nov 2, 1934 · American Airways IncN10892Stinson SM-6000-B · S/N 5052Cancelled Sep 28, 1934 · Exported to Mexico · Built 1931 · American Airways IncN12922Phantom Knight PHANTOM KNIGHT A-150 · S/N 2Cancelled Sep 10, 1934 · Built 1929 · Mount Ted Oscar/Williams Harold
Back to Chicago, IL