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.

N10818Stinson SM-6000-B · S/N 5037Cancelled Oct 3, 1932 · Built 1931 · American Airways IncN141MSikorsky S38B · S/N 214-12Cancelled Oct 1, 1932 · Built 1929 · Bennett C GN210ECurtiss Wright FALCON MAILPLANE · S/N 10Cancelled Aug 15, 1932 · National Air Transport IncN12084Rose Aeroplane And Motor A · S/N 60Cancelled Aug 1, 1932 · Rose Aeroplane & Motor Company IncN266NInland R400 · S/N R402Cancelled Jun 14, 1932 · Built 1930 · Borden GailN985HCurtiss Aeroplane & Motor CARRIER PIGEON · S/N G-1Cancelled Jun 7, 1932 · National Air Transport IncN791Douglas M-4 · S/N 642Cancelled Jun 2, 1932 · Built 1926 · National Air Transport IncN794Douglas M-3 · S/N 609Cancelled Jun 2, 1932 · National Air Transport IncN12242Roamaircraft ROMAIR SPORT WO-29 · S/N 3Cancelled Apr 15, 1932 · Exported to Mexico · Nicholas ChristeneenN11122Stinson SM-6000-B · S/N 5016Cancelled Mar 29, 1932 · Built 1931 · Century Air Lines IncN11394Verville AT · S/N 20Cancelled Feb 11, 1932 · Built 1931 · Lenz Philip GN12220Lockheed ORION 9 · S/N 177Cancelled Feb 11, 1932 · Continental Airways IncN455MVerville AT · S/N 6Cancelled Feb 11, 1932 · Philip G LenzN591WJohann Urban H JOHANN · S/N 534Cancelled Feb 11, 1932 · Johann Urban HN7162Lockheed VEGA 1 · S/N 12Cancelled Feb 11, 1932 · Thomas R NavinN9977Travel Air A-6000-A · S/N 1098Cancelled Feb 11, 1932 · Continental Airways IncN2512Waco 9 · S/N 178Cancelled Jan 21, 1932 · Built 1925 · Titus ClairN369NCurtiss Aeroplane & Motor CARRIER PIGEON · S/N G-3Cancelled Jan 20, 1932 · National Air Transport IncN708YAmerican Airplane & Engine PILGRIM 100A · S/N 6604Cancelled Jan 18, 1932 · American Airways IncN1862Lincoln LINCOLN PAGE 3 · S/N 133Cancelled Jan 12, 1932 · Built 1927 · Morgan G D & Schumaker F LN3881Douglas M-4 · S/N 42Cancelled Dec 11, 1931 · Roosevelt Senior High SchoolN209ECurtiss Wright FALCON MAILPLANE · S/N 9Cancelled Nov 24, 1931 · Built 1928 · Lane Technical High SchoolN427HFord 5-AT-C · S/N 87Cancelled Nov 10, 1931 · National Air Transport IncN1799Eaglerock A-1 · S/N 287Cancelled Oct 21, 1931 · Baker James FN35ELockheed VEGA 1 · S/N 37Cancelled Oct 3, 1931 · Navin Air Transport IncN606Lockheed VEGA 5C · S/N 56Cancelled Sep 25, 1931 · Chicago Detroit Airways IncN728EWaco ATO · S/N A-102Cancelled Sep 24, 1931 · Built 1929 · Hall Edward GN472WTravel Air S-2000 · S/N 1371Cancelled Sep 18, 1931 · Holmes John ArthurN5786Waco GXE · S/N 1572Cancelled Sep 18, 1931 · Hoeck George H Russell Henriksen & Stearling MitchN541VStates STATES B-2 · S/N 101Cancelled Sep 11, 1931 · Hanson James LN827WPeel Glider Boat ZELCER #1 · S/N 20Cancelled Aug 24, 1931 · Wrigley Philip KN760MSaint Louis C-2-90 · S/N 116Cancelled Aug 19, 1931 · Shepard A FredN1365Travel Air 5000 · S/N 219Cancelled Aug 7, 1931 · Rex Finance CorpN963KParks P-1 · S/N 198-15Cancelled Jul 29, 1931 · Associated Aircraft IncN644VCurtiss Wright CW-1 · S/N 1026Cancelled Jul 17, 1931 · Continental Airways IncN1139Travel Air 2000 · S/N 208Cancelled Jul 15, 1931 · Ghiggia Louis BN269HCurtiss Wright FLEDGLING · S/N B-47Cancelled Jul 9, 1931 · Curtiss Flying ServiceN64MMoth 60-GM · S/N 80Cancelled Jul 1, 1931 · Built 1929 · Curtiss Wright Flying Service Inc A Maine CorpN857ELockheed 2 VEGA · S/N 64Cancelled Jul 1, 1931 · Rubner Flying Service IncN397EBoeing 95 · S/N 1057Cancelled Jun 4, 1931 · Built 1929 · National Air Transport IncN377HGreat Lakes 2T-1 · S/N 12Cancelled May 15, 1931 · Central Air Terminal CoN2128Standard J-1 · S/N B-57Cancelled Feb 27, 1931 · Bittner Charles CN468MDetroit SEA ROVER E-2 · S/N 13Cancelled Jan 15, 1931 · Associated Aircraft IncorporatedN223HA V Roe AVRO BIPLANE · S/N 266Cancelled Jan 6, 1931 · Porter John PN424YStinson SM-8B · S/N 4257Cancelled Jan 6, 1931 · Mars IncN553KA V Roe AVRO BIPLANE · S/N 277Cancelled Jan 6, 1931 · Foust ChesterN852VWaco KNF · S/N 3260Cancelled Jan 6, 1931 · Foust ChesterN263MWaco 220T · S/N 3001Cancelled Jan 5, 1931 · Sanford StrongN29Curtiss Aeroplane & Motor CARRIER PIGEON · S/N 3Cancelled Oct 15, 1930 · H L SoardN224WStinson SM-8A · S/N 4030Cancelled Aug 22, 1930 · Emerman Louis E
Back to Chicago, IL