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.
N677GXBombardier BD-700-1A10 · S/N 60077N577RGTextron 208B · S/N 208B5777N113KATextron B300C · S/N FM-113N48SEBeech 400A · S/N RK-48N824TATextron T206H · S/N T20609724N717GLBombardier BD-700-2A12 · S/N 70117N774SUTextron 208B · S/N 208B5774N775SUTextron 208B · S/N 208B5775N90077Textron T206H · S/N T20609750N322MHTextron 172S · S/N 172S13052N344MHTextron 172S · S/N 172S13054N577SUTextron 208B · S/N 208B5770N771SUTextron 208B · S/N 208B5771N3970PTextron B200GT · S/N BY-397N575FJTextron 208B · S/N 208B5757N673EXTextron 208B · S/N 208B5673N10HDBombardier BD-700-1A10 · S/N 9682N1293KTextron B300 · S/N FL-1293N350PCTextron B300 · S/N FL-1224N355PBTextron 680A · S/N 680A0355N457KATextron B200GT · S/N BY-457N948NTTextron 208B · S/N 208B5737N205RARaytheon B200 · S/N BB-1919N542RKCessna 510 · S/N 510-0373N90048Textron 208B · S/N 208B5746N2KHTextron 525 · S/N 525-0927N455WMJim Faist MTO SPORT · S/N M00834N2842Waudby STITTS PLAYBOY · S/N P-869N30036Textron 208 · S/N 20800689N9005DTextron 208B · S/N 208B5734N153LTextron B300 · S/N FL-1276N605WATextron 208B · S/N 208B5605N62PWKendall J Ducote PEGASUS · S/N A-355-PEGN340EKTextron 680A · S/N 680A0340N101JVTextron T206H · S/N T20609717N722TLTextron 208B · S/N 208B5722N1258KTextron B300 · S/N FL-1258N702TLTextron 208B · S/N 208B5702N943KPTextron 182T · S/N 18283204N392JTCanadair CL-600-2B16 · S/N 5020N7271RBeech 58 · S/N TH-584N24060Textron F33C · S/N CJ-144N3006UTextron T206H · S/N T20609711N328EKTextron 680A · S/N 680A0328N704TLTextron 208B · S/N 208B5704N3006VTextron T206H · S/N T20609714N709SGTextron T206H · S/N T20609709N30052Textron 182T · S/N 18283201N693ABTextron 208B · S/N 208B5693N157CBTextron 182T · S/N 18283190
Back to Wichita, KS