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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N513VHTextron 172S · S/N 172S12613N515BHTextron 172S · S/N 172S12615N520THTextron 172S · S/N 172S12620N629TLTextron 208B · S/N 208B5629N632TLTextron 208B · S/N 208B5632N80PQLearjet 45 · S/N 417N390BYTextron B200GT · S/N BY-390N522EXTextron 208B · S/N 208B5522N710EXTextron 208B · S/N 208B5615N711EXTextron 208B · S/N 208B5617N114TRCessna 680 · S/N 680-0114N828AJTextron B300 · S/N FL-1105N2056WTextron 208B · S/N 208B5612N83413Beech 1900D · S/N UE-25N1559GBeech B200 · S/N BB-1480N350TTTextron B300 · S/N FL-1158N218CWHall William B THORP T-18 CW · S/N 1344N2696MPiper PA-12 · S/N 12-1123N338EFCessna 208B · S/N 208B2338N94FMTextron B300C · S/N FM-94N283MJTextron 525B · S/N 525B0629N92FMTextron B300C · S/N FM-92N896VTTextron 208B · S/N 208B5616N534KBBell Helicopter Textron Canada 412EP · S/N 36690N90544Textron 208B · S/N 208B5618N893UKTextron 172S · S/N 172S12604N212WBTextron 680A · S/N 680A0258N893JFTextron 172S · S/N 172S12601N893KTTextron 172S · S/N 172S12600N897DTTextron 208B · S/N 208B5609N29141Cessna 210L · S/N 21059818N411CJCessna 525A · S/N 525A0411N893SSTextron 172S · S/N 172S12591N893TYTextron 172S · S/N 172S12593N707EXTextron 208B · S/N 208B5583N708EXTextron 208B · S/N 208B5585N709EXTextron 208B · S/N 208B5591N76268Cessna 140 · S/N 10676N9503SChampion 7ECA · S/N 252N273RKTextron C90GTI · S/N LJ-2173N527EXTextron 208B · S/N 208B5527N892RTTextron 172S · S/N 172S12570N2709MTextron 208B · S/N 208B5582N581EXTextron 208B · S/N 208B5581N890PTTextron 208B · S/N 208B5579N505RCTextron C90GTI · S/N LJ-2175N2064LTextron 182T · S/N 18283114N597DWTextron 208B · S/N 208B5597N8894TTextron 525 · S/N 525-1061N8898TTextron 525 · S/N 525-1060
Back to Wichita, KS