OpenAirDocs.org
Newton, KS

Cancelled registrations · 96

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 = 'KS' AND d.registrant_city = 'NEWTON'
  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.

N559ALRaytheon B300 · S/N FL-322Cancelled May 14, 2026 · Exported to Canada · Built 2001 · Ballard Aviation IncN399BWBeech B200 · S/N BB-1059Cancelled Feb 1, 2024 · Exported to Panama · Built 1982 · Ballard Aviation IncN731FGCessna P210N · S/N P21000451Cancelled Dec 31, 2023 · Built 1979 · Mike Papa LLCN900RHRaytheon B300 · S/N FL-379Cancelled Jun 13, 2023 · Exported to Canada · Ballard Aviation IncN2037EWeatherly 620B · S/N 1598Cancelled Dec 9, 2021 · Sale reported, canceled · Built 1995N5055QWiebe Donald A MA-2 · S/N 01Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 2007 · Wiebe Donald AN409LVRaytheon B300 · S/N FL-409Cancelled Dec 15, 2020 · Exported to Canada · Ballard Aviation IncN129JMBell Helicopter Textron Canada 429 · S/N 57027Cancelled Oct 13, 2020 · Exported to Australia · Built 2010 · Ballard Aviation IncN743GWDonald A Wiebe F450 · S/N 01Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Wiebe Donald AN941BWSikorsky S-58T · S/N CH58-738Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Ballard Aviation IncN920EMEurocopter France AS350B2 · S/N 1376Cancelled Sep 22, 2017 · Exported to New Zealand · Built 1980 · Ballard Aviation IncN699ALRaytheon B200 · S/N BB-1607Cancelled May 10, 2016 · Exported to Spain · Ballard Aviation IncN2464JCessna 150G · S/N 15065564Cancelled Sep 22, 2014 · Registration expired, pending cancellation · Built 1966 · Regier John FN7BDBede BD-7 · S/N 7-0001Cancelled Sep 3, 2014 · Revoked, canceled · Built 1976 · Bede Aircraft IncN392TWBeech B90 · S/N LJ-392Cancelled May 23, 2014 · Third renewal notice · Built 1968 · Chaparral IncN7874YPiper PA-30 · S/N 30-958Cancelled Aug 13, 2013 · Sale reported, canceled · Built 1965N26019Mitchell BD-5B · S/N 3038Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Newton City/County AirportN7AQHerbert John W QUESTAIR VENTURE · S/N 59Cancelled Mar 26, 2013 · Sale reported, canceledN512GBeech 65-90 · S/N LJ-64Cancelled Mar 25, 2013 · Registration expired, pending cancellation · Built 1965 · American Aircraft IncN8685YPiper PA-30 · S/N 30-1830Cancelled Mar 7, 2013 · Sale reported, canceled · Built 1969N155BDBede BD-5J · S/N 5-0007Cancelled Aug 8, 2012 · Registration expired, pending cancellation · Built 1975 · Bede Aircraft IncN928BWRaytheon B200 · S/N BB-1590Cancelled Feb 7, 2012 · Exported to Canada · Built 1997 · Ballard Aviation IncN828KWDassault-Breguet FALCON 10 · S/N 52Cancelled Aug 5, 2011 · First renewal notice · Built 1975 · Palomino Petroleum IncN4491NCessna U206G · S/N U20604979Cancelled Apr 26, 2011 · Exported to Canada · Voth Farms IncN93996Ercoupe 415-C · S/N 1319Cancelled Sep 18, 2009 · Registration revoked · Built 1946 · Davis Thelma MN154BDBede BD-5J · S/N 5-0006Cancelled Jun 30, 2009 · Registration revoked · Built 1975 · Bede Aircraft IncN15CFOlson CORVAIR-A-FLT. TBP · S/N REO-2Cancelled Jun 30, 2009 · Registration revoked · Built 1975 · Olson Richard EN1220QCessna 150L · S/N 15072520Cancelled Apr 23, 2009 · Second triennial form not returned · Built 1971 · Vermilyea PaulN62565Cessna 172P · S/N 17275302Cancelled Apr 11, 2008 · Exported to Australia · Built 1981 · Claassen Enterprises LLCN650GMCessna T210R · S/N 21064998Cancelled Apr 24, 2001 · Triennial form not returned · Ralph Lowry Aircraft Sales IncN121RLBeech C90A · S/N LJ1139Cancelled Mar 7, 2001 · Exported to Canada · Ralph Lowry Aircraft Sales IncN624BDBede BD-4 · S/N 1Cancelled Nov 30, 2000 · Registration revoked · Bede James RN82SRLockheed 1329 · S/N 5082Cancelled Jul 17, 1997 · Exported to Turkey · Executive Aircraft CorporationN25SRRockwell International NA-265-65 · S/N 46514Cancelled Aug 13, 1996 · Exported to Mexico · Executive Aircraft CorporationN30032Cessna 177 · S/N 17701035Cancelled May 25, 1993 · Triennial form not returned · Floyd Wild IncN775WMPiper PA-31-325 · S/N 317512033Cancelled Sep 4, 1992 · Exported to Canada · Ralph Lowry Aircraft Sales IncN123SAPiper PA-31-310 · S/N 31618Cancelled Jul 8, 1992 · Exported to Canada · Ralph Lowry Aircraft Sales IncN11GEBeech E-90 · S/N LW111Cancelled Oct 24, 1991 · Exported to Canada · Ralph Lowry Aircraft Sales IncN2BDBede BD-3 · S/N 3-0001Cancelled Aug 8, 1991 · Built 1976 · Bede Aircraft IncN18405Beech 58 · S/N TH859Cancelled Feb 5, 1991 · Exported to Botswana · Horst Aviation IncN7318LPiper PA-31P · S/N 31P-71Cancelled Nov 1, 1984 · Ralph Lowry Aircraft Sales IncN5BDBede BD-5J · S/N 5J0001Cancelled May 24, 1983 · Bede Aircraft IncN400BDBede BD-4 · S/N 05612AHCancelled Jul 2, 1980 · Built 1970 · Bede James RN503BDBede BD-5 · S/N 50004Cancelled Jan 24, 1977 · Bede Aircraft IncN4393WBeech 58 · S/N TH-492Cancelled Jul 17, 1974 · Exported to Australia · Built 1974 · World Air LimitedN3269ZPiper PA-22-160 · S/N 22-7220Cancelled Nov 15, 1972 · Edgerton Robert C Gale ButcherN5226BMooney M20 · S/N 1089Cancelled Jan 27, 1971 · Built 1957 · Wiebe Gustav FN6874QBeech A-80 · S/N LD-172Cancelled Oct 14, 1970 · Exported to Australia · Floair IncN4992TCessna 411 · S/N 411-0192Cancelled Dec 28, 1966 · Exported to South Africa · Floair IncN5419SCessna 337A · S/N 337-0519Cancelled Oct 21, 1966 · Exported to Australia · Floair Inc
Back to Newton, KS