Cleveland, OH

Cancelled registrations · 480

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 = 'CLEVELAND'
  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.

N5056SPiper PA-28R-200 · S/N 28R-35785Cancelled Mar 21, 2013 · Registration expired, pending cancellation · Built 1970 · Maloney Thomas VN59MWKier VARIEZE · S/N 618Cancelled Mar 19, 2013 · Registration expired, pending cancellation · Built 1980 · White Macey W JrN931BDLasecki BD-5 · S/N 931Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1975N81614Aeronca 7AC · S/N 7AC-226Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1945N7061XCessna 150A · S/N 15059161Cancelled Feb 20, 2013 · Sale reported, canceled · Built 1961N6541KGrumman Acft ENG Cor-Schweizer G-164B · S/N 360BCancelled Feb 13, 2013 · Sale reported, canceled · Built 1977N148PABeech H-18 · S/N BA-645Cancelled Jan 31, 2013 · Registration expired, pending cancellation · Built 1963 · Ace Air Cargo Express IncN48371Aeronca 0-58B · S/N 10453Cancelled Nov 13, 2012 · Revoked, canceled · Built 1943 · Fenn College Flying Club IncN1704JPiper PA-28-140 · S/N 28-24112Cancelled Oct 15, 2012 · Registration expired, pending cancellation · Built 1967 · Bryson Mark WN6912KGrumman Acft ENG Cor-Schweizer G-164B · S/N 520 BCancelled Oct 15, 2012 · Sale reported, pending cancellation · Built 1979N3381BPiper PA-22-135 · S/N 22-2180Cancelled Oct 3, 2012 · Registration expired, pending cancellation · Built 1954 · Weirich William CN2857HErcoupe 415-C · S/N 3482Cancelled Sep 24, 2012 · Registration expired, pending cancellation · Built 1946 · Csehi Joseph GN2791Schempp-Hirth CIRRUS · S/N 25Cancelled Sep 21, 2012 · Registration expired, pending cancellation · Built 1968 · Nagy SandorN240CSPiper PA-28-140 · S/N 28-24338Cancelled Sep 6, 2012 · Registration expired, pending cancellation · Built 1968 · Cleveland Board Of EducationN91822Schweizer SGU-1-19 · S/N 46Cancelled Sep 4, 2012 · Registration expired, pending cancellation · Built 1956 · Nemes Andrew CN5362WPiper PA-28-150 · S/N 28-427Cancelled Aug 21, 2012 · Revoked, canceled · Built 1962 · United States Leasing CorpN2441BPiper PA-38-112 · S/N 38-79A0063Cancelled Aug 14, 2012 · Sale reported, canceledN4501ZPiper PA-22-108 · S/N 22-8001Cancelled Jul 19, 2012 · Revoked, canceled · Built 1960 · Robel Roland JN10559Harral William T CAVALIER SA 102 5 · S/N 70022Cancelled May 18, 2012 · Registration expired, pending cancellation · Built 1979 · Callahan Edward FN557ADarville Thomas RV-6 VANS ACFT · S/N R-1Cancelled Feb 8, 2012 · Revoked, pending cancellation · Built 1962 · Roselle John GN2597APiper PA-22-135 · S/N 22-880Cancelled Dec 16, 2011 · Triennial form not returned · Built 1952 · Svetlik Clevis TN2740PPiper PA-22-150 · S/N 22-3047Cancelled Dec 16, 2011 · Second renewal notice · Built 1955 · Svetlik Clevis TN574DALearjet 60 · S/N 055Cancelled Aug 30, 2011 · Exported to China · Built 1995 · Jet Associates East LLCN30330Piper J3L-65 · S/N 4795Cancelled Aug 19, 2011 · Revoked, pending cancellation · Built 1940 · Woodard Ray GN3583VCessna 140 · S/N 14852Cancelled May 26, 2010 · Exported to Australia · Built 1948 · Todd Brian JN4231SCessna 180H · S/N 18052198Cancelled Apr 12, 2010 · Exported to Canada · Built 1971 · Baptist Mid-MissionsN125TFBeech C-45H · S/N AF-351Cancelled Sep 18, 2009 · Registration revoked · Built 1953 · Johnston James MN14215Rider Keith R-3 · S/N A1Cancelled Sep 17, 2009 · Registration revoked · Built 1934 · Welded Construction Engng CoN960ZSzaraz Arpad S DAPHNE · S/N 1Cancelled Sep 17, 2009 · Registration revoked · Built 1963 · Szaraz Arpad SN9936ACessna 170A · S/N 19296Cancelled Sep 17, 2009 · Registration revoked · Built 1950 · Brajer JosefaN424LXRaytheon 400A · S/N RK-245Cancelled May 8, 2009 · Exported to Thailand · Built 1999 · Jet Associates East LLCN82550Aeronca 7AC · S/N 7AC-1187Cancelled Apr 16, 2009 · Triennial form not returned · Built 1946 · Svetlik Clevis TN83419Aeronca 7AC · S/N 7AC-2086Cancelled Apr 13, 2009 · Triennial form not returned · Built 1946 · Svetlik Clevis TN219HMBell 222U · S/N 47573Cancelled Mar 4, 2009 · Exported to Australia · Built 1988 · Fifth Third BankN215SWEmbraer EMB-120ER · S/N 120.281Cancelled Jan 26, 2009 · Exported to Angola · Built 1993 · N215sw LLCN476TSikorsky S-76A · S/N 760228Cancelled Jun 15, 2005 · Exported to Australia · Built 1983 · Maxus Leasing Group IncN9413ZCessna TU206G · S/N U20606474Cancelled Jun 3, 2004 · Exported to Mexico · Built 1981 · Drug Enforcement AdministrationN618NABeech T-34C · S/N 160632Cancelled Feb 6, 2004 · Triennial form not returned · National Aeronautics And Space AdministrationN62RCCurtis Roy ROTORWAY EXECUTIVE · S/N 3297Cancelled Oct 14, 2003 · Triennial form not returned · Curtis Roy HN106DUUrsem Richard E SKY NCOMMUTER · S/N 006Cancelled Sep 6, 2001 · Triennial form not returned · Ursem Richard EN7751Helicopter COMMUTER JR. · S/N 1962Cancelled Dec 31, 1998 · Triennial form not returned · Naujoks Ellwood VN100MKLearjet 25 · S/N 019Cancelled Mar 6, 1997 · Triennial form not returned · Kelco Aircraft CoN5156PCessna 152 · S/N 15284886Cancelled Oct 24, 1996 · Exported to Chile · Malloy Raymond JN28163Socata TB21TC · S/N 1123Cancelled Nov 30, 1995 · Pittler IncorporatedN739ECCessna 172N · S/N 17270476Cancelled Oct 27, 1992 · Triennial form not returned · Baron Aviation IncN4698QCessna 152 · S/N 15285052Cancelled Jul 23, 1992 · Triennial form not returned · Kosir JohnN8026JBeech B200 · S/N BB1392Cancelled Apr 9, 1992 · Exported to Colombia · Bp America IncN8484AGill Wilfrid M COMMUTER IIA · S/N 066Cancelled Apr 8, 1991 · Triennial form not returned · Cleveland Bd EducationN7409QCessna 182P · S/N 18261049Cancelled Dec 10, 1990 · Triennial form not returned · Nasairs Flying ClubN14387Piper PA-23-250 · S/N 277304982Cancelled Jun 19, 1989 · Triennial form not returned · Bills Auto Sales Inc
Back to Cleveland, OH