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.
N619EXTextron 208B · S/N 208B5619N107BETextron B300C · S/N FM-107N650BABombardier BD-700-1A10 · S/N 60055N261CSTextron 182T · S/N 18283161N918QSTextron 680A · S/N 680A0343N937HTTextron 208B · S/N 208B5706N937JTTextron 208B · S/N 208B5707N786BFTextron 680A · S/N 680A0325N1KQTextron 525C · S/N 525C0269N750GXBombardier BD-700-2A12 · S/N 70068N936RTTextron 172S · S/N 172S12854N936TTTextron 172S · S/N 172S12856N3004RTextron 208B · S/N 208B5699N106RSTextron B300C · S/N FM-106N388BYTextron B200GT · S/N BY-388N505BZTextron B200CGT · S/N BZ-5N335JPDJI INSPIRE 1 · S/N W13DCD16030152N606BZTextron B200CGT · S/N BZ-6N881DPTextron 208B · S/N 208B5688N3006GTextron T206H · S/N T20609680N671SRTextron 208B · S/N 208B5627N30039Textron T206H · S/N T20609694N378CJCessna 525A · S/N 525A0378N3045XCessna 150F · S/N 15064445N40LXLearjet 45 · S/N 001N425PLCessna 425 · S/N 425-0010N3003VTextron 182T · S/N 18283182N826EWDassault FALCON 2000 · S/N 58N848AFTextron 172S · S/N 172S12848N850AFTextron 172S · S/N 172S12850N843AFTextron 172S · S/N 172S12843N846AFTextron 172S · S/N 172S12846N20GETextron 208B · S/N 208B5687N607SETextron 208B · S/N 208B5686N1287YTextron B300 · S/N FL-1287N931ZTTextron 172S · S/N 172S12820N932AATextron 172S · S/N 172S12814N932GBTextron 172S · S/N 172S12819N630LATextron 3000 (AT-6C) · S/N AT-3N30025Textron 208B · S/N 208B5678N99KCTextron B300 · S/N FL-1204N700AFTextron 700 · S/N 700-0024N75TETextron 182T · S/N 18283175N400MRHawker Beechcraft 4000 · S/N RC-12N921NTTextron 172S · S/N 172S12791N682GPTextron 172S · S/N 172S12785N921HTTextron 172S · S/N 172S12784N676MBTextron 208B · S/N 208B5676N975WPTextron B300 · S/N FL-1219N1292VTextron 208B · S/N 208B5663
Back to Wichita, KS