OpenAirDocs.org
Downers Grove, IL

Cancelled registrations · 48

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 = 'DOWNERS GROVE'
  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.

N6913PPiper PA-24-250 · S/N 24-2047Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Joseph John SN8294PPiper PA-24-250 · S/N 24-3547Cancelled Dec 5, 2020 · Registration expired, pending cancellation · Built 1963 · Claene CorpN9VEBede BD-4 · S/N 82Cancelled Mar 16, 2018 · Revoked, canceled · Built 1976 · Vail Donald LN5620HQuicksilver QUICKSILVER II SPRNT · S/N 0556Cancelled Feb 15, 2018 · Registration expired, pending cancellation · Built 1997 · Majchrzak Jeffrey TN190MBHarmening High Flyer 503 STANDARD · S/N HHF 5801Cancelled Feb 9, 2018 · Registration expired, pending cancellation · Built 1996 · Coletta Scott MN9130NPiper PA-46-310P · S/N 4608075Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1987 · Eberhardt Air IncN3AZZimmerman Arnold BREEZY · S/N JD1Cancelled Aug 31, 2017 · First renewal notice · Built 1998 · A Z Air Lease IncN72MACessna 172M · S/N 17264918Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1975 · Schwartz Michael FN7172XCessna 150A · S/N 15059272Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1961 · Mcguire Jack WN1495PPiper PA-23 · S/N 23-565Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Built 1956 · Galos Peter IN655Daniels VOLKSPLANE 473 · S/N 0656Cancelled Aug 14, 2013 · Revoked, canceled · Built 1973 · Dennert Patrick LN7719UCessna 172E · S/N 17251719Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1964 · Jones Wendell JN759HFCessna 182Q · S/N 18266001Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1977 · Oskvarek Evangeline TrusteeN713RMAmateur-Built HP-13A · S/N 1Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1966 · Ridenour Neal HN56871Piper PA-28-140 · S/N 28-7425055Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1973 · Kurtz Richard AN3462Let BLANIK L-13 · S/N 173920Cancelled Apr 16, 2013 · Registration expired, pending cancellation · Built 1969 · Barowski John P SrN50702Bellanca 8KCAB · S/N 616-80Cancelled Mar 21, 2013 · Registration expired, pending cancellation · Lewis Richard AN24489Cessna 152 · S/N 15280284Cancelled Feb 11, 2013 · Registration expired, pending cancellation · Built 1977 · O Hara JeromeN729LBLindstrand Balloons 77A · S/N 5027Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Built 1997 · Obrien Robert PN6201HPiper J3C-65 · S/N 19369Cancelled Jun 21, 2012 · Registration pending, canceled · Built 1946N912JFCessna P337H · S/N P3370315Cancelled Oct 24, 2008 · Exported to Mexico · Built 1978 · Kilo Echo Aviation Co IncN81557Piper PA-32R-301T · S/N 32R-8029055Cancelled Oct 1, 2002 · Triennial form not returned · Built 1980 · Wfh LpN6540NCessna T210N · S/N 21063096Cancelled Sep 26, 2001 · Exported to Mexico · Hansen Leroy EN13RMBeech 95-B55 (T42A) · S/N TC791Cancelled Apr 20, 1998 · Sale reportedN8480ABeech A35 · S/N D1900Cancelled Mar 12, 1997 · Grs CompanyN1422UCessna 172M · S/N 17267089Cancelled Jun 9, 1995 · Exported to South Africa · Shamrock Flyers IncN366TLLynch Thomas CHALLENGER II · S/N CH21088B0366Cancelled Jan 10, 1995 · Triennial form not returned · Lynch ThomasN95669Cessna 152 · S/N 15285956Cancelled Feb 13, 1992 · Exported to Australia · Shamrock Flyers IncN78BDBiela-Dennis WRIGHT FLYER · S/N 7578WFCancelled Apr 30, 1991 · Triennial form not returned · Cherokee Aero IncN9529ZCessna U206G · S/N U20606542Cancelled Jan 18, 1991 · Exported to Brazil · Shamrock Flyers IncN7ZUBeech E-90 · S/N LW-251Cancelled Dec 4, 1989 · Exported to France · Chicago Aircraft Services IncN7253RBeech E-55 · S/N TE-1021Cancelled Nov 15, 1985 · Exported to Sweden · Kaye TerryN756VTCessna TU206G · S/N U20604397Cancelled Jul 31, 1985 · Jepsen Jack EN53015Cessna 172 · S/N 17274662Cancelled Oct 25, 1983 · Built 1981 · Staray Thomas A & Nancy PN21510Cessna 182P · S/N 18261679Cancelled Dec 24, 1981 · Built 1973 · James Andrew EN3NPNaval Aircraft Factory N3N-3 · S/N 3046Cancelled May 25, 1979 · Built 1963 · Prose Adolph L & Prose Dorothy AN1WNGlasflugel STD LIBELLE 201B · S/N 512Cancelled Nov 25, 1977 · Ridenour And Beck Flying Assn IncN46568Cessna 172K · S/N 172-57356Cancelled Jan 14, 1975 · Kern Roger AN2DKCessna T337D · S/N 337-1099Cancelled Nov 27, 1974 · Exported to Canada · Built 1969 · Krughoff James E And Desideri Ronald FN3810CAero Commander 680-E · S/N 680E-750-40Cancelled Oct 28, 1970 · Built 1959 · National Aero Sales CorpN6834PPiper PA-24-250 · S/N 24-1967Cancelled Sep 24, 1970 · Schuchmann Jack DN6890DBaby Ace D · S/N 3836Cancelled Sep 21, 1970 · Built 1959 · Ridenour Neal HN9609HCessna T-50 · S/N 6252Cancelled Sep 8, 1970 · Thompson B EdwardN6422MStinson 108-3 · S/N 108-4422Cancelled Jun 22, 1970 · Otto James NemecN36435Taylorcraft BL-65 · S/N 3251Cancelled May 20, 1965 · Built 1943 · Saulnier James EN2290NCessna 140 · S/N 12530Cancelled Feb 19, 1958 · Built 1947 · Furcich John JN26412Stinson 10 · S/N 7606Cancelled Oct 19, 1955 · Built 1940 · Mclaughlin John LN85965Aeronca 11AC · S/N 11AC-387Cancelled Oct 13, 1955 · L E Applequist And Clarence Godshalk
Back to Downers Grove, IL