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.

N9141KStinson 108-1 · S/N 108-2141Cancelled Sep 11, 1958 · Built 1947 · Spencer RudolphN7891DPiper PA-22-150 · S/N 22-5513Cancelled Aug 7, 1958 · Exported to Canada · Graubart Aviation IncN8332BCessna 172 · S/N 36132Cancelled Jul 15, 1958 · Exported to Germany · Graubart Aviation IncN83335Aeronca 7AC · S/N 7AC-2002Cancelled Jul 15, 1958 · Exported to Germany · Graubart Aviation IncN9755EAeronca 11AC · S/N 11AC-1401Cancelled Jul 15, 1958 · Tanke RaymondN3136DCessna 180 · S/N 31934Cancelled Jul 11, 1958 · Exported to Canada · Graubart EliN6387ACessna 182 · S/N 33187Cancelled Jul 11, 1958 · Exported to Canada · Graubart EliN360AMooney M-18L · S/N 21Cancelled May 1, 1958 · Exported to Germany · Graubart Aviation IncN8828CPiper PA-22-135 · S/N 22-1441Cancelled May 1, 1958 · Exported to Germany · Graubart Aviation IncN6451ACessna 182 · S/N 33251Cancelled Mar 7, 1958 · Exported to Canada · Graubart Aviation IncN1122PPiper PA-23 · S/N 23-132Cancelled Mar 5, 1958 · West Instrument CorpN3856PPiper PA-22-150 · S/N 22-3548Cancelled Feb 27, 1958 · Built 1956 · Graubart Aviation IncN989BBell 47G · S/N 1404Cancelled Feb 27, 1958 · Exported to Colombia · Chicago Helicopter Airways IncN974BBell 47G · S/N 1377Cancelled Feb 26, 1958 · Exported to Colombia · Chicago Helicopter Airways IncN6856MStinson 108-3 · S/N 108-4856Cancelled Feb 19, 1958 · Exported to Canada · Graubart Aviation IncN777VBeech D18S · S/N A-46Cancelled Jan 16, 1958 · Exported to Canada · Built 1931 · Crane CoN978BBell 47G · S/N 1379Cancelled Jan 14, 1958 · Exported to Sweden · Chicago Helicopter Airways IncN9789BCessna 180A · S/N 50087Cancelled Jan 7, 1958 · Exported to Paraguay · Pure Oil CoN2655BAero Commander 560 · S/N 155Cancelled Nov 13, 1957 · Exported to Iran · Graubert EliN80269Culver V · S/N V-188Cancelled Nov 13, 1957 · Exported to Canada · Robert W BarronN39245Taylorcraft BC12-D · S/N 6499Cancelled Sep 20, 1957 · David M RuttN250BColonial C-1 · S/N 10Cancelled Aug 5, 1957 · Exported to Canada · Graubart Aviation IncN3869CCessna 180 · S/N 31017Cancelled Aug 2, 1957 · Exported to Canada · Graubart Aviation IncN6534ACessna 180 · S/N 32431Cancelled Jul 1, 1957 · Exported to Canada · Graubart Aviation IncN3447CCessna 170B · S/N 26490Cancelled Jun 24, 1957 · Exported to Germany · Graubart Aviation IncN4173BAero Commander 520 · S/N 52079Cancelled Jun 10, 1957 · Exported to Sweden · Built 1953 · Air Lease IncN999SNorth American NAVION · S/N NAV-4-90Cancelled May 28, 1957 · Somlo ThomasN3420DCessna 170B · S/N 26963Cancelled May 14, 1957 · Exported to Germany · Graubart Aviation IncN2119CCessna 195B · S/N 16104Cancelled Apr 25, 1957 · Exported to Uruguay · Graubart Aviation IncN6688HPiper J3C-65 · S/N 19898Cancelled Apr 25, 1957 · Exported to Canada · Graubart Aviation IncN4820APiper PA-22-150 · S/N 22-3973Cancelled Apr 8, 1957 · Graubart Aviation IncN6219ACessna 182 · S/N 33019Cancelled Mar 29, 1957 · Exported to Germany · Graubart Aviation IncN12365Curtiss-Wright T-32-C CONDOR II · S/N 25Cancelled Dec 30, 1956 · Exported to Mexico · Built 1933 · American Airlines IncN91667North American NAVION · S/N NAV-4-165Cancelled Dec 14, 1956 · Bourke W JohnN856BMooney M20 · S/N 1017Cancelled Oct 11, 1956 · Continental Uranium IncN64001Lockheed PV-1 · S/N 5326Cancelled Aug 28, 1956 · Crane CoN4349KRyan NAVION · S/N NAV-4-1349Cancelled Aug 21, 1956 · George Cassidy And SonsN8016KStinson 108 · S/N 108-3016Cancelled Aug 15, 1956 · Graubart Aviation IncN89549Cessna 140 · S/N 8589Cancelled Jul 30, 1956 · Kasallis Joseph JN3383Curtiss Wright JN4C · S/N 21Cancelled Jul 12, 1956 · Goddard Alfred CN4133MPiper PA-12 · S/N 12-3030Cancelled May 21, 1956 · Albert E PruessN75387Curtiss Wright C-46A · S/N 26945Cancelled Apr 30, 1956 · Exported to Nicaragua · Korer NormanN78190Globe GC-1B · S/N 2190Cancelled Mar 16, 1956 · Built 1946 · Chapman J RN79588Cessna T-50 · S/N 5441Cancelled Mar 16, 1956 · Aero Sky WritingN59236Boeing A75N1 · S/N 75-2851Cancelled Mar 8, 1956 · Frank CichanskiN88866Cessna T-50 · S/N 6260Cancelled Mar 5, 1956 · Intl Airlines IncN34668Stinson 10A · S/N 7968Cancelled Feb 24, 1956 · Ambrose Paul Et AlN72124Cessna 140 · S/N 9291Cancelled Feb 20, 1956 · Mundjer John AN1930PPiper PA-22 · S/N 22-2681Cancelled Feb 16, 1956 · Graubart Aviation IncN5651NConsolidated Vultee BT-15 · S/N 1109Cancelled Feb 16, 1956 · Hopson Louise
Back to Chicago, IL