OpenAirDocs.org
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.

N4200JPiper PA-28-140 · S/N 28-22544Cancelled Nov 20, 2012 · Registration expired, pending cancellation · Built 1966 · Lively Norman EN9538FHughes 269B · S/N 880383Cancelled Nov 20, 2012 · Sale reported, pending cancellation · Built 1968N3763XBeagle B.206 SERIES 1 · S/N B.026Cancelled Nov 15, 2012 · Registration expired, pending cancellation · Built 1980 · Garretson Robert DN57693Taylorcraft DCO-65 · S/N 5229Cancelled Nov 13, 2012 · Revoked, pending cancellation · Built 1943 · Menier HerbN4327YPiper PA-23-235 · S/N 27-615Cancelled Nov 9, 2012 · Sale reported, canceled · Built 1965N44613Beech D18S · S/N A-21Cancelled Nov 9, 2012 · Sale reported, canceled · Built 1945N42147Cessna 182L · S/N 18258873Cancelled Nov 7, 2012 · Sale reported, canceled · Built 1968N8039UDouglas DC-8-21 · S/N 45306Cancelled Nov 7, 2012 · Sale reported, pending cancellation · Built 1961N31658Piper PA-32-300 · S/N 32-7840140Cancelled Nov 6, 2012 · Registration expired, pending cancellation · Built 1978 · Intveld International IncN734MHCessna 172N · S/N 17268957Cancelled Oct 16, 2012 · Sale reported, pending cancellation · Built 1977N34057Taylorcraft BC12-65 · S/N 2921Cancelled Oct 3, 2012 · Registration expired, pending cancellation · Built 1941 · Klemanovic Michael PN300MRDouglas DC3-G202A · S/N 2014Cancelled Sep 25, 2012 · Registration expired, pending cancellation · Built 1955 · Evans Walter DBAN30792Cessna 177B · S/N 17701467Cancelled Sep 25, 2012 · Registration expired, pending cancellation · Built 1970 · Wright Wayne PN4526VBeech 35 · S/N D-1349Cancelled Sep 18, 2012 · Revoked, canceled · Built 1948 · Janowski Arthur JN4729GBowers Fly Baby 1-A · S/N 63-52Cancelled Sep 18, 2012 · Revoked, canceled · Built 1966 · Manasek Francis JN4787NCessna T-50 · S/N 4231Cancelled Sep 18, 2012 · Revoked, canceled · Built 1943 · Carpino John JN5356QCessna 150L · S/N 15073256Cancelled Sep 18, 2012 · Sale reported, pending cancellation · Built 1972N20388Cessna 172M · S/N 17261248Cancelled Sep 11, 2012 · Sale reported, canceled · Built 1972N79129Stinson AT-19 · S/N 7767Cancelled Sep 10, 2012 · Revoked, canceled · Built 1943 · Williams CharlesN79471Consolidated Vultee BT-13 · S/N 7995Cancelled Sep 10, 2012 · Revoked, canceled · Marlin Electric CoN8585HRyan NAVION · S/N NAV4543Cancelled Sep 10, 2012 · Revoked, canceled · Built 1947 · Vande Sande George AN88275Piper J3C-65 · S/N 15893Cancelled Sep 10, 2012 · Revoked, canceled · Built 1946 · Ericsson Arvid IN717ZBeech H-18 · S/N BA-710Cancelled Sep 6, 2012 · Revoked, canceled · Built 1964 · Sunstream Aircraft IncN75027Cessna T-50 · S/N 3513Cancelled Sep 6, 2012 · Revoked, canceled · Built 1943 · Skycombers Aero Club IncN3093DCessna 310 · S/N 35293Cancelled Sep 5, 2012 · Sale reported, canceled · Built 1956N65319Cessna T-50 · S/N 6494Cancelled Sep 5, 2012 · Revoked, canceled · Built 1942 · Stovall EmmittN2265ZRockwell International NA-265-80 · S/N 380-43Cancelled Aug 31, 2012 · Registration expired, pending cancellation · Built 1976 · Lively Norman EN5846ZPiper PA-22-108 · S/N 22-9700Cancelled Aug 30, 2012 · Revoked, canceled · Built 1963 · Dawson George RN5861BCessna 182A · S/N 33861Cancelled Aug 30, 2012 · Revoked, canceled · Built 1956 · Graubart EliN2072LBeech 58P · S/N TJ-72Cancelled Aug 23, 2012 · Registration expired, pending cancellation · Built 1976 · Lively Norman EN1381DCozza/Scholl Acft RAVEN · S/N 0001PCancelled Aug 22, 2012 · Registration expired, pending cancellation · Cozza/Scholl Aircraft IncN200NLSmith AEROSTAR 601 · S/N 61-0017Cancelled Aug 22, 2012 · Registration expired, pending cancellation · Built 1969 · Lively Norman EN5436NHoward DGA-15P · S/N 09775Cancelled Aug 22, 2012 · Revoked, canceled · Built 1942 · Morrissey David AN54386Piper PA-28-140 · S/N 28-7425115Cancelled Aug 22, 2012 · Revoked, canceled · Built 1973 · Northbott Norval DBAN24482Cessna 152 · S/N 15280279Cancelled Aug 14, 2012 · Sale reported, canceled · Built 1977N5340SCessna 337A · S/N 337-0440Cancelled Aug 14, 2012 · Revoked, canceled · Built 1966 · Liberty Leasing Co IncN45513Luscombe 8A · S/N 2040Cancelled Aug 13, 2012 · Sale reported, pending cancellation · Built 1946N51271Cessna T-50 · S/N 5011Cancelled Aug 13, 2012 · Revoked, canceled · Built 1947 · Stevens William AN19025Cessna 150L · S/N 15074103Cancelled Aug 9, 2012 · Registration pending, canceled · Built 1972N4790RBell 206B · S/N 328Cancelled Aug 7, 2012 · Revoked, canceled · Built 1969 · Air Leasing Associates 19N1478QCessna 150L · S/N 15072778Cancelled Aug 1, 2012 · Registration expired, pending cancellation · Built 1971 · N1478q Lk Aircraft Holdings LLCN46585Laister-Kauffman LK-10A · S/N 85Cancelled Jul 31, 2012 · Revoked, canceled · Geist J RichardN44998Douglas DC3 · S/N 11752Cancelled Jul 19, 2012 · Revoked, canceled · Built 1943 · Air Ohare Ltd International AirlineN810DSDiamond Aircraft Ind DA 40 · S/N 40.510Cancelled Jul 11, 2012 · Exported to Germany · Built 2005 · Levy Air LLCN442MHBeech C-45H · S/N AF-688Cancelled Jun 27, 2012 · Revoked, canceled · Built 1952 · Sky Train IncN69328Cessna 310R · S/N 310R0087Cancelled Jun 27, 2012 · Registration pending, canceled · Built 1974N43137Taylorcraft BC12-D · S/N 6796Cancelled Jun 21, 2012 · Revoked, canceled · Built 1946 · Marmel ShirleyN5137ECessna 172N · S/N 17271730Cancelled Jun 18, 2012 · Exported to Fiji · Built 1978 · 121 Aviation LLCN112ATRockwell International 112TC · S/N 13083Cancelled Jun 4, 2012 · Registration expired, pending cancellation · Built 1976 · Werner Hoermann LtdN111WEAero Commander 680T · S/N 1593-41Cancelled May 24, 2012 · Sale reported, canceled · Built 1966
Back to Chicago, IL