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.

N396DZZelazo Dan T AVID FLYER SPEEDWING · S/N 447Cancelled May 12, 1995 · Triennial form not returned · Zelazo Dan TN3160PPiper PA-23 · S/N 231092Cancelled Apr 29, 1995 · Triennial form not returned · Uzyn Jerry JN15TSNelson Bruce H CHRISTEN EAGLE II · S/N N0001Cancelled Jul 18, 1994 · Triennial form not returned · Sinnott Thomas MN8066MCessna 310I · S/N 310I0066Cancelled Jun 29, 1994 · Triennial form not returned · Barys Joseph FN7621UBoeing 727-222 · S/N 19538Cancelled Jun 17, 1994 · Triennial form not returned · United Air Lines IncN1804UMcdonnell Douglas DC-10-10 · S/N 46603Cancelled May 31, 1994 · Triennial form not returned · United Air Lines IncN1805UMcdonnell Douglas DC-10-10 · S/N 46604Cancelled May 3, 1994 · Triennial form not returned · United Air Lines IncN6600WPiper PA-28-140 · S/N 2820691Cancelled Apr 13, 1994 · Exported to Lithuania · Juknius JonasN58JRBeech 200 · S/N BB558Cancelled Mar 21, 1994 · Exported to Argentina · Fmc CorporationN7215UBoeing 720-022 · S/N 18047Cancelled Mar 14, 1994 · United Air Lines Inc/Executive OfficesN7622UBoeing 727-222 · S/N 19539Cancelled Mar 9, 1994 · Triennial form not returned · United Air Lines IncN7625UBoeing 727-222 · S/N 19542Cancelled Mar 9, 1994 · Triennial form not returned · United Air Lines IncN7227NCessna 182P · S/N 18263018Cancelled Oct 6, 1993 · Triennial form not returned · Miller Aircraft Company IncN7020UBoeing 727-22 · S/N 18312Cancelled Apr 21, 1993 · Triennial form not returned · United Air Lines IncN421BSCessna 421C · S/N 421C0042Cancelled Apr 14, 1993 · Exported to Germany · Allegra Unlimited IncN5995SBeech A23-19 · S/N MB85Cancelled Oct 22, 1992 · Triennial form not returned · National Air Service IncN7296UBoeing 727-222 · S/N 21574Cancelled Oct 16, 1992 · Triennial form not returned · United Air Lines IncN7017UBoeing 727-22 · S/N 18309Cancelled Oct 14, 1992 · Triennial form not returned · United Air Lines IncN5710ECessna 172N · S/N 17271924Cancelled Aug 28, 1992 · Gardner TerryN938MLDouglas DC-9 · S/N 47007Cancelled Aug 6, 1992 · Exported to Venezuela · Mwa Holding IncN1814TPiper PA-28-140 · S/N 287125166Cancelled Aug 3, 1992 · Toof Jan JN732TRCessna T210M · S/N 21061766Cancelled Jun 15, 1992 · Triennial form not returned · Prompt Air IncN412GKPiper PA-28-236 · S/N 287911047Cancelled Apr 10, 1992 · Heck Thomas J IIIN9910DPiper PA-28RT-201T · S/N 28R8031127Cancelled Apr 7, 1992 · Exported to Germany · Ms LtdN725CCBritish Aerospace HS 125-700A · S/N NA0220Cancelled Feb 25, 1992 · Exported to Mexico · Built 1978 · Francis Bruce TrusteeN5336FPiper PA-28-181 · S/N 287790091Cancelled Jan 17, 1992 · Exported to Germany · Marra JamesN312ATDassault-Breguet FALCON 10 · S/N 209Cancelled Jan 15, 1992 · Exported to Switzerland · American Information Techn CorpN100BFCessna 172M · S/N 17267339Cancelled Oct 10, 1991 · Exported to Israel · Chicago Aviation IncN4091UPiper PA-31-350 · S/N 318152159Cancelled Sep 19, 1991 · Triennial form not returned · American Central Airlines IncN16217Cessna 150L · S/N 15073550Cancelled Aug 28, 1991 · Exported to Germany · La Pook Gary JN2852KPiper PA-28-181 · S/N 287990494Cancelled Jul 8, 1991 · Exported to France · Zeemack Aircraft Sales IncN27BKBell 206B · S/N 2193Cancelled Jun 14, 1991 · Exported to Venezuela · International Aircraft Sales IncN21868Piper PA-28-181 · S/N 287990064Cancelled Mar 22, 1991 · Exported to Sweden · Zeemack Aircraft Sales IncN8312CPiper PA-28RT-201T · S/N 28R8331012Cancelled Dec 13, 1990 · Exported to Germany · Midway Aircraft Brokers IncN5191BAerospatiale AS 355F · S/N 5268Cancelled Apr 26, 1988 · Exported to Venezuela · International Aircraft Sales IncN2368TNavion NAVION G · S/N NAV-4-2368Cancelled Jun 22, 1987 · Registration expired, pending cancellation · Built 1961 · Walton Frank C SrN757RCCessna 152 · S/N 15279935Cancelled Jun 19, 1986 · Exported to Iceland · Zeemack Aircraft Sales IncN6937QBeech A23A · S/N M 1083Cancelled Jun 16, 1986 · Exported to Iceland · Zeemack Aircraft Sales IncN733KHCessna 172N · S/N 17268349Cancelled Jun 12, 1986 · Exported to Iceland · Zeemack Aircraft Sales IncN560RDassault FALCON 20 F · S/N 313Cancelled Apr 11, 1985 · Central Conference Of TeamstersN52444Cessna 172P · S/N 17274525Cancelled Dec 27, 1984 · Buslik LeeN5750Kohl BABY GREAT LAKES · S/N 6822-H-124-BCancelled Sep 26, 1984 · Kohl JosephN702PHawker Siddeley DH.125-400A · S/N NA-740Cancelled Aug 8, 1984 · Exported to Brazil · Sears Roebuck And CompanyN7627UBoeing 727-222 · S/N 19900Cancelled Jun 17, 1984 · Triennial form not returned · United Air Lines IncN4805NPiper PA-31P · S/N 31P3Cancelled Jun 13, 1984 · Exported to United Kingdom · Garretson Robert DN5589SMitsubishi MU-2B-20 · S/N 150Cancelled Apr 24, 1984 · Clark Robert GN85JKCessna 340A · S/N 340A0700Cancelled Mar 7, 1984 · Administratively canceled · Goodman Melvyn JN8035UDouglas DC-8-52 · S/N 45302Cancelled Jan 10, 1984 · Administratively canceled · United Air Lines IncN8009UDouglas DC-8-51 · S/N 45286Cancelled Dec 31, 1983 · Administratively canceled · United Air Lines IncN5266PPiper PA-24-250 · S/N 24302Cancelled Oct 20, 1983 · Becker Norman J
Back to Chicago, IL