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.

N982RDJI INSPIRE 1 · S/N W13DCC23030835Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Richter Brothers Studios Inc DBAN857AACessna 550 · S/N 550-0901Cancelled Apr 19, 2021 · Built 2000 · Jssi Parts LLCN241TXLearjet 60 · S/N 086Cancelled Mar 31, 2021 · Built 1996 · Jssi Parts LLCN271RAIsrael Aircraft Industries GULFSTREAM 200 · S/N 104Cancelled Mar 31, 2021 · Built 2004 · Jssi Parts LLCN601MUCanadair CL-600-2B16 · S/N 5160Cancelled Mar 31, 2021 · First renewal notice · Built 1994 · Jssi Parts LLCN604SLLearjet 60 · S/N 060Cancelled Mar 31, 2021 · Built 1995 · Jssi Parts LLCN878RGLearjet 60 · S/N 027Cancelled Mar 12, 2021 · Exported to Mexico · Sworks Aviation LLCN7GHHenry-Fosndcht PITTS SPECIAL S-1 · S/N 001Cancelled Feb 20, 2021 · Sale reported, canceled · Built 1972N625LRCanadair CL-600-2B16 · S/N 5075Cancelled Nov 16, 2020 · Built 1990 · Jssi Parts LLCN533RVDarville Thomas RV-6 VANS ACFT · S/N 21025Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 1998 · Wright Ronald CN818HMMichael R Monar DJI INSPIRE 2 · S/N OAOLDAA003005UCancelled Sep 4, 2020 · Registration expired, pending cancellation · Monar Michael RN818KMMichael R Monar DJI INSPIRE 2 · S/N 09YDDCSL041722Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Monar Michael RN850TRBombardier BD-700-1A10 · S/N 9027Cancelled Jul 17, 2020 · Built 1999 · Jssi Parts LLCN36502Aeronca 65-LB · S/N LB-15651Cancelled May 15, 2020 · Revoked, canceled · Built 1941 · Benner Vernon & Spizzirri Louis EN107UABoeing 747-422 · S/N 26900Cancelled Apr 9, 2020 · Built 1998 · United Airlines IncN71832Luscombe 8A · S/N 3259Cancelled Feb 10, 2020 · Revoked, canceled · Built 1946 · Airflyte AssocN7037ZPiper PA-25-235 · S/N 25-2706Cancelled Jan 31, 2020 · Revoked, canceled · Built 1964 · Airlease IncN57730Taylorcraft DC-65 · S/N 5130Cancelled Dec 30, 2019 · Revoked, canceled · Built 1943 · Dykstra Jay NN578BBeech A35 · S/N D-1597Cancelled Dec 13, 2019 · Revoked, canceled · Built 1948 · Mendius Tom EN32882Piper J4A · S/N 41321Cancelled Dec 9, 2019 · Revoked, canceled · Built 1940 · Williams Little J DrN45MPPonton M/Ponton M E VELOCITY SUV · S/N SUV110Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Ponton MarioN26123Boeing 757-224 · S/N 28966Cancelled Nov 22, 2019 · Built 1997 · United Airlines IncN24066Taylorcraft BL-65 · S/N 1601Cancelled Nov 15, 2019 · Revoked, canceled · Built 1939 · Flood James WN3472APiper PA-22-135 · S/N 22-1741Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Built 1953 · Chicago Dodo Chapter Of Tuskegee Airmen IncN137LEDJI Innovations PHANTOM 3 PROFESSION · S/N P76DCF10014232Cancelled Nov 1, 2019 · Registration expired, pending cancellation · Chicago Aerial Video LLCN2134VCessna 120 · S/N 14359Cancelled Oct 25, 2019 · Revoked, canceled · Built 1948 · Obrien Eugene JN220KSDassault-Breguet FALCON 10 · S/N 71Cancelled Oct 23, 2019 · Sale reported · Built 1984N69783Fairchild M-62A · S/N 1052AECancelled Oct 21, 2019 · Revoked, canceled · Built 1943 · Latham James DN1124DCessna 140A · S/N 15688Cancelled Oct 18, 2019 · Revoked, canceled · Built 1951 · Marquardt Harald WN8345BCessna 172 · S/N 36145Cancelled Oct 11, 2019 · Revoked, canceled · Built 1957 · Willi Fred CN22241Taylorcraft BF · S/N 1189Cancelled Oct 5, 2019 · Revoked, canceled · Built 1939 · Dimmock ArchieN7484BMichael R Monar DJI INSPIRE 1 · S/N W13DDA12061373Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Monar Michael RN749HBMichael R Monar DJI INSPIRE 1 · S/N W21ACI27011266Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Monar Michael RN754QLDJI Innovations PHANTOM 3 PROFESSION · S/N P76DCH03016743Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Leep DavidN14171Embraer EMB-145XR · S/N 14500859Cancelled Oct 3, 2019 · Sale reported · Built 2004N86906Bellanca 14-13 · S/N 1268Cancelled Oct 2, 2019 · Revoked, canceled · Built 1946 · National Society For Medical ResearchN116UABoeing 747-422 · S/N 26908Cancelled Sep 25, 2019 · Built 1998 · United Airlines IncN561RPEmbraer EMB-145LR · S/N 145447Cancelled Sep 25, 2019 · Exported to Namibia · Built 2002 · Alf Vi IncN685KAFreefly Systems ALTA · S/N 311877Cancelled Sep 9, 2019 · Registration expired, pending cancellation · Vision Reactor Productions LLCN685LPDJI INSPIRE 1 · S/N W13DCA22020509Cancelled Sep 9, 2019 · Registration expired, pending cancellation · Aerial Visual Productions IncN1242ZBeech 95-55 · S/N TC-77Cancelled Sep 6, 2019 · Revoked, canceled · Built 1961 · Enssle Bruno EN12519Embraer EMB-135LR · S/N 145366Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 2001 · United Airlines IncN14505Embraer EMB-135ER · S/N 145192Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1999 · United Airlines IncN14508Embraer EMB-135ER · S/N 145220Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 2000 · United Airlines IncN14516Embraer EMB-135LR · S/N 145323Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 2000 · United Airlines IncN14522Embraer EMB-135LR · S/N 145383Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 2001 · United Airlines IncN14875Goodwin HEATH V · S/N CH7-SCancelled Sep 6, 2019 · Revoked, canceled · Built 1936 · Joyce Joseph LeoN16520Embraer EMB-135LR · S/N 145372Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 2001 · United Airlines IncN17507Embraer EMB-135ER · S/N 145215Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 2000 · United Airlines IncN17521Embraer EMB-135LR · S/N 145378Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 2001 · United Airlines Inc
Back to Chicago, IL