OpenAirDocs.org
Cleveland, MS

Cancelled registrations · 33

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

N32145Rand Kar X-AIR · S/N 702Cancelled Jul 17, 2019 · Registration expired, pending cancellation · Reynolds DonnieN6659HPiper J3C-65 · S/N 19869Cancelled Sep 26, 2013 · Revoked, canceled · Built 1946 · Barney DonN9118RCessna A188B · S/N 18802124TCancelled May 22, 2013 · Registration expired, pending cancellation · Built 1975 · Simmons Charles K DBAN9305UCessna 150M · S/N 15078255Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1976 · Ace Flying ClubN6321ECessna 172 · S/N 46421Cancelled Apr 18, 2013 · Revoked, pending cancellation · Built 1958 · Cook Auto SalesN2211APiper PA-22-135 · S/N 22-617Cancelled Aug 10, 2012 · Sale reported, canceled · Built 1952N5223GCessna 305A · S/N 22606Cancelled Feb 12, 2010 · Exported to Mexico · Built 1951 · Bird Dog Aviation CorporationN6220PWsk-Pzl-Mielec PZL-M-18 · S/N 1Z023-02Cancelled May 29, 2007 · Exported to Argentina · Built 1993 · Air Repair IncN28NWAmerican Champion 8KCAB · S/N 811-98Cancelled Feb 27, 2007 · Exported to Canada · Built 1998 · Wheeler Farms IncN3106HAyres S2R-T15 · S/N T27-031Cancelled Oct 14, 2004 · Exported to South Africa · Built 1992 · Air Repair IncN2249LAyres S2R-T34 · S/N T34224Cancelled Dec 7, 1998 · Exported to Costa Rica · Air Repair IncN21424Ayres S2R-T34 · S/N T34254Cancelled Sep 9, 1998 · Exported to Brazil · Air Repair IncN20GHAyres S2R-G5 · S/N G5105Cancelled Jul 28, 1998 · Triennial form not returned · Holloway Air Service IncN46878Boeing A75N1(PT17) · S/N 75-528Cancelled Mar 6, 1998 · Exported to Australia · Air Repair IncN57944Boeing A75N1 · S/N 75-1714Cancelled May 22, 1997 · Exported to Brazil · Air Repair IncN9327RCessna A188B · S/N 18802238TCancelled Dec 16, 1991 · Holloway Air Service IncN9123RCessna A188B · S/N 18802125TCancelled Mar 14, 1991 · Triennial form not returned · Farmers Aero Service IncN7397Grumman G-164A · S/N 944Cancelled Sep 26, 1985 · Meeks Ray JrN7162FCessna 150F · S/N 15063762Cancelled Dec 24, 1981 · Bowman J RN82685Aeronca 7AC · S/N 7AC-1327Cancelled Feb 16, 1978 · Built 1946 · Hutchinson Robert C/Burney Glenn EN4407YPiper PA-25-235 · S/N 25-4016Cancelled Oct 3, 1975 · Exported to Canada · Built 1966 · Reditt W L DBA Reditt Flying ServiceN6538ZPiper PA-25-235 · S/N 25-2077Cancelled May 2, 1975 · Exported to Canada · Lyon Kell S JrN468YGrumman G-164A · S/N 114Cancelled Nov 22, 1974 · Meeks Thomas R JrN66005Boeing A75N1 · S/N 75-3219Cancelled Jun 26, 1973 · Walker ZerdieN29049Piper J3C-65 · S/N 6020Cancelled Aug 18, 1971 · Clinton W HollingsworthN9258ACessna 170B · S/N 19019Cancelled Feb 24, 1971 · Thomas W MN3881ZPiper PA-18-150 · S/N 187695Cancelled Oct 22, 1965 · Isaacks Woodrow Wesley JrN64933Consolidated Vultee SNV-1 · S/N 10212Cancelled Jun 5, 1965 · Thomas R MeeksN8072DPiper PA-18A 150 · S/N 18-6055Cancelled May 22, 1965 · Cleveland Flying Service IncN61884Boeing A75N1 · S/N 75-4547Cancelled Feb 27, 1956 · Elliott Clara SN3700CBoeing A75N1 · S/N 75-2004Cancelled Sep 7, 1955 · Elliott Clara SN5249CBeech B35 · S/N D-2641Cancelled Jun 10, 1954 · Dockery J RN8718Curtiss Wright TRAVEL AIR 4000 · S/N 1002Cancelled Jun 1, 1948 · Built 1929 · Elliott Henry Edgar
Back to Cleveland, MS