Olney, TX
Cancelled registrations · 285
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 = 'TX' AND d.registrant_city = 'OLNEY' 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 = 'TX' AND d.registrant_city = 'OLNEY' 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.
N45008Air Tractor AT-402B · S/N 402B-1456N4501MAir Tractor AT-502B · S/N 502B-3326N4502AAir Tractor AT-802A · S/N 802A-0918N4502LAir Tractor AT-602 · S/N 602-1326N4502FAir Tractor AT-502B · S/N 502B-3320N4501DAir Tractor AT-602 · S/N 602-1325N45001Air Tractor AT-502B · S/N 502B-3323N4502RAir Tractor AT-502B · S/N 502B-3322N45009Air Tractor AT-602 · S/N 602-1324N4501CAir Tractor AT-802A · S/N 802A-0917N4500YAir Tractor AT-402B · S/N 402B-1455N4501PAir Tractor AT-502B · S/N 502B-3317N707XFAir Tractor AT-802 · S/N 802-0812N707NFAir Tractor AT-802 · S/N 802-0811N503WFAir Tractor AT-502B · S/N 502B-3243N80057Air Tractor AT-802 · S/N 802-0856N80618Air Tractor AT-502A · S/N 502A-3252N299LAAir Tractor AT-502B · S/N 502B-3247N80048Air Tractor AT-802 · S/N 802-0854N8002HAir Tractor AT-802A · S/N 802A-0852N8058TAir Tractor AT-802A · S/N 802A-0850N8060FAir Tractor AT-802 · S/N 802-0849N8058HAir Tractor AT-802A · S/N 802A-0848N10061Air Tractor AT-802A · S/N 802A-0844N8057VAir Tractor AT-802A · S/N 802A-0845N8057BAir Tractor AT-502B · S/N 502B-3248N80544Air Tractor AT-802A · S/N 802A-0835N2236APiper PA-22-135 · S/N 22-644N80516Air Tractor AT-802A · S/N 802A-0808N8047UAir Tractor AT-602 · S/N 602-1301N8027PAir Tractor AT-502B · S/N 502B-3204N80410Air Tractor AT-802A · S/N 802A-0796N8029QAir Tractor AT-502A · S/N 502A-3190N30715Air Tractor AT-504 · S/N 504-4024N80346Air Tractor AT-502B · S/N 502B-3122N331LAAir Tractor AT-502B · S/N 502B-3101N5056QButterfly MONARCH · S/N B218N359XPAir Tractor AT-502A · S/N 502A-3059N8031NAir Tractor AT-502A · S/N 502A-3083N503LLAir Tractor AT-502B · S/N 502B-3053N30840Air Tractor AT-802 · S/N 802-0632N3080VAir Tractor AT-502B · S/N 502B-3033N3077QAir Tractor AT-502B · S/N 502B-3030N3079TAir Tractor AT-802A · S/N 802A-0612N3080TAir Tractor AT-802 · S/N 802-0614N3079QAir Tractor AT-504 · S/N 504-4026N30799Air Tractor AT-802A · S/N 802A-0606N3076RAir Tractor AT-802A · S/N 802A-0598N30804Air Tractor AT-802A · S/N 802A-0592N30744Air Tractor AT-802A · S/N 802A-0582
Back to Olney, TX