OpenAirDocs.org
Topeka, KS

Cancelled registrations · 165

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

N121FCBell UH-1H · S/N 64-13697Cancelled May 27, 2025 · Sale reported, canceledN390VAEmbraer-Empresa Brasileira De EMB-500 · S/N 50000114Cancelled Oct 17, 2024 · Exported to Mexico · Built 2009 · Three Ninety LLCN16557Aeronca C-3 · S/N A-696Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 1936 · Miller Warren EN5213PPiper PA-24 · S/N 24-238Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1958 · Rudolph Eugene DN789CFBritish BAC 1-11 422/EQ · S/N 119Cancelled Nov 5, 2022 · Registration expired, pending cancellation · American Flight MuseumN6163TPowrachute PEGASUS 912 · S/N A028ULSCancelled Jan 8, 2022 · Registration expired, pending cancellation · Built 2005 · Boyda Stephen WN83847Aeronca 7AC · S/N 7AC-2528Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1946 · Lacore David LN45337Cameron Balloons US N-105 · S/N 5879Cancelled Apr 3, 2021 · Registration expired, pending cancellation · Harrison Darrin CN885FWDJI PHANTOM 4 PRO+ · S/N OAX3G9K002W558Cancelled Mar 30, 2021 · Woelfel Jack LN417HWNorth Wing Uum SCOUT X-C · S/N LS9006Cancelled Dec 5, 2020 · Registration expired, pending cancellation · Built 2010 · Winkenwader John FN3093JCessna 150E · S/N 15061193Cancelled Jun 12, 2020 · Revoked, canceled · Built 1965 · Beeson Avn IncN25450Balloon Works FIREFLY 7-15 · S/N F7-774Cancelled Jan 3, 2020 · Registration expired, pending cancellation · Built 1992 · Suther Patrick MN634YT3D Robotics IRIS+ · S/N IRS1428100070Cancelled May 6, 2019 · Registration expired, pending cancellation · Technical Applications & ConsultingN3513XGolden Circle Air T-BIRD I · S/N 2003Cancelled Feb 23, 2019 · Registration expired, pending cancellation · Built 2007 · Briman Robert MN8101FCessna 150F · S/N 15064201Cancelled Feb 9, 2019 · Revoked, canceled · Built 1966 · Alexander George WN149JBDe Almeida R/Bonimcontro M SS-33-SB · S/N 200065Cancelled Jan 30, 2019 · Registration expired, pending cancellation · Built 2001 · Wildtiger Aerosports LLCN618ERRiggs Kenneth W T-BIRD II · S/N 90062000Cancelled Dec 19, 2018 · Registration pending, canceledN1353KLuscombe 8A · S/N 4080Cancelled Jul 19, 2018 · Revoked, canceled · Built 1946 · Leach Harold LynnN7524CCameron Balloons US V-77 · S/N 5765Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 1992 · Rose Jeromie GN8827UCessna 172F · S/N 17252736Cancelled Mar 23, 2018 · Revoked, canceled · Beeson Avn IncN3871QCessna 172L · S/N 17259971Cancelled Mar 16, 2018 · Revoked, canceled · Built 1971 · Aero America Of Topeka IncN5104EJakel Helmet Leo CH-701 · S/N 7-1591Cancelled Feb 14, 2018 · Registration expired, pending cancellation · Built 1993 · Johnson Melvin LeeN3008TCameron Balloons US N-105 · S/N 6042Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Built 1996 · Wildtiger Aerosports LLCN7281WPiper PA-28-180 · S/N 28-1120Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1963 · Thoroughbred Computer Systems IncN56954Sabrena T-BIRD I · S/N 072407Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 2007 · Aards American Business IncN56956Sabrena T-BIRD IW · S/N 072405Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 2007 · Aards American Business IncN7744CSabrena T-BIRD IL · S/N 072404Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 2007 · Aards American Business IncN1364YCessna 172C · S/N 17249064Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1961 · Baker (Wm) GaryN5071VVarga 2150A · S/N VAC-60-76Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Built 1976 · Collier Max EN2613HSchweizer SGS 2-33A · S/N 448Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1976 · Collier Max EN421NTCessna 421C · S/N 421C1098Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Newtek Enterprise IncN911KUEurocopter AS 350 B2 · S/N 2741Cancelled Jun 17, 2016 · Exported to Canada · Built 1993 · Topeka Air Ambulance IncN46542Johnson Douglas SONERAI II · S/N 10042Cancelled Oct 6, 2015 · Built 2005 · Johnson Douglas LN27400Bell OH-58C · S/N 72-21235Cancelled May 15, 2015 · Registration expired, pending cancellation · Kansas Highway PatrolN407HFPiper PA-23-250 · S/N 27-2893Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1965 · Brecheisen David WN69400Bell OH-58C · S/N 69-16264Cancelled May 15, 2015 · Registration expired, pending cancellation · Kansas Highway PatrolN707MLPiper PA-31T · S/N 31T-7520017Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1975 · Chaparral Leasing IncN7054PPiper PA-24-250 · S/N 24-2204Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1960 · White Wayne CN34188Schweizer SGS 2-33A · S/N 419Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1976 · Collier Max EN310MCessna 310H · S/N 310H0054Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1963 · Hittle Wayne LN299TWLearjet 24D · S/N 299Cancelled Sep 22, 2014 · Registration expired, pending cancellation · Built 1974 · Chaparral Leasing IncN8970KStinson 108-1 · S/N 108-1970Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1947 · Carolan Jack WN303WCDouglas A-26C · S/N 29192Cancelled Aug 8, 2013 · Registration expired, pending cancellation · Built 1959 · Counselman Guy EdwardN2327GPiper PA-38-112 · S/N 38-79A0499Cancelled Aug 7, 2013 · Registration expired, pending cancellation · Built 1979 · Hoover DavidN337BPCessna 337A · S/N 337-0349Cancelled Aug 7, 2013 · Sale reported, canceled · Built 1966N64123Thiele OZ BALLOON AX-5 · S/N 001Cancelled Aug 6, 2013 · Revoked, canceled · Built 1975 · Thiele James RN56952Sabrena TIERRA CI · S/N 072408Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 2007 · Aards American Business IncN56955Sabrena T-BIRD I · S/N 072406Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 2007 · Aards American Business IncN9694KStinson 108-2 · S/N 108-2694Cancelled Jun 14, 2013 · Sale reported, canceled · Built 1947N74111Balloon Works FIREFLY 7 · S/N F7-273Cancelled Jun 13, 2013 · Sale reported, canceled
Back to Topeka, KS