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.

N513VHTextron 172S · S/N 172S12613Cancelled Jun 9, 2021 · Exported to Colombia · Built 2021 · Textron Aviation IncN515BHTextron 172S · S/N 172S12615Cancelled Jun 9, 2021 · Exported to Colombia · Built 2021 · Textron Aviation IncN520THTextron 172S · S/N 172S12620Cancelled Jun 9, 2021 · Exported to Colombia · Built 2021 · Textron Aviation IncN629TLTextron 208B · S/N 208B5629Cancelled Jun 9, 2021 · Exported to Paraguay · Built 2021 · Textron Aviation IncN632TLTextron 208B · S/N 208B5632Cancelled Jun 9, 2021 · Exported to Paraguay · Textron Aviation IncN80PQLearjet 45 · S/N 417Cancelled Jun 1, 2021 · Exported to India · Built 2010 · Rangeflyers Inc TrusteeN390BYTextron B200GT · S/N BY-390Cancelled May 28, 2021 · Exported to Germany · Built 2021 · Textron Aviation IncN522EXTextron 208B · S/N 208B5522Cancelled May 21, 2021 · Exported to New Zealand · Built 2019 · Rangeflyers Inc TrusteeN710EXTextron 208B · S/N 208B5615Cancelled May 6, 2021 · Exported to Pakistan · Built 2021 · Textron Aviation IncN711EXTextron 208B · S/N 208B5617Cancelled May 6, 2021 · Exported to Pakistan · Built 2021 · Textron Aviation IncN114TRCessna 680 · S/N 680-0114Cancelled May 4, 2021 · Exported to Switzerland · Textron Aviation IncN828AJTextron B300 · S/N FL-1105Cancelled May 3, 2021 · Exported to Philippines · Built 2017 · Rangeflyers Inc TrusteeN2056WTextron 208B · S/N 208B5612Cancelled Apr 27, 2021 · Exported to Botswana · Built 2020 · Aviation Dynamix LLCN83413Beech 1900D · S/N UE-25Cancelled Apr 22, 2021 · Exported to Poland · Rangeflyers IncN1559GBeech B200 · S/N BB-1480Cancelled Apr 15, 2021 · Exported to South Africa · Built 1994 · Specialized Aircraft Services IncN350TTTextron B300 · S/N FL-1158Cancelled Apr 14, 2021 · Exported to Sweden · Built 2018 · Rangeflyers Inc TrusteeN218CWHall William B THORP T-18 CW · S/N 1344Cancelled Apr 3, 2021 · Registration expired, pending cancellation · Built 1994 · Kelley John MN2696MPiper PA-12 · S/N 12-1123Cancelled Mar 30, 2021 · Revoked, canceled · Built 1946 · Harte Flying SvcN338EFCessna 208B · S/N 208B2338Cancelled Mar 30, 2021 · Exported to Indonesia · Built 2012 · Rangerflyers Inc TrusteeN94FMTextron B300C · S/N FM-94Cancelled Mar 26, 2021 · Exported to Australia · Textron Aviation IncN283MJTextron 525B · S/N 525B0629Cancelled Mar 23, 2021 · Exported to Mexico · Textron Financial CorpN92FMTextron B300C · S/N FM-92Cancelled Mar 11, 2021 · Exported to Australia · Textron Aviation IncN896VTTextron 208B · S/N 208B5616Cancelled Mar 9, 2021 · Exported to Switzerland · Built 2021 · Textron Aviation IncN534KBBell Helicopter Textron Canada 412EP · S/N 36690Cancelled Mar 8, 2021 · Exported to India · Built 2014 · Textron Financial CorpN90544Textron 208B · S/N 208B5618Cancelled Feb 26, 2021 · Exported to Poland · Textron Aviation IncN893UKTextron 172S · S/N 172S12604Cancelled Feb 19, 2021 · Exported to China · Textron Aviation IncN212WBTextron 680A · S/N 680A0258Cancelled Feb 9, 2021 · Exported to Japan · Rangeflyers Inc TrusteeN893JFTextron 172S · S/N 172S12601Cancelled Feb 5, 2021 · Exported to China · Textron Aviation IncN893KTTextron 172S · S/N 172S12600Cancelled Feb 5, 2021 · Exported to China · Textron Aviation IncN897DTTextron 208B · S/N 208B5609Cancelled Feb 2, 2021 · Exported to Bahamas · Textron Financial CorpN29141Cessna 210L · S/N 21059818Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1973 · Long Earl V IIIN411CJCessna 525A · S/N 525A0411Cancelled Jan 20, 2021 · Exported to New Zealand · Built 2008 · Rangeflyers IncN893SSTextron 172S · S/N 172S12591Cancelled Jan 20, 2021 · Exported to China · Textron Aviation IncN893TYTextron 172S · S/N 172S12593Cancelled Jan 20, 2021 · Exported to China · Textron Aviation IncN707EXTextron 208B · S/N 208B5583Cancelled Jan 19, 2021 · Exported to Pakistan · Built 2020 · Textron Aviation IncN708EXTextron 208B · S/N 208B5585Cancelled Jan 19, 2021 · Exported to Pakistan · Built 2020 · Textron Aviation IncN709EXTextron 208B · S/N 208B5591Cancelled Jan 19, 2021 · Exported to Pakistan · Built 2020 · Textron Aviation IncN76268Cessna 140 · S/N 10676Cancelled Jan 11, 2021 · Registration expired, pending cancellation · Built 1946 · Patton Billy VN9503SChampion 7ECA · S/N 252Cancelled Jan 11, 2021 · Registration expired, pending cancellation · Built 1965 · Higgs Tyler DN273RKTextron C90GTI · S/N LJ-2173Cancelled Jan 4, 2021 · Exported to Germany · Rangeflyers IncN527EXTextron 208B · S/N 208B5527Cancelled Dec 29, 2020 · Exported to Brazil · Built 2019 · Textron Aviation IncN892RTTextron 172S · S/N 172S12570Cancelled Dec 21, 2020 · Exported to India · Built 2020 · Textron Aviation IncN2709MTextron 208B · S/N 208B5582Cancelled Dec 15, 2020 · Exported to Brazil · Textron Aviation IncN581EXTextron 208B · S/N 208B5581Cancelled Dec 11, 2020 · Exported to Brazil · Textron Aviation IncN890PTTextron 208B · S/N 208B5579Cancelled Dec 7, 2020 · Exported to Indonesia · Rangeflyers Inc TrusteeN505RCTextron C90GTI · S/N LJ-2175Cancelled Dec 4, 2020 · Exported to Brazil · Textron Aviation IncN2064LTextron 182T · S/N 18283114Cancelled Dec 2, 2020 · Exported to Brazil · Textron Aviation IncN597DWTextron 208B · S/N 208B5597Cancelled Dec 2, 2020 · Exported to Brazil · Textron Aviation IncN8894TTextron 525 · S/N 525-1061Cancelled Dec 2, 2020 · Exported to China · Built 2020 · Textron Aviation IncN8898TTextron 525 · S/N 525-1060Cancelled Dec 2, 2020 · Exported to China · Built 2020 · Textron Aviation Inc
Back to Wichita, KS