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.
N731MXCessna A188B · S/N 18803011TN2083JCessna T188C · S/N T18803373TN731EUCessna A188B · S/N 18802847TN731TRCessna A188B · S/N 18803147N4987QCessna A188B · S/N 18802721TN6517ZPiper PA-25-235 · S/N 25-2045N9034RCessna A188B · S/N 18802084TN4848QCessna A188B · S/N 18802584TN4872RCessna A188B · S/N 18802391TN731CHCessna A188B · S/N 18802788TN1118EBellanca 8KCAB · S/N 304-77N8554LPiper PA-25-260 · S/N 25-4974N3874JCessna T188C · S/N T18803680TN9972JCessna T188C · S/N T18803901TN9603JCessna T188C · S/N T18803826TN8234GCessna A188B · S/N 18801261TN4719QCessna A188B · S/N 18802492TN70214Cessna A188B · S/N 18801731TN86405Cessna A188B · S/N 18802012TN4941RCessna A188B · S/N 18802458TN4922QCessna A188B · S/N 18802657TN54883Piper PA-25-235 · S/N 25-7656029N92389Cessna A188B · S/N 18802062TN215GAGippsland GA-200C · S/N 200C9939FN4835QCessna A188B · S/N 18802571TN9805PPiper PA-25-235 · S/N 25-7556121N6210ZWSK PZL Mielec M-18 DROMADER · S/N 1Z009-13N86139Cessna A188B · S/N 18802007N9999JCessna A188B · S/N 18803928TN9541JCessna A188B · S/N 18803819TN9868PPiper PA-25-235 · S/N 25-7556192N2827JCessna A188B · S/N 18803523TN731AFCessna A188B · S/N 18802738TN4812QCessna A188B · S/N 18802550TN4864RCessna A188B · S/N 18802383TN9887PPiper PA-25-235 · S/N 25-7556181N9659JCessna T188C · S/N T18803833TN214GAGippsland GA-200C · S/N 200C9935N4739RCessna A188B · S/N 18802312TN4937QCessna A188B · S/N 18802672TN53220Cessna A188B · S/N 18801697TN4934QCessna A188B · S/N 18802669TN6650GCessna A188B · S/N 18801209N208GAGippsland GA200 · S/N 2009828FN2183JCessna T188C · S/N T18803420TN4956RCessna A188B · S/N 18802473TN4901RCessna A188B · S/N 18802419TN4833RCessna A188B · S/N 18802352TN1880CCessna 170B · S/N 26024N2300GCessna 182B · S/N 51600
Back to Thomas, OK