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.
N5005XAir Tractor AT-402A · S/N 402A1075N50666Air Tractor AT-602 · S/N 602-0503N5038NAir Tractor AT-402A · S/N 402A1074N5048QAir Tractor AT-402A · S/N 402A1069N5019RAir Tractor AT-402A · S/N 402A1073N5064MAir Tractor AT-802A · S/N 802A0069N5028EAir Tractor AT-402A · S/N 402A1072N50736Air Tractor AT-402A · S/N 402A1064N5114JAir Tractor AT-502B · S/N 502B0512N5059XAir Tractor AT-802 · S/N 8020065N5103BAir Tractor AT-402A · S/N 402A1057N5049JAir Tractor AT-802A · S/N 802A0056N6180QAir Tractor AT-401B · S/N 401B1010N6171NAir Tractor AT-502B · S/N 502B0385N61669Air Tractor AT-502B · S/N 502B0383N6179CAir Tractor AT-502B · S/N 502B0389N6129UAir Tractor AT-502B · S/N 502B0367N61608Air Tractor AT-401B · S/N 401B1005N6158QAir Tractor AT-502B · S/N 502B0375N61289Air Tractor AT-802A · S/N 8020032N6097UAir Tractor AT-802 · S/N 8020031N60952Air Tractor AT-502B · S/N 502B0360N60468Air Tractor AT-502B · S/N 502B0333N6065GAir Tractor AT-802 · S/N 8020027N6055ZAir Tractor AT-502B · S/N 502B0271N6040WAir Tractor AT-401B · S/N 401B0988N6127QAir Tractor AT-401B · S/N 401B0981N6135NAir Tractor AT-802A · S/N 802A0020N6029KAir Tractor AT-401B · S/N 401B0987N6012EAir Tractor AT-502B · S/N 502B0258N61305Air Tractor AT-502B · S/N 502B0301N60619Air Tractor AT-502B · S/N 502B0272N61254Air Tractor AT-802 · S/N 8020019N60711Air Tractor AT-401B · S/N 401B0970N60661Air Tractor AT-401B · S/N 401B0969N60321Air Tractor AT-401 · S/N 4010961N6081JAir Tractor AT-401B · S/N 401B0973N6065BAir Tractor AT-401B · S/N 401B0952N6069WAir Tractor AT-802A · S/N 802A0014N60181Air Tractor AT-401B · S/N 401B0959N60552Air Tractor AT-402B · S/N 402B0966N6025VAir Tractor AT-802A · S/N 802A0012N9197ZAir Tractor AT-402 · S/N 4020945N91927Air Tractor AT-802 · S/N 8020007N9191FAir Tractor AT-401 · S/N 4010926N9191XAir Tractor AT-401 · S/N 4010928N9168QAir Tractor AT-401 · S/N 4010901N9187DAir Tractor AT-401 · S/N 4010915N9187YAir Tractor AT-401 · S/N 4010917N5243NAir Tractor AT-502 · S/N 5020113
Back to Olney, TX