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.

N199CKTextron 680A · S/N 680A0248Cancelled Dec 1, 2020 · Exported to Libya · Built 2020 · Textron Aviation IncN88FMTextron B300C · S/N FM-88Cancelled Nov 24, 2020 · Exported to Australia · Textron Aviation IncN17246Textron 172S · S/N 172S12550Cancelled Nov 19, 2020 · Exported to China · Built 2020 · Textron Aviation IncN17248Textron 172S · S/N 172S12551Cancelled Nov 19, 2020 · Exported to China · Built 2020 · Textron Aviation IncN803TXTextron 172S · S/N 172S12546Cancelled Nov 19, 2020 · Exported to China · Built 2020 · Textron Aviation IncN8899TTextron 172S · S/N 172S12545Cancelled Nov 19, 2020 · Exported to China · Built 2020 · Textron Aviation IncN2063RTextron 182T · S/N 18283112Cancelled Nov 16, 2020 · Exported to Argentina · Textron Aviation IncN1189KTextron B300 · S/N FL-1189Cancelled Nov 13, 2020 · Exported to Japan · Built 2019 · Rangeflyers Inc TrusteeN83FMTextron B300C · S/N FM-83Cancelled Nov 13, 2020 · Exported to Japan · Built 2019 · Rangeflyers IncN2065DTextron T206H · S/N T20609613Cancelled Nov 3, 2020 · Exported to Ecuador · Textron Aviation IncN2066YTextron T206H · S/N T20609614Cancelled Nov 3, 2020 · Exported to Ecuador · Textron Aviation IncN887BTTextron 525 · S/N 525-1054Cancelled Oct 30, 2020 · Exported to China · Built 2020 · Textron Aviation IncN887CTTextron 525 · S/N 525-1056Cancelled Oct 30, 2020 · Exported to China · Built 2020 · Textron Aviation IncN335MPTextron 525C · S/N 525C0335Cancelled Oct 21, 2020 · Exported to Singapore · Textron Financial CorpN7646Schweizer SGS 1-34 · S/N 26Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Built 1970 · Wells John HN113CMooney M-18L · S/N 74Cancelled Sep 4, 2020 · Revoked, canceled · Built 1950 · Colwell E EN47141Aeronca 0-58B · S/N 058B11103Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Built 1943 · Mead Ronald CN373BYTextron B200GT · S/N BY-373Cancelled Aug 28, 2020 · Exported to India · Built 2020 · Textron Aviation IncN17255Textron 172S · S/N 172S12560Cancelled Aug 27, 2020 · Exported to Canada · Textron Aviation IncN17271Textron 172S · S/N 172S12561Cancelled Aug 27, 2020 · Exported to Canada · Textron Aviation IncN1225ATextron B300 · S/N FL-1225Cancelled Aug 21, 2020 · Exported to San Marino · Built 2020 · Textron Aviation IncN875CTTextron 208B · S/N 208B5540Cancelled Aug 17, 2020 · Exported to Philippines · Built 2019 · Textron Financial CorpN960TWTextron T206H · S/N T20609600Cancelled Jul 29, 2020 · Exported to Israel · Built 2020 · Textron Aviation IncN505AGCessna 550 · S/N 550-0905Cancelled Jul 10, 2020 · Sale reported, canceled · Built 1999N6630VBellanca 17-30A · S/N 30284Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Built 1970 · Newo Aviation LLCN2174LTextron C90GTI · S/N LJ-2174Cancelled Jul 1, 2020 · Exported to Brazil · Built 2020 · Textron Aviation IncN575FABeechcraft B300 · S/N FL-861Cancelled Jun 25, 2020 · Exported to Colombia · Built 2013 · Textron Aviation IncN986AQTextron 172S · S/N 172S12447Cancelled Jun 22, 2020 · Exported to China · Textron Aviation IncN154KQQuest KODIAK 100 · S/N 100-0154Cancelled Jun 18, 2020 · Registration expired, pending cancellation · Built 2015 · Mid-Continent Aviation Services IncN1181KTextron B300 · S/N FL-1181Cancelled Jun 15, 2020 · Exported to Australia · Built 2019 · Textron Aviation IncN27247Porterfield LP-65 · S/N 736Cancelled Jun 12, 2020 · Revoked, canceled · Built 1940 · Platter DelbertN533BETextron G58 · S/N TH-2533Cancelled Jun 4, 2020 · Exported to Philippines · Built 2020 · Rangeflyers Inc TrusteeN162CECessna 162 · S/N 16200001Cancelled May 29, 2020 · Registration expired, pending cancellation · Built 2008 · Textron Aviation IncN300GRTextron 172S · S/N 172S12426Cancelled May 29, 2020 · Exported to China · Textron Aviation IncN322DJTextron 172S · S/N 172S12423Cancelled May 29, 2020 · Exported to China · Built 2020 · Textron Aviation IncN6389TTextron 172S · S/N 172S12420Cancelled May 29, 2020 · Exported to China · Built 2020 · Textron Aviation IncN732MPCessna U206G · S/N U20604694Cancelled May 29, 2020 · Registration expired, pending cancellation · Built 1979 · Textron AviationincN7637TTextron 172S · S/N 172S12421Cancelled May 29, 2020 · Exported to China · Built 2020 · Textron Aviation IncN7728TTextron 172S · S/N 172S12422Cancelled May 29, 2020 · Exported to China · Textron Aviation IncN8431TTextron 172S · S/N 172S12427Cancelled May 29, 2020 · Exported to China · Built 2020 · Textron Aviation IncN860XTTextron 172S · S/N 172S12425Cancelled May 29, 2020 · Exported to China · Textron Aviation IncN9145TTextron 172S · S/N 172S12428Cancelled May 29, 2020 · Exported to China · Built 2020 · Textron Aviation IncN2053BTextron 208B · S/N 208B5576Cancelled May 28, 2020 · Exported to Mexico · Textron Aviation IncN7756TTextron 172S · S/N 172S12424Cancelled May 28, 2020 · Exported to China · Built 2020 · Textron Aviation IncN882CBTextron 172S · S/N 172S12461Cancelled Apr 24, 2020 · Exported to Australia · Textron Aviation IncN39WCTextron 208B · S/N 208B5594Cancelled Apr 3, 2020 · Exported to Norway · Textron Aviation IncN76601Cessna 140 · S/N 11041Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Built 1946 · Pate Charles CN828NBerwick-Dahlinger BD-150 · S/N 1Cancelled Apr 3, 2020 · Revoked, canceled · Built 1965 · Dahlinger Gerald WN73369Fairchild M-62A · S/N T424204Cancelled Mar 25, 2020 · Revoked, canceled · Built 1942 · Gooch U LN375KATextron B200GT · S/N BY-375Cancelled Mar 24, 2020 · Exported to Brazil · Textron Aviation Inc
Back to Wichita, KS