OpenAirDocs.org
Swanton, OH

Cancelled registrations · 43

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

N6577SBeech 58 · S/N TH-712Cancelled Sep 16, 2023 · Sale reported, canceledN6279SCasler Scott Edward TEAM V-MAX · S/N 1Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1996 · Lemle Eugene WN4958Lemle HEADWIND · S/N JDHW15Cancelled Apr 24, 2018 · Registration expired, pending cancellation · Built 1973 · Lemle Eugene WN995AMCochran Sam E SACO VI · S/N 001Cancelled Dec 27, 2017 · First renewal notice · Cochran Sam EN220AABeech B100 · S/N BE-5Cancelled Nov 9, 2016 · First renewal notice · National Flight Services IncN730CPNorth American NA-265-40 · S/N 282-103Cancelled Oct 21, 2013 · Registration expired, pending cancellation · Built 1972 · Sabre Leasing Associates IncN715RNDickson Lyle C DICKSON SPECIAL · S/N 001Cancelled Feb 11, 2013 · Registration expired, pending cancellation · Dickson Lyle CN3115JCessna 150G · S/N 15065815Cancelled Sep 25, 2012 · Registration expired, pending cancellation · Built 1966 · Rogers Willard HN457GSwearingen SA-26AT · S/N T26-150Cancelled Aug 21, 2012 · Registration pending, canceled · Built 1969N171GAHamburger Flugzeugbau HFB 320 HANSA · S/N 1039Cancelled Oct 3, 2007 · Built 1969 · Tricoastal Air IncN106TFMesserschmitt-Bolkow-Blohm HANSA HFB 320 · S/N 1042Cancelled Feb 27, 2007 · Triennial form not returned · Built 1969 · Grand Aire Express IncN176GAHamburger Flugzeugbau HFB 320 HANSA · S/N 1053Cancelled Feb 27, 2007 · Built 1971 · Tricoastal Air IncN179GADassault/Sud FAN JET FALCON · S/N 100Cancelled Feb 27, 2007 · Triennial form not returned · Grand Aire Express IncN617GADassault/Sud FAN JET FALCON · S/N 88Cancelled Feb 27, 2007 · Triennial form not returned · Built 1967 · Grand Aire Express IncN602GAHamburger Flugzeugbau HFB 320 HANSA · S/N 1041Cancelled Jan 27, 2006 · Triennial form not returned · Grand Aire Express IncN344SCCochran Sam E SACO III · S/N 001Cancelled Aug 1, 2005 · Triennial form not returned · Built 1987 · Cochran Sam EN158GAPiper AEROSTAR 600 · S/N 6006087961195Cancelled Sep 12, 2002 · Triennial form not returned · Built 1979 · Grand Aire Express IncN19362Cessna 150L · S/N 15074364Cancelled Jan 21, 1982 · Administratively canceled · Christian Charles LN27243Piper PA-31-350 · S/N 31-7752119Cancelled Aug 14, 1978 · Exported to Canada · Crow IncN2498QPiper PA-28-140 · S/N 28-7725196Cancelled Jul 13, 1978 · Exported to Canada · Crow IncN2708RFairchild F-27A · S/N 39Cancelled Feb 15, 1978 · Exported to Chile · Built 1959N2710RFairchild F-27A · S/N 55Cancelled Feb 15, 1978 · Exported to Chile · Built 1959N5FPiper PA-34-200 · S/N 347350267Cancelled May 24, 1976 · Crow IncN4381XPiper PA-28-140 · S/N 287625025Cancelled Apr 8, 1976 · Exported to Canada · Built 1975 · Crow IncN4447XPiper PA-28R-200 · S/N 28R-7635045Cancelled Apr 8, 1976 · Exported to Canada · Built 1975 · Great Lakes Aero Distributors IncN144XAero Commander 520 · S/N 520-48Cancelled May 6, 1975 · Crow IncN4252RPiper PA-32S-300 · S/N 32S-40638Cancelled Jul 5, 1973 · Exported to New Zealand · Crow IncN1288TPiper PA-32-260 · S/N 32-7200035Cancelled Jun 5, 1973 · Built 1972 · Great Lakes Aero DistributorsN6317SCessna 150G · S/N 150-67117Cancelled May 15, 1973 · Exported to Canada · Toledo National Flight Services IncN8083YPiper PA-30 · S/N 30-1198Cancelled Feb 16, 1972 · Crow IncN8425PPiper PA-24-400 · S/N 26-14Cancelled Mar 1, 1971 · Crow IncN1890JPiper PA-28-140 · S/N 28-24335Cancelled Feb 26, 1971 · Built 1968 · Crow IncN3206TCessna 177 · S/N 17700506Cancelled Jan 27, 1971 · Professional Flight Club IncN1819JPiper PA-28-140 · S/N 28-24249Cancelled Jan 12, 1971 · Crow IncN5376LPiper PA-28-180 · S/N 28-4682Cancelled Jun 29, 1970 · Crow IncN6171XAero Commander 680-F · S/N 680F-958-22Cancelled Jul 8, 1969 · Exported to Chile · Crow IncN7680YPiper PA-30 · S/N 30-758Cancelled Oct 23, 1968 · Exported to Canada · Crow IncN7466RPiper PA-28-140 · S/N 28-22014Cancelled Jul 9, 1968 · Crow IncN24700Aero Commander 680 · S/N 680-288-3Cancelled May 25, 1965 · Exported to Chile · W R Crow IncN5494PPiper PA-24-250 · S/N 24-555Cancelled May 21, 1965 · Walter R Crow IncN9609DPiper PA-22-160 · S/N 22-6519Cancelled May 21, 1965 · Crow W R IncN5460ZPiper PA-22-108 · S/N 22-9238Cancelled May 20, 1965 · Crow IncN6000KRepublic RC-3 · S/N 169Cancelled Feb 14, 1956 · Pilliod Cabinet Co
Back to Swanton, OH