Independence, KS
Cancelled registrations · 189
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 = 'INDEPENDENCE' 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 = 'INDEPENDENCE' 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.
N5268PCessna T182T · S/N T18208978N5271JCessna T182T · S/N T18208984N5271KCessna T182T · S/N T18208985N5274GCessna 510 · S/N 510-0255N5274KCessna 510 · S/N 510-0258N5274MCessna 510 · S/N 510-0267N5256KCessna T182T · S/N T18208972N5263RCessna T182T · S/N T18208974N5268WCessna T182T · S/N T18208979N5227NCessna 172S · S/N 172S10914N10427Cessna LC41-550FG · S/N 411142N5246GCessna T182T · S/N T18208959N5246YCessna T182T · S/N T18208961N5247ECessna T182T · S/N T18208962N52559Cessna T182T · S/N T18208970N5255YCessna T182T · S/N T18208966N5086GCessna T206H · S/N T20608929N6545WPiper PA-28-140 · S/N 28-20624N5233BCessna T182T · S/N T18208945N5238GCessna T182T · S/N T18208949N5246FCessna T182T · S/N T18208958N52273Cessna T206H · S/N T20608907N5160FCessna T182T · S/N T18208938N5232YCessna T182T · S/N T18208939N52370Cessna T182T · S/N T18208947N52281Cessna T206H · S/N T20608911N52733Cessna 510 · S/N 510-0225N5153VCessna T182T · S/N T18208932N5155NCessna T182T · S/N T18208933N51596Cessna T182T · S/N T18208937N51272Cessna T182T · S/N T18208928N5128JCessna T182T · S/N T18208930N52294Cessna T182T · S/N T18208924N5229YCessna T182T · S/N T18208922N5230CCessna T182T · S/N T18208925N6206FCessna 172S · S/N 172S10811N6338HCessna 172S · S/N 172S10819N1326SCessna T206H · S/N T20608808N62012Cessna 172S · S/N 172S10798N62016Cessna 172S · S/N 172S10799N61930Cessna 182T · S/N 18282053N6189DCessna T206H · S/N T20608822N1312DCessna 182T · S/N 18282052N447CPCessna 182T · S/N 18282047N1227KCessna T206H · S/N T20608708N1735CCessna 172S · S/N 172S10646N1735LCessna 172S · S/N 172S10647N2408ACessna 172S · S/N 172S10551N2467VCessna 172S · S/N 172S10579N2142UCessna 182T · S/N 18281877
Back to Independence, KS