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.

N3423Ryan B1 · S/N 51Cancelled Aug 22, 1930 · Greer AirwaysN422KFleet 2 · S/N 145Cancelled Aug 22, 1930 · The Dickson CoN4920Laird LCB · S/N 160Cancelled Aug 22, 1930 · Mcbride W PN1407Waco GXE · S/N G-1251Cancelled Aug 8, 1930 · Walter Gollnick Chicago StadiumN9877Travel Air Mfg 2000 · S/N 1108Cancelled Aug 4, 1930 · Mulvaney EdwardN112NMonarch Aircraft Industries IN MONARCH A4 · S/N 6Cancelled Aug 1, 1930 · Red Devil Flyers IncN4MAlliance ARGO · S/N 111Cancelled Jul 30, 1930 · Built 1929 · Walker Sydney JrN7464Curtiss Aeroplane And Motor JN-6H · S/N 5514Cancelled Jul 22, 1930 · Built 1928 · Schumacher E CN7163Douglas M-4 · S/N 314Cancelled Jul 15, 1930 · National Air Transport IncN7164Standard J-1 · S/N 246Cancelled Jul 15, 1930 · Commonwealth Flying ClubN5761H S Rouse ROUSE SR-1 · S/N 1Cancelled Jul 8, 1930 · H Stewart RouseN1544Swallow Airplane Mfg SWALLOW LAND PLANE · S/N 857Cancelled Jun 25, 1930 · Schaefer Royal EN9398Curtiss ORIOLE 342 · S/N 342Cancelled Jun 16, 1930 · Built 1928 · Halloway W JN193HAeromarine-Klemm L-26-A · S/N 2-26Cancelled Jun 13, 1930 · Aviation Service & Transport IncN373VAkers A1 · S/N 1Cancelled May 21, 1930 · Akers Aircraft CoN9753Sikorsky S-38-B · S/N 114-1Cancelled May 21, 1930 · Colonel Robert MccormickN3071F J Kendle/C E Nelson K-N-1 · S/N 1Cancelled May 6, 1930 · F J KendleN323Curtiss Aeroplane & Motor JN4C · S/N 3956Cancelled May 5, 1930 · Hanson Adolph WN330Curtiss JN4D · S/N 5146Cancelled May 5, 1930 · Built 1918 · Wright Jack And Noll Leo LN111NChance Vought O2U-2 CORSAIR · S/N 577Cancelled May 2, 1930 · Donnelley ThorneN1728Standard J-1 · S/N 63Cancelled May 2, 1930 · Slack R BN636Heil Louie LH1 · S/N 1Cancelled May 2, 1930 · Built 1929 · Heil LouieN64Standard J-1 · S/N UNKNOWN2Cancelled Apr 30, 1930 · Persons Lawrence MN716MMoth 60-GMW · S/N 154Cancelled Apr 16, 1930 · Apelt & Colvin IncN239MDetroit VEGA DL-1 SPECIAL · S/N 1Cancelled Mar 20, 1930 · Kramer MathewN81Curtiss JN4D · S/N UNKNWNCancelled Mar 17, 1930 · Fortington William HarryN1561Curtiss JN4D · S/N N/ACancelled Mar 14, 1930 · Zubak EdwardN708MParks P-1 · S/N 1993Cancelled Mar 14, 1930 · Pioneer Aero ClubN5362Curtiss JN4C · S/N 3443Cancelled Mar 7, 1930 · Brock ErnestN895Curtiss JN4D · S/N 34096Cancelled Feb 28, 1930 · Built 1918 · Osterguard Aircraft WorksN9604Stinson SM-2 · S/N 1035Cancelled Feb 14, 1930 · Built 1929 · Adams R TN789Douglas M-3 · S/N 622Cancelled Jan 2, 1930 · National Air Transport IncN2906Travel Air 5000 · S/N 173ACancelled Dec 12, 1929 · National Air Transport IncN369KCurtiss-Robertson ROBIN C-1 · S/N 528Cancelled Dec 3, 1929 · Built 1929 · Curtiss Flying Service Of Middle West IncN2332Curtiss JN4C · S/N L00-XCancelled Nov 21, 1929 · Russell SabinN2614Travel Air 5000 · S/N 171Cancelled Oct 11, 1929 · National Air Transport IncN659Curtiss Wright JN4C · S/N 1107Cancelled Aug 12, 1929 · Merle C GilletteN1555Heath SUPER STANDARD · S/N 953Cancelled Jun 14, 1929 · Heath Airplane CoN953Heath SUPER STANDARD · S/N 105Cancelled Jun 11, 1929 · Built 1927 · Heath Airplane CoN770Travel Air Mfg UNKNOWN · S/N 177ACancelled May 18, 1929 · National Air Transport IncN771Travel Air Mfg UNKNOWN · S/N 178ACancelled May 10, 1929 · National Air Transport IncN1352E M Laird LAIRD COMMERCIAL · S/N 146Cancelled Apr 19, 1929 · Aviation Service & Transport IncN2204Curtiss Aeroplane And Motor JN-6H · S/N 13Cancelled Apr 18, 1929 · Built 1918 · Caffarello JoeN115Swallow SWALLOW · S/N 822Cancelled Apr 6, 1929 · Aviation Service And Transport IncN213ECurtiss Wright FALCON MAILPLANE · S/N 13Cancelled Apr 6, 1929 · National Air Transport IncN5845Lincoln LINCOLN PAGE 3 · S/N 217Cancelled Apr 6, 1929 · Built 1928 · Perkin William Et AlN796Douglas M-4 · S/N 655Cancelled Apr 6, 1929 · National Air Transport IncN5343Swallow Airplane Mfg SWALLOW LAND PLANE · S/N 932Cancelled Mar 23, 1929 · Aviation Service & Transport IncN5363Fairchild Airplane Mfg FC-2 · S/N 95Cancelled Feb 20, 1929 · Universal Air Lines IncN9711Fairchild FC-2-W2 · S/N 534Cancelled Feb 20, 1929 · Interstate Airlines Inc
Back to Chicago, IL