OpenAirDocs.org
Elyria, OH

Cancelled registrations · 76

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 = 'OH' AND d.registrant_city = 'ELYRIA'
  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.

N3023NCessna 140 · S/N 13281Cancelled May 4, 2024 · Revoked, canceled · Built 1947 · Kenney Edward AN98527Piper J3C-65 · S/N 18735Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Built 1946 · Begany Joseph EN2543VCessna 170 · S/N 18047Cancelled Nov 22, 2019 · Revoked, canceled · Built 1948 · Palamara Joseph AN920LMBirdseyeview Aerobotics FIREFLY 6 · S/N 6-PRO-1171Cancelled Nov 15, 2019 · Sale reported, canceledN1403EAeronca 7AC · S/N 7AC-4967Cancelled Oct 2, 2019 · Revoked, canceled · Built 1946 · Olbrich CyN31358Aeronca 65-TL · S/N L6060TCancelled Aug 2, 2018 · Revoked, canceled · Built 1940 · Butler Raymond JN866AWAero Vodochody L29 · S/N 294685Cancelled Apr 27, 2016 · Exported to Canada · Built 1972 · Phantom Phlyers LLCN503MBeech 65-A90 · S/N LJ-158Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1966 · Spillman Robert LN45801Luscombe 8A · S/N 2328Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 1946 · Baker Jeffry LN30LKFlight Design CTLS · S/N F-09-04-08Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 2009 · Ras Aviation LLCN64501Fairchild M-62A · S/N 4223AECancelled Aug 6, 2013 · Revoked, canceled · Built 1943 · Balcomb SallyN506ACPiper PA-23-250 · S/N 27-7305018Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1973 · Masters SumpterN604ANAerospatiale SN-601 CORVETTE · S/N 18Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1975 · Air National Acft Sls & Svc IncN66102Cessna 172S · S/N 172S9779Cancelled Nov 19, 2012 · Exported to Canada · Built 2005 · Dougmac Air LtdN6165SAir & Space America 18A · S/N 18-79Cancelled Aug 30, 2012 · Revoked, canceled · Built 1966 · Abbe Horace EN61844Cessna T-50 · S/N 5996Cancelled Aug 30, 2012 · Revoked, canceled · Built 1944 · Balcomb SallyN906MWDehavilland DH104 DOVE 7AXC · S/N 04449Cancelled Jul 26, 2011 · Expired dealer · Built 1953 · Midwest Aircraft Sales IncN9801ZBeech C-45H · S/N 52-10669Cancelled Sep 18, 2009 · Registration revoked · Built 1952 · Swift Air Charter IncN16474Rearwin 8500 · S/N 504Cancelled Aug 17, 2009 · Built 1936 · Sharick David MN4919VDehavilland DH104 DOVE 7AXC · S/N 04282Cancelled Jul 27, 2009 · Registration revoked · Built 1950 · Aero Leasing Inc No 13N4923VDehavilland DH104 DOVE 7AXC · S/N 04286Cancelled Jul 27, 2009 · Registration revoked · Built 1950 · Aero Leasing Inc No 12N6343JPiper PA-28-180 · S/N 28-4752Cancelled Mar 30, 2009 · Triennial form not returned · Built 1968 · Zak Edwin AN802MCCessna 152 · S/N 15280761Cancelled Apr 18, 2007 · Triennial form not returned · Built 1977 · Alexson LtdN42TBeech E18S · S/N BA-241Cancelled Apr 11, 2007 · Registration revoked · Built 1957 · Tarry John RN19AGPiper PA-28R-180 · S/N 28R-30892Cancelled Jan 30, 2006 · Triennial form not returned · Built 1968 · Swanger Larry AN51941Fairchild M-62A · S/N T42-1838Cancelled Aug 25, 2000 · Second triennial mailing, no response · Sharick Raymond GN269CSScott Charles L MINI 500 · S/N 0237Cancelled Dec 14, 1999 · Triennial form not returned · Scott Charles LN27MFCessna U206G · S/N U20604700Cancelled Mar 5, 1999 · Exported to Botswana · Cook Susan MargaretN6327ZCessna U206G · S/N U20606237Cancelled Mar 4, 1999 · Exported to Botswana · Cook Susan MN735JMCessna U206G · S/N U20604927Cancelled Mar 4, 1999 · Exported to Botswana · Cook Susan MargaretN553CSScott Charles L BENSEN B8M · S/N 271508146Cancelled Sep 13, 1997 · Triennial form not returned · Scott Charles LN628RCPilatus Britten-Norman BN2B-20 · S/N 2203Cancelled Mar 19, 1996 · Exported to Botswana · Cook Robert SN999BRBritten Norman BN-2B-20 · S/N 2173Cancelled Mar 6, 1996 · Exported to Botswana · Lumsden Susan MN2503LPiper PA-38-112 · S/N 3879A0736Cancelled Sep 6, 1995 · Triennial form not returned · Waldron Nancie LN555AVPiper PA-31 · S/N 31693Cancelled Mar 18, 1994 · Exported to Canada · Millard Enterprises IncN661JHBaxter James M SILVER CLOUD · S/N SR85026SCXCancelled Jan 10, 1992 · Baxter James MN4545FPiper PA-28-151 · S/N 287715048Cancelled Apr 17, 1991 · Triennial form not returned · Koba TimothyN124MWPiper PA-23-250 · S/N 27-2563Cancelled Sep 15, 1980 · Built 1964 · Aero Leasing Inc No 16N704LSCessna 150M · S/N 15078701Cancelled Aug 5, 1980 · Midwest Aircraft SalesN5542JPiper PA-32-260 · S/N 321005Cancelled Jul 8, 1977 · Mccracken Howar IN321DBeech D18S · S/N A-413Cancelled May 31, 1977 · Swift Air Charter IncN757ZDouglas DC-7B · S/N 44924Cancelled May 27, 1976 · Built 1956 · Woltz HarryN91283Beech C-45H · S/N AF-437Cancelled May 15, 1976 · Tarry Jack RN4277BBeech E18S · S/N BA80Cancelled May 5, 1976 · Built 1955 · Swift Air Charter IncN45216Cessna 150M · S/N 150-76789Cancelled Jan 7, 1976 · Built 1975 · Lorain Cnty Ace IncN40731Piper PA-34-200 · S/N 34-7450073Cancelled Dec 29, 1975 · Exported to Canada · Built 1973 · Lorain County Ace IncN9508KStinson 108-2 · S/N 108-2508Cancelled Jul 23, 1975 · Presti Gene Et AlN179LBeech SNB-5 · S/N 67115Cancelled Jun 16, 1975 · Swift Air Charter IncN547CStinson 108-3 · S/N 1083547Cancelled Jun 10, 1975 · Kenney Edward AN19799Cessna 172M · S/N 17260762Cancelled May 29, 1975 · Exported to Canada · Built 1972 · Lorain County A C E DBA Air Central Enterprises
Back to Elyria, OH