OpenAirDocs.org
Wood Dale, IL

Cancelled registrations · 86

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 = 'WOOD DALE'
  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.

N7733BBoeing 737-76N · S/N 32678Cancelled Sep 2, 2026 · Exported to Colombia · Built 2006 · Aar Aircraft & Engine Sales & Leasing IncN308DEBoeing 737-732 · S/N 29656Cancelled Jan 3, 2023 · Exported to Colombia · Aar Supply Chain IncN1269JCASA CN235 · S/N 012Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 1988 · Ep Aviation LLCN603AREADS CASA C-212-CC-15 AVIOCAR · S/N 162Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1980 · Ep Aviation LLCN105KRAirbus Industrie A319-133 · S/N 1053Cancelled May 8, 2021 · Registration expired, pending cancellation · Aar International IncN807MDEmbraer ERJ 170-100SU · S/N 17000020Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 2004 · Aar Supply Chain IncN3540RBell 214ST · S/N 28110Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Ep Aviation LLCN14930Embraer EMB-145EP · S/N 145011Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Built 1997 · Aar Supply Chain IncN634ARDehavilland DHC-8-103 · S/N 003Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Built 1983 · Ep Aviation LLCN330KWS N I A S SA330J · S/N 1418Cancelled Dec 6, 2019 · Exported to Romania · Built 1976 · Ep Aviation LLCN635ARDehavilland DHC-8-103 · S/N 047Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1986 · Ep Aviation LLCN594HABoeing 767-332 · S/N 23275Cancelled May 7, 2019 · Built 1986 · Aar Supply Chain IncN408HHSikorsky S-61N · S/N 61716Cancelled Feb 12, 2019 · Exported to Canada · Ep Aviation LLCN103WFSikorsky S-61N · S/N 61766Cancelled Nov 21, 2018 · Exported to South Korea · Built 1977 · Ep Aviation LLCN612RMSikorsky S-61N · S/N 61744Cancelled Aug 30, 2018 · Exported to Canada · Built 1975 · Ep Aviation LLCN802ARSikorsky S-61N · S/N 61757Cancelled Aug 21, 2018 · Built 1976 · Ep Aviation LLCN8886GCessna 340A · S/N 340A0713Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Glenway LeasingN636ARBoeing / Dehavilland DHC-8-103 · S/N 086Cancelled May 22, 2018 · Built 1987 · Ep Aviation LLCN963BWConstrucciones Aeronauticas C-212-CC · S/N 320Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Built 1985 · Ep Aviation LLCN2258FBell 412 · S/N 33073Cancelled Jan 12, 2018 · Registration expired, pending cancellation · Built 1982 · Ep Aviation LLCN21498Bell 412 · S/N 36003Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1989 · Ep Aviation LLCN107XBell 412 · S/N 33113Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 1985 · Ep Aviation LLCN956BWFairchild SA227-DC · S/N DC864BCancelled Apr 24, 2017 · Built 1994 · Ep Aviation LLCN955BWFairchild SA227-DC (C26B) · S/N DC821BCancelled Apr 20, 2017 · Ep Aviation LLCN39364Boeing 767-323 · S/N 24045Cancelled Mar 21, 2017 · Built 1988 · Aar Supply Chain IncN805ARSikorsky S-61N · S/N 61717Cancelled Feb 17, 2017 · Second renewal notice · Built 1974 · Ep Aviation LLCN3893LBell 412 · S/N 33006Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1981 · Ep Aviation LLCN8045TBell 214ST · S/N 28101Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1982 · Ep Aviation LLCN10241Aerospatiale SA330J · S/N 1472Cancelled Dec 10, 2014 · Third renewal notice · Built 1977 · Ep Aviation LLCN982BWCASA CN-235-10 · S/N C010Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Ep Aviation LLCN380SAAerospatiale SA330J · S/N 1422Cancelled Oct 22, 2013 · First renewal notice · Ep Aviation LLCN58545Mcdonnell Douglas DC-9-32 · S/N 47094Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1967 · Aar Parts Trading IncN593SCAirbus A320-200 · S/N 590Cancelled Feb 5, 2013 · Aar Parts Trading IncN278CSAirbus A320-214 · S/N 601Cancelled Dec 17, 2012 · Aar Parts Trading IncN5748MBell 214ST · S/N 28102Cancelled Jul 16, 2012 · Built 1984 · Ep Aviation LLCN739ABoeing 737-7AX · S/N 30183Cancelled Nov 1, 2011 · Built 2000 · Aar Parts Trading IncN126PABell 412 · S/N 33168Cancelled Sep 12, 2011 · Built 1988 · Ep Aviation LLCN22608Bell 412 · S/N 33075Cancelled Sep 12, 2011 · Ep Aviation LLCN2261DBell 412 · S/N 33076Cancelled Sep 12, 2011 · Built 1982 · Ep Aviation LLCN108XBell 412 · S/N 33115Cancelled Sep 10, 2011 · Built 1985 · Ep Aviation LLCN1202TBell 412 · S/N 33112Cancelled Sep 10, 2011 · Second renewal notice · Built 1985 · Ep Aviation LLCN3893NBell 412 · S/N 33010Cancelled Sep 10, 2011 · Built 1981 · Ep Aviation LLCN33008Bell 412 · S/N 36004Cancelled Aug 24, 2011 · Exported to Canada · Built 1990 · Ep Aviation LLCN2149SBell 412 · S/N 36002Cancelled Aug 23, 2011 · Exported to Canada · Built 1989 · Ep Aviation LLCN7128RBell 412 · S/N 36007Cancelled Aug 23, 2011 · Exported to Canada · Built 1990 · Ep Aviation LLCN160AWBoeing 737-3G7 · S/N 23782Cancelled Mar 5, 2009 · Built 1988 · Aar-Crane Leasing I LLCN611DLBoeing 757-232 · S/N 22818Cancelled Feb 18, 2009 · Built 1985 · Aar Parts Trading IncN607DLBoeing 757-232 · S/N 22814Cancelled Dec 31, 2008 · Aar Parts Trading IncN311AWBoeing 737-3G7 · S/N 24712Cancelled Nov 20, 2008 · Exported to Venezuela · Built 1990 · Aar-Crane Leasing I LLCN902UABoeing 737-522 · S/N 25002Cancelled Oct 29, 2008 · Built 1990 · Aar Parts Trading Inc
Back to Wood Dale, IL