Thomas, OK
Cancelled registrations · 251
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 = 'THOMAS' 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 = 'THOMAS' 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.
N731NGCessna A188B · S/N 18803015TN731SQCessna A188B · S/N 18803122TN79138Cessna A188B · S/N 18801965TN7346ZPiper PA-25-235 · S/N 25-3297N3727EPiper PA-36-300 · S/N 36-7960057N774TCessna A188B · S/N 188-01756TN4768YPiper PA-25-260 · S/N 25-4530N21860Cessna A188B · S/N 18801081N9438RCessna A188B · S/N 18802284N4723QCessna A188B · S/N 18802494TN9503GCessna A188B · S/N 18801505TN70191Cessna A188B · S/N 18801861TN731NACessna A188B · S/N 18803014TN21735Cessna A188B · S/N 18800991N6677ZPiper PA-25-235 · S/N 25-2282N4861RCessna A188B · S/N 18802380TN2119JCessna T188C · S/N T18803853TN2030JCessna T188C · S/N T18803335TN2154KCessna A188B · S/N 18801249TN53274Cessna A188B · S/N 18801730TN9537PPiper PA-25-235 · S/N 25-7405625N9766JCessna A188B · S/N 18803851TN9438GCessna A188B · S/N 18801485TN731GUCessna A188B · S/N 18802892TN9957JCessna T188C · S/N T18803886TN4785QCessna A188B · S/N 18802527TN4943RCessna A188B · S/N 18802460TN4385SCessna A188B · S/N 18801443N4456QCessna 188B · S/N 18800856N8060FCessna A188B · S/N 18801392TN9640GCessna A188B · S/N 18801576N6978ZPiper PA-25-235 · S/N 25-2724N7610ZPiper PA-25-235 · S/N 25-3710N731CLCessna A188B · S/N 18802790TN7085BCessna A188B · S/N 188-02182TN82365Piper PA-25-235 · S/N 25-7656103N90183Cessna A188B · S/N 18802629TN4383SCessna A188B · S/N 18803168TN4818QCessna A188B · S/N 18802555N4056JCessna T188C · S/N T18803716TN9956JCessna T188C · S/N T18803885TN731LJCessna A188B · S/N 18802975TN9409GCessna A188B · S/N 18801477N9777GCessna A188B · S/N 18801602TN731GBCessna A188B · S/N 18802807TN731JDCessna A188B · S/N 18802924N4882RCessna A188B · S/N 18802401TN3872JCessna T188C · S/N T18803679TN4848RCessna A188B · S/N 18802367TN2832JCessna A188B · S/N 18803526T
Back to Thomas, OK