Wichita, KS

Cancelled registrations · 11,581

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

N173KBTextron B300 · S/N FL-1173Cancelled Mar 12, 2020 · Exported to Philippines · Built 2019 · Chopper Dynamix IncN63GRTextron 172S · S/N 172S12365Cancelled Mar 4, 2020 · Exported to China · Built 2019 · Textron Aviation IncN8631TTextron 172S · S/N 172S12361Cancelled Mar 4, 2020 · Exported to China · Built 2019 · Textron Aviation IncN8633TTextron 172S · S/N 172S12362Cancelled Mar 4, 2020 · Exported to China · Built 2019 · Textron Aviation IncN8635TTextron 172S · S/N 172S12363Cancelled Mar 4, 2020 · Exported to China · Built 2019 · Textron Aviation IncN8636TTextron 172S · S/N 172S12366Cancelled Mar 4, 2020 · Exported to China · Built 2019 · Textron Aviation IncN8638TTextron 172S · S/N 172S12364Cancelled Mar 4, 2020 · Exported to China · Built 2019 · Textron Aviation IncN8639TTextron 172S · S/N 172S12367Cancelled Mar 4, 2020 · Exported to China · Built 2019 · Textron Aviation IncN864ATTextron 172S · S/N 172S12368Cancelled Mar 4, 2020 · Exported to China · Built 2019 · Textron Aviation IncN864BTTextron 172S · S/N 172S12369Cancelled Mar 4, 2020 · Exported to China · Built 2019 · Textron Aviation IncN869QTTextron 680A · S/N 680A0210Cancelled Feb 27, 2020 · Exported to Norway · Built 2019 · Textron Aviation IncN144UVHawker Beechcraft HAWKER 900XP · S/N HA-0177Cancelled Feb 24, 2020 · Exported to India · Built 2010 · Rangeflyers IncN584EXTextron 208B · S/N 208B5589Cancelled Feb 10, 2020 · Textron Aviation IncN215KQQuest KODIAK 100 · S/N 100-0215Cancelled Feb 4, 2020 · Exported to Norway · Built 2017 · Specialized Aircraft Services IncN53894Fairchild M-62A · S/N T423824Cancelled Jan 24, 2020 · Revoked, canceled · Built 1943 · Meil Gene AN864HTTextron 208B · S/N 208B5521Cancelled Jan 21, 2020 · Exported to Kenya · Built 2019 · Textron Financial CorpN73358Consolidated Vultee BT-13A · S/N 6296Cancelled Jan 9, 2020 · Revoked, pending cancellation · Built 1942 · University Airport IncN5045NConsolidated Vultee BT-13 · S/N 6680Cancelled Jan 3, 2020 · Revoked, canceled · Built 1942 · Viggiano S JrN50492Boeing A75N1(PT17) · S/N 754453Cancelled Jan 3, 2020 · Revoked, canceled · Built 1943 · U Airport IncN365BYTextron B200GT · S/N BY-365Cancelled Dec 20, 2019 · Exported to Brazil · Textron Aviation IncN504EXTextron 208B · S/N 208B5504Cancelled Dec 20, 2019 · Exported to Slovenia · Built 2019 · Textron Aviation IncN175KGTextron B300 · S/N FL-1175Cancelled Dec 17, 2019 · Exported to Philippines · Built 2019 · Rangeflyers IncN466TWTextron 208B · S/N 208B5566Cancelled Dec 12, 2019 · Exported to Brazil · Built 2019 · Textron Aviation IncN799VPDJI PHANTOM 2 · S/N 0400208058Cancelled Dec 12, 2019 · Second renewal notice · Paragon Geophysical Services IncN145DJTextron T206H · S/N T20609560Cancelled Dec 9, 2019 · Exported to Argentina · Built 2019 · Textron Aviation IncN30386Piper J3F-60 · S/N 4826Cancelled Dec 9, 2019 · Revoked, canceled · Built 1940 · Rickard Max EN50640Taylorcraft DC-65 · S/N 4753Cancelled Dec 5, 2019 · Revoked, pending cancellation · Built 1943 · Mccollum ShelbyN662TXCessna 560XL · S/N 560-5262Cancelled Dec 4, 2019 · Exported to Argentina · Built 2002 · Textron Aviation IncN197MPTextron B300 · S/N FL-1197Cancelled Dec 3, 2019 · Exported to Australia · Built 2019 · Rangeflyers IncN363BYTextron B200GT · S/N BY-363Cancelled Nov 25, 2019 · Exported to Germany · Textron Aviation IncN952GRTextron 182T · S/N 18283064Cancelled Nov 21, 2019 · Exported to Germany · Built 2019 · Textron Aviation IncN1200BTextron B300 · S/N FL-1200Cancelled Nov 20, 2019 · Exported to Brazil · Built 2019 · Textron Aviation IncN15RNTextron 208B · S/N 208B5557Cancelled Nov 12, 2019 · Exported to Botswana · Built 2019 · Chopper Dynamix IncN26KRTextron G58 · S/N TH-2528Cancelled Nov 7, 2019 · Exported to Japan · Rangeflyers IncN742JSCessna 525A · S/N 525A0241Cancelled Nov 4, 2019 · Exported to Dominican Republic · Built 2005 · Textron Aviation IncN1075GZS Delta-Bielsko Wroclaw SZD-36 A COBRA 15 · S/N W-691Cancelled Nov 1, 2019 · Sale reported, canceled · Built 1974N663TXCessna 560XL · S/N 560-5263Cancelled Oct 17, 2019 · Exported to Chile · Built 2002 · Textron Aviation IncN15174Stinson SR-7B · S/N 9655Cancelled Oct 11, 2019 · Revoked, canceled · Built 1936 · Ancel Orval JN874WTTextron 172S · S/N 172S12376Cancelled Oct 4, 2019 · Exported to France · Textron Aviation IncN874YTTextron 172S · S/N 172S12377Cancelled Oct 4, 2019 · Exported to France · Textron Aviation IncN247TACessna 680 · S/N 6800131Cancelled Oct 2, 2019 · Exported to Dominican Republic · Built 2007 · Textron Aviation IncN2048RTextron 208B · S/N 208B5556Cancelled Sep 27, 2019 · Exported to Germany · Textron Aviation IncN43470Taylorcraft BF · S/N 7129Cancelled Sep 27, 2019 · Revoked, canceled · Built 1946 · Oconnor John VN874UTTextron 172S · S/N 172S12360Cancelled Sep 27, 2019 · Exported to France · Textron Aviation IncN874RTTextron 172S · S/N 172S12359Cancelled Sep 25, 2019 · Exported to France · Textron Aviation IncN30KATextron B300 · S/N FL-1183Cancelled Sep 24, 2019 · Exported to Brazil · Textron Aviation IncN874TTTextron 172S · S/N 172S12358Cancelled Sep 24, 2019 · Exported to France · Textron Aviation IncN351BYTextron B200GT · S/N BY-351Cancelled Sep 20, 2019 · Exported to Denmark · Built 2019 · Textron Aviation IncN1193GTextron B300 · S/N FL-1193Cancelled Sep 18, 2019 · Exported to China · Built 2019 · Textron Aviation IncN356CSTextron B200GT · S/N BY-356Cancelled Sep 16, 2019 · Exported to India · Built 2019 · Rangeflyers Inc
Back to Wichita, KS