Bethany, OK
Cancelled registrations · 335
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 = 'OK' AND d.registrant_city = 'BETHANY' 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 = 'OK' AND d.registrant_city = 'BETHANY' 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.
N78349Aero Commander 680FL · S/N 12912N78340Aero Commander 500-B · S/N 500B-1134-76N78381Aero Commander 680-F · S/N 680F-1241-123N78338Aero Commander 500-B · S/N 500B-1190-96N78385Aero Commander 560-F · S/N 560F-1246-54N6293XAero Commander 680-F · S/N 680F-1209-110N6245XAero Commander 680-F · S/N 680F-1087-65N181EBeech D18S · S/N A-252N6241BAero Commander 500 · S/N 654N2749BAero Commander 560-A · S/N 249N9352RAero Commander 560-E · S/N 864N9355RAero Commander 560-E · S/N 869N8499CAero Commander 560-E · S/N 861N8464CAero Commander 500 · S/N 803N8484CAero Commander 500 · S/N 829N9350RAero Design & Engineering 500 · S/N 852N6211BAero Commander 680 · S/N 680-547-215N6210DAero Commander 680 · S/N 680-483-153N6252DAero Commander 680 · S/N 680-520-190N6201DAero Commander 680 · S/N 680-469-139N6211DAero Commander 680 · S/N 680-479-149N6215DAero Commander 680 · S/N 680-478-148N6206DAero Commander 680 · S/N 680-474-144N77692Fairchild 24R-46 · S/N R46392N26634Taylorcraft BC-65 · S/N 1976N2615BAero Commander 520 · S/N 128N2616BAero Commander 520 · S/N 129N2617BAero Commander 520 · S/N 130N4677NConsolidated Vultee BT-13 · S/N 11310N95474Cessna T-50 · S/N 4598N4625NBeech GB-2 · S/N D17S6739N4627NBeech GB-2 · S/N D17S6877N24WFriedrich H / Kohl A LAND MONOPLANE · S/N 2N83SARockwell International 690C · S/N 11700N9115NAero Commander 680FL · S/N 1852-156
Back to Bethany, OK