Weatherford, OK
Cancelled registrations · 71
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 = 'WEATHERFORD' 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 = 'WEATHERFORD' 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.
N525HTGolden Circle Air T-BIRD II · S/N 0003RHTN6101LAmerican AA-1 · S/N AA1-0301N5501DBeech H35 · S/N D-5008N622BCRussell William M GLASAIR SH-2 · S/N 472N60691Cessna A188B · S/N 18802806TN21527Cessna 172S · S/N 172S9449N72AFCessna 172R · S/N 17280070N912FSPrecision Design FANTA SEA 100 · S/N 001N734AACessna 172N · S/N 17268692N5654QMooney M20E · S/N 683N415MSchempp-Hirth STANDARD AUSTRIA S · S/N 41N3014VBeech 35 · S/N D-416N235PDPrecision Design PDQ · S/N 001N9068LRobinson Helicopter R22 · S/N 0168N92FSCanadair F-86E MK.6 · S/N 1075N5012XSkybirds Sales TIERRA II · S/N SBSI47N51DXSummers Dreaux J SORRELL SNS-8 · S/N 162N6590VBellanca 17-31A · S/N 32-27N301FSCanadair T-33 · S/N 555N2963TAero Commander 100 · S/N 111N1268WWeatherly 201B · S/N 622N737AZCessna 172N · S/N 17269280N4635QCessna 210L · S/N 21059535N7419QCessna 182P · S/N 18261059N9199HCessna 172M · S/N 17266010N6310ZPiper PA-25 · S/N 25-394N155CCSchrader Clifford C ACRO SPORT II · S/N 618N92450Cessna 182G · S/N 18255499N3837BBeech F35 · S/N D-4108N62365Cessna 172P · S/N 17275259N2151JCessna 172R · S/N 17280679N157DDrake S G KITFOX SPEEDSTER · S/N EBS007N731JCCessna A188B · S/N 18802923TN731CXCessna A188B · S/N 18802801TN92370Cessna A188B · S/N 18802061TN9555PPiper PA-25-235 · S/N 25-7405669N731SJCessna A188B · S/N 18803116TN4986QCessna A188B · S/N 18802720TN9835PPiper PA-25-235 · S/N 257556152N3020JCessna T188C · S/N T18803592TN731WACessna A188B · S/N 18803062TN4716QCessna A188B · S/N 18802491TN9202RCessna A188B · S/N 18802147TN309RWSauer Jack EXEC 90 · S/N R1625126N2089JCessna T188C · S/N T18803379TN731SFCessna A188B · S/N 18803113TN9874PPiper PA-25-235 · S/N 257556203N9790PPiper PA-25-235 · S/N 257556103N4347JCessna T188C · S/N T18803733TN4489JCessna T188C · S/N T18803739T
Back to Weatherford, OK