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.

N86537Cessna T-50 · S/N 5267Cancelled Jul 25, 1949 · Intl Airlines IncN86539Cessna T-50 · S/N 6284Cancelled Jul 25, 1949 · Intl Airlines IncN89800Cessna 140 · S/N 8849Cancelled Jul 12, 1949 · Castany FrankN9536HConsolidated Vultee SNV-1 · S/N 8447Cancelled Jun 28, 1949 · Thrash FrancisN55696Cessna T-50 · S/N 6505Cancelled Jun 16, 1949 · Arttpe IncN2704VBeech 35 · S/N D-80Cancelled Jun 14, 1949 · Leason Jay HN79127Consolidated Vultee BT-15 · S/N 10843Cancelled May 19, 1949 · Built 1943 · Dyxin Robert & Hopewell HenryN93327Engineering & Research 415-C · S/N 650Cancelled May 10, 1949 · Ward Ernest MN89718Cessna 140 · S/N 8767Cancelled May 9, 1949 · Westphal Otto AN80911Globe GC-1B · S/N 1104Cancelled Mar 7, 1949 · Jack SabelN75786Consolidated Vultee BT-13A · S/N 1247Cancelled Mar 4, 1949 · Built 1941 · Hinz Kenneth EN80725Globe GC-1A · S/N 128Cancelled Mar 4, 1949 · Built 1946 · Sykes ServiceN80506Globe GC-1A · S/N 09Cancelled Feb 23, 1949 · Built 1946 · Lindblad Harold LN37785Porterfield CP-65 · S/N 994Cancelled Jan 5, 1949 · Built 1941 · Rinker Lowell PN48380Fairchild M-62A · S/N 9474AECancelled Dec 14, 1948 · Whiler Pre Kindergarten SchoolN17898Schweyer ROHONSPEBER · S/N 85-39Cancelled Nov 3, 1948 · Built 1939 · Steinhauser JosephN51445Boeing A75N1(PT17) · S/N 75-2473Cancelled Oct 29, 1948 · Ernest J KranzN54733Cessna T-50 · S/N 3734Cancelled Oct 27, 1948 · Monarch Air ServiceN16416Monocoupe 90A · S/N A-745Cancelled Oct 15, 1948 · Built 1936 · Caraher Gerald JamesN4210MPiper PA-12 · S/N 12-3105Cancelled Oct 14, 1948 · Built 1947 · Conservative Baptist Foreign Mission SocietyN6306KRepublic RC-3-1 · S/N 527Cancelled Oct 8, 1948 · Wasleff AlexN34228Nemeth Helicopter NO 2 · S/N 100Cancelled Aug 26, 1948 · Nemeth Helicopter CorpN33512Schweizer SGS 2-8 · S/N 20Cancelled Aug 19, 1948 · Jay Cee Glider PatrolN29341Waco UPF-7 · S/N 5368Cancelled Aug 10, 1948 · Merkle John RN16301Piper J-2 · S/N 534Cancelled Aug 4, 1948 · Schwuchow RaymondN14399Fairchild 24 C8CS · S/N 2640Cancelled Jul 27, 1948 · Monarch Air ServiceN13589Aeronca C-3 · S/N A-273Cancelled Jul 20, 1948 · Maryanski Ned RichardN11955Star CAVALIER E · S/N 134Cancelled Jul 16, 1948 · Hulse Harold W & Charles D LindsayN8073Davis V-3 · S/N 105Cancelled Jul 14, 1948 · Matthew Wojnick Et AlN25617Douglas DC-3A-S1C3G · S/N 3261Cancelled Jun 10, 1948 · Exported to Mexico · United Air Lines IncN19947Douglas DC3A · S/N 4873Cancelled Jun 2, 1948 · United Air Lines IncN20279Piper J-3 · S/N 2079Cancelled May 26, 1948 · Built 1938 · Whittaker William WN21443Piper J-3 · S/N 2298Cancelled May 19, 1948 · Built 1942 · Rakoczy Joseph FrankN9785Fairchild 71 · S/N 617Cancelled May 18, 1948 · U S EngineersN90863Douglas C54A-DC · S/N 10333Cancelled May 14, 1948 · Exported to Argentina · Santa Fe Skyway IncN90864Douglas C54A-DC · S/N 10329Cancelled May 14, 1948 · Exported to Argentina · Santa Fe Skyway IncN90861Douglas C54A-DC · S/N 3065Cancelled May 3, 1948 · Exported to Netherlands · Santa Fe Skyway IncN90862Douglas C54B-DC · S/N 10480Cancelled May 3, 1948 · Exported to Netherlands · Santa Fe Skyway IncN362KParks P-1 · S/N 19713Cancelled Apr 29, 1948 · Built 1929 · Kendzior Edward FN25616Douglas DC-3A-S1C3G · S/N 3260Cancelled Apr 15, 1948 · United Air Lines IncN14870Howard DGA-8 · S/N 75Cancelled Apr 13, 1948 · Built 1936 · Monarch Air ServiceN16064Douglas DC3A · S/N 1904Cancelled Apr 13, 1948 · Built 1936 · United Air Lines Transport CorpN15432Monocoupe 90A · S/N A-732Cancelled Apr 9, 1948 · Built 1936 · Burtness Myron I EtalN13641Glunz Joseph GLUNZ 1933 GLIDER · S/N 1Cancelled Apr 7, 1948 · Built 1933 · Glunz JosephN8797Cessna AW · S/N 182Cancelled Apr 5, 1948 · Vansciver Wesley JN702Grumman G-44 · S/N 1350Cancelled Mar 31, 1948 · United States Of AmericaN37WLincoln PT-K · S/N 612Cancelled Mar 25, 1948 · Latour Arthur AN4586VBeech 35 · S/N D-1057Cancelled Mar 25, 1948 · Coombs Leslie WN30050Douglas C54B-DC · S/N 10450Cancelled Mar 18, 1948 · Built 1944 · United Air Lines IncN6617Stinson SR-9B · S/N 5353Cancelled Mar 17, 1948 · Ocarroll Pierce N
Back to Chicago, IL