Augusta, KS
Cancelled registrations · 218
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 = 'AUGUSTA' 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 = 'AUGUSTA' 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.
N2098ABeech 95-B55 · S/N TC-1217N6458VHelio H-295 · S/N 1410N7648NBeech 60 · S/N P-45N7991RBeech 36 · S/N E-151N7974RBeech V35A · S/N D-8970N7982RBeech V35A · S/N D-8971N8070RBeech 70 · S/N LB-2N7723RBeech D55 · S/N TE-638N7727RBeech D55 · S/N TE646N7751RBeech 95-B55 (T42A) · S/N TC-1177N7717RBeech D55 · S/N TE-642N7808RBeech E33 · S/N CD-1172N7718RBeech 95-B55 (T42A) · S/N TC-1162N7778RBeech 36 · S/N E-123N7787RBeech 36 · S/N E-124N7868RBeech V35A · S/N D-8863N7885RBeech V35A · S/N D-8864N8482NBeech B90 · S/N LJ-397N7702RBeech D55 · S/N TE-631N7649NBeech 95-B55 (T42A) · S/N TC-1155N7628NBeech D55 · S/N TE-619N7720RBeech 36 · S/N E-84N8439NBeech A65-8200 · S/N LC-300N8438NBeech A65 · S/N LC-298N7627NBeech D55 · S/N TE-624N8416NBeech D55 · S/N TE-592N7520NBeech E33A · S/N CE-233N7667NBeech D55 · S/N TE-618N8338NBeech 95-B55 (T42A) · S/N TC-1124N7662NBeech 36 · S/N E-50N146JBeech 95-B55 · S/N TC-688N8467NBeech D55 · S/N TE-578N7481NBeech 36 · S/N E-25N7482NBeech 36 · S/N E-30N7483NBeech 36 · S/N E-35N7489NBeech 95-B55 · S/N TC-1133N3700QBeech A65-8200 · S/N LC-295N7748RBeech V35A · S/N D-8860N8349NBeech B-55 · S/N TC-1086N6246VBeech 56TC · S/N TG-51N7139NBeech D55 · S/N TE-514N7024NBeech D55 · S/N TE-469N7137NBeech B-55 · S/N TC-1061N8365NBeech V35 · S/N D-8521N7161NBeech D55 · S/N TE-505N7060NBeech D55 · S/N TE-502N7037NBeech D55 · S/N TE-471N7056NBeech A65 · S/N LC-277N7120NBeech D55 · S/N TE-498N1566Dehavilland DHC-6 · S/N 80
Back to Augusta, KS