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.

N619EXTextron 208B · S/N 208B5619Cancelled Nov 28, 2022 · Exported to Argentina · Built 2021 · Textron Aviation IncN107BETextron B300C · S/N FM-107Cancelled Nov 22, 2022 · Exported to Australia · Textron Aviation IncN650BABombardier BD-700-1A10 · S/N 60055Cancelled Nov 22, 2022 · Exported to Canada · Built 2022 · Global Flight IncN261CSTextron 182T · S/N 18283161Cancelled Nov 21, 2022 · Exported to Argentina · Built 2022 · Textron Aviation IncN918QSTextron 680A · S/N 680A0343Cancelled Nov 15, 2022 · Textron Aviation IncN937HTTextron 208B · S/N 208B5706Cancelled Nov 15, 2022 · Exported to Indonesia · Textron Aviation IncN937JTTextron 208B · S/N 208B5707Cancelled Nov 15, 2022 · Exported to Indonesia · Textron Aviation IncN786BFTextron 680A · S/N 680A0325Cancelled Nov 14, 2022 · Exported to Pakistan · Textron Aviation IncN1KQTextron 525C · S/N 525C0269Cancelled Nov 8, 2022 · Exported to Norway · Built 2018 · Rangeflyers Inc TrusteeN750GXBombardier BD-700-2A12 · S/N 70068Cancelled Oct 18, 2022 · Exported to Portugal · Built 2020 · Global Flight IncN936RTTextron 172S · S/N 172S12854Cancelled Oct 6, 2022 · Exported to China · Built 2022 · Textron Aviation IncN936TTTextron 172S · S/N 172S12856Cancelled Oct 6, 2022 · Exported to China · Built 2022 · Textron Aviation IncN3004RTextron 208B · S/N 208B5699Cancelled Sep 30, 2022 · Exported to Germany · Textron Aviation IncN106RSTextron B300C · S/N FM-106Cancelled Sep 23, 2022 · Exported to Australia · Textron Aviation IncN388BYTextron B200GT · S/N BY-388Cancelled Sep 22, 2022 · Exported to Panama · Built 2021 · Textron Aviation IncN505BZTextron B200CGT · S/N BZ-5Cancelled Sep 7, 2022 · Exported to Australia · Textron Aviation IncN335JPDJI INSPIRE 1 · S/N W13DCD16030152Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Pfeiffer Jay NN606BZTextron B200CGT · S/N BZ-6Cancelled Aug 25, 2022 · Exported to Australia · Textron Aviation IncN881DPTextron 208B · S/N 208B5688Cancelled Aug 16, 2022 · Exported to Brazil · Textron Aviation IncN3006GTextron T206H · S/N T20609680Cancelled Aug 12, 2022 · Exported to Georgia · Built 2022 · Rangeflyers IncN671SRTextron 208B · S/N 208B5627Cancelled Aug 12, 2022 · Exported to Mexico · Built 2021 · Textron Aviation IncN30039Textron T206H · S/N T20609694Cancelled Aug 11, 2022 · Exported to Mexico · Textron Aviation IncN378CJCessna 525A · S/N 525A0378Cancelled Aug 8, 2022 · Exported to India · Rangeflyers Inc TrusteeN3045XCessna 150F · S/N 15064445Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1966 · Mile High Club LcN40LXLearjet 45 · S/N 001Cancelled Jul 26, 2022 · Built 1995 · Learjet IncN425PLCessna 425 · S/N 425-0010Cancelled Jul 19, 2022 · Exported to Canada · Built 1980 · Wolfe Electric IncN3003VTextron 182T · S/N 18283182Cancelled Jul 13, 2022 · Exported to Canada · Textron Aviation IncN826EWDassault FALCON 2000 · S/N 58Cancelled Jul 11, 2022 · Exported to South Africa · Built 1998 · Specialized Aircraft Services IncN848AFTextron 172S · S/N 172S12848Cancelled Jul 8, 2022 · Exported to Colombia · Textron Aviation IncN850AFTextron 172S · S/N 172S12850Cancelled Jul 8, 2022 · Exported to Colombia · Textron Aviation IncN843AFTextron 172S · S/N 172S12843Cancelled Jul 7, 2022 · Exported to Colombia · Textron Aviation IncN846AFTextron 172S · S/N 172S12846Cancelled Jul 7, 2022 · Exported to Colombia · Textron Aviation IncN20GETextron 208B · S/N 208B5687Cancelled Jun 30, 2022 · Exported to Brazil · Textron Aviation IncN607SETextron 208B · S/N 208B5686Cancelled Jun 29, 2022 · Exported to Brazil · Textron Aviation IncN1287YTextron B300 · S/N FL-1287Cancelled Jun 28, 2022 · Exported to Germany · Rangeflyers IncN931ZTTextron 172S · S/N 172S12820Cancelled Jun 28, 2022 · Exported to China · Built 2022 · Textron Aviation IncN932AATextron 172S · S/N 172S12814Cancelled Jun 28, 2022 · Exported to China · Built 2022 · Textron Aviation IncN932GBTextron 172S · S/N 172S12819Cancelled Jun 28, 2022 · Exported to China · Built 2022 · Textron Aviation IncN630LATextron 3000 (AT-6C) · S/N AT-3Cancelled Jun 27, 2022 · Built 2013 · Textron Aviation IncN30025Textron 208B · S/N 208B5678Cancelled Jun 21, 2022 · Exported to Tanzania · Textron Financial CorpN99KCTextron B300 · S/N FL-1204Cancelled Jun 21, 2022 · Exported to Pakistan · Built 2019 · Rangeflyers IncN700AFTextron 700 · S/N 700-0024Cancelled Jun 15, 2022 · Exported to Japan · Built 2020 · Textron Aviation IncN75TETextron 182T · S/N 18283175Cancelled Jun 9, 2022 · Exported to Mexico · Textron Aviation IncN400MRHawker Beechcraft 4000 · S/N RC-12Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Built 2009 · Murfin IncN921NTTextron 172S · S/N 172S12791Cancelled May 19, 2022 · Exported to China · Built 2022 · Textron Aviation IncN682GPTextron 172S · S/N 172S12785Cancelled May 18, 2022 · Exported to China · Built 2022 · Textron Aviation IncN921HTTextron 172S · S/N 172S12784Cancelled May 18, 2022 · Exported to China · Built 2022 · Textron Aviation IncN676MBTextron 208B · S/N 208B5676Cancelled May 17, 2022 · Exported to Argentina · Textron Aviation IncN975WPTextron B300 · S/N FL-1219Cancelled May 10, 2022 · Exported to Pakistan · Built 2020 · Rangeflyers IncN1292VTextron 208B · S/N 208B5663Cancelled Apr 7, 2022 · Exported to Mongolia · Textron Financial Corp
Back to Wichita, KS