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.

N238CSAmerican AA-1 · S/N AA1-0150Cancelled Feb 12, 1985 · Administratively canceled · Cleveland Board Of EducationN7786FCessna 150F · S/N 15063886Cancelled Jan 31, 1985 · Cleveland Board Of EducationN5836Convair 340-31 · S/N 169Cancelled Nov 29, 1984 · Exported to Canada · Freedom Airlines IncN5811Convair 440 · S/N 459Cancelled Oct 18, 1984 · Exported to Canada · Freedom Airlines IncN5835Convair 440 · S/N 465Cancelled Oct 18, 1984 · Exported to Canada · Freedom Airlines IncN5813Convair 340 · S/N 130Cancelled Oct 17, 1984 · Exported to Canada · Freedom Airlines IncN5837Convair 340 · S/N 127Cancelled Oct 17, 1984 · Exported to Canada · Freedom Airlines IncN450FHFairchild Hiller FH-1100 · S/N 215Cancelled Feb 21, 1984 · Built 1970 · Ernst & WhinneyN8776GCessna 404 · S/N 404-0087Cancelled Apr 4, 1983 · Administratively canceled · Air PakN26ANPiper PA-31-310 · S/N 31-57Cancelled May 4, 1982 · Built 1967 · Weitzman Sheldon PN101HPBeech J35 · S/N D-5349Cancelled Apr 14, 1982 · Administratively canceled · Bonanza Of Cleveland IncN873QMitsubishi MU-2B-20 · S/N 160Cancelled Apr 5, 1982 · Revoked, pending cancellation · Built 1969 · Ancorp Leasing DivisionN704PRCessna 150M · S/N 15078770Cancelled Jan 4, 1982 · T J Air Service IncN2281SCessna TR182 · S/N R18201321Cancelled Dec 31, 1981 · Exported to Canada · Built 1979 · Mercury Aviation CompaniesN206JBoeing B75 · S/N 751405Cancelled Dec 21, 1981 · Built 1941 · Chandelle AeroN37326Cessna 340A · S/N 340A0350Cancelled Nov 12, 1981 · Exported to Canada · Mercury Aviation CoN9337TCessna 180C · S/N 50837Cancelled Oct 16, 1981 · Baptist Mid MissionsN5793WPiper PA-28-160 · S/N 28-1753Cancelled Oct 15, 1981 · Capt Crunch Flying Club IncN86688Hiller UH-12L4 · S/N 2547Cancelled Oct 15, 1981 · Zahuranec William JN5272VCessna 210L · S/N 21060888Cancelled Jul 27, 1981 · Exported to Canada · Mercury Aviation CoN430YGreat Lakes 2T-1A · S/N 147Cancelled Apr 16, 1981 · Great Lakes Aircraft CorpN714TMCessna 152 · S/N 15279420Cancelled Feb 9, 1981 · Exported to Canada · Mercury Aviation CompaniesN74851Convair 600-240D · S/N 118Cancelled Nov 22, 1980 · Garsco IncN576GAGrumman American Avn. AA-5 · S/N AA5-0001Cancelled Jul 31, 1980 · American Aviation CorpN777GAGrumman American Avn. GA-7 · S/N GA7P-0001Cancelled Jul 31, 1980 · Grumman American Aviation CorpN1260LLake LA-4-200 · S/N 758Cancelled May 12, 1980 · Exported to Brazil · Built 1976 · Baptist Mid MissionsN15RPBeech 58 · S/N TH-872Cancelled May 5, 1980 · Exported to Canada · Built 1977 · Spisak Frank DBAN7RSShook BOOMERANG · S/N N7A76Cancelled May 5, 1980 · Shook RobertN2972QCessna 421A · S/N 421A0072Cancelled Mar 25, 1980 · Exported to Canada · Built 1969 · Mercury Aviation CoN6981NCessna T210N · S/N 21063190Cancelled Dec 28, 1979 · Exported to Mexico · Mercury Aviation CompaniesN637NAGrumman OV-1B · S/N 64-14244Cancelled Feb 27, 1979 · National Aeronautics & Space Admin Mail Stop 4-8N46934Grumman G-164A · S/N 1240Cancelled May 13, 1977 · Grumman American Aviation CorpN5NAConvair VT-29B · S/N 51-7909ACancelled Feb 7, 1977 · Nasa Lewis Research CenterN9934LGrumman American Avn. AA-1B · S/N AA1B-0234Cancelled Feb 1, 1977 · Plencner Robert MN200WPBeech 99 · S/N U-3Cancelled Nov 22, 1976 · Built 1968 · Palmer William P IIIN12PBSmith AEROSTAR 600 · S/N 60-0023Cancelled May 13, 1976 · Aero Leasing Inc No 34N1449RGrumman American Avn. AA-1B · S/N AA1B-0549Cancelled Jul 29, 1975 · Exported to Canada · Grumman American Aviation CorpN38SCessna T337G · S/N P337-0149Cancelled Jul 15, 1975 · Built 1974 · Mercury Aviation CoN38387Piper J3F-65 · S/N 6998Cancelled Jun 2, 1975 · Arlo Wayne MatherN6583SCessna 150H · S/N 15067383Cancelled May 9, 1975 · Hughes John SN5178SPiper PA-28-180 · S/N 287105032Cancelled May 8, 1975 · Butterfield RayN617NAConvair F102A · S/N 56-0998Cancelled May 8, 1975 · Nasa Lewis Research CenterN3079QCessna 182K · S/N 18258079Cancelled Jan 14, 1975 · Exported to Canada · Built 1967 · Seidowski Albert G/Kowalski John R/Minch Lj/RevertN6534LGrumman American Avn. AA-5 · S/N AA5-0634Cancelled Oct 9, 1974 · Exported to Canada · Grumman American Aviation CorpN890MAmerican AA-1A · S/N P-1Cancelled Oct 3, 1974 · Bede Aviation CorpN8887LAmerican AA-5 · S/N AA5-0628Cancelled Sep 25, 1974 · Exported to Canada · Grumman American CorpN1402PPiper PA-23-150 · S/N 23-457Cancelled Sep 17, 1974 · Simpson David CarlN590ADanoiselle HB-1 · S/N 1Cancelled Sep 10, 1974 · Bede James RN5982LAmerican AA-1 · S/N AA1-0282Cancelled Apr 24, 1974 · Bede Aircraft IncN7RSShook TEENIE TWO · S/N 5-1153Cancelled Apr 24, 1974 · Shook Robert L Jr
Back to Cleveland, OH