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.
N2433KPiper PA-38-112 · S/N 38-79A0631N6890ZPiper PA-25-235 · S/N 25-2615N4851QCessna A188B · S/N 18802587N9347RCessna A188B · S/N 18802248TN202AWCessna A188B · S/N 18800835N6190APiper PA-36-375 · S/N 36-8102022N731NKCessna A188B · S/N 18803023TN4989QCessna A188B · S/N 18802723TN5338JPitts Aerobatics S-2B · S/N 5075N444TLBellanca 17-31ATC · S/N 73-31043N4833QCessna A188B · S/N 18802569TN57856Piper PA-36-300 · S/N 36-7760027N173JCCessna 310B · S/N 35553N3693YCessna 210C · S/N 21058193N5547MAero Commander 100 · S/N 177N8154CPiper PA-34-200T · S/N 34-7970391N4256NCessna A188B · S/N 188-01514TN4911QCessna A188B · S/N 18802646TN4879JCessna 172N · S/N 17273689N53207Cessna A188B · S/N 18801684TN117LHCessna 188 · S/N 18801814N41690Bellanca 7KCAB · S/N 399-73N88228Bellanca 7KCAB · S/N 476-74N9RBCessna 210F · S/N 21058776N2350XPiper PA-36-375 · S/N 36-8202010N3673EPiper PA-36-375 · S/N 36-7902045N4459QCessna A188B · S/N 18800859N98505Cessna 172P · S/N 17276303N9153GCessna A188B · S/N 18801397N82642Piper PA-36-300 · S/N 36-7760124N2478WCessna T182T · S/N T18208776N5650GCessna A188B · S/N 18801131TN220RABeech 58 · S/N TH-624N2199JCessna T188C · S/N T18803436TN2694JCessna T188C · S/N T18803499TN9213RCessna A188B · S/N 18802158N9719PPiper PA-25-260 · S/N 25-7556038N9316GCessna A188B · S/N 18801451N9422GCessna A188B · S/N 18801480TN9995GCessna A188A · S/N 18800795N11956Cessna 150L · S/N 15075734N119HRHawker Beechcraft G36 · S/N E-3823N5356VCessna 172RG · S/N 172RG0513N70126Cessna A188B · S/N 18801842TN7790ZPiper PA-25-235 · S/N 25-2024N8514EChampion 7FC · S/N 7FC-327N4894RCessna A188B · S/N 18802412TN9224RCessna A188B · S/N 18802167TN4952QCessna A188B · S/N 18802686TN5339QCessna 150L · S/N 15073239
Back to Thomas, OK