Dallas, TX
Cancelled registrations · 2,333
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 = 'TX' AND d.registrant_city = 'DALLAS' 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 = 'TX' AND d.registrant_city = 'DALLAS' 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.
N28008Bellanca 17-30A · S/N 78-30868N28157Bellanca 17-30A · S/N 80-30987N57329Piper PA-28-140 · S/N 28-7425093N21KLLarson JUNGMEISTER BU133S · S/N 222N2656FCessna 182J · S/N 18256756N2699JCessna 150G · S/N 15065699N4779DCessna 182A · S/N 34879N5411YPiper PA-23-250 · S/N 272487N2483APiper PA-38-112 · S/N 38-78A0707N25058Cessna 152 · S/N 15280521N2508DPiper PA-38-112 · S/N 38-79A0345N25352Cessna 152 · S/N 15280610N54BLCessna 337E · S/N 33701261N525BBeech A35 · S/N D-1522N21918Cessna 150L · S/N 15074535N1624RGrumman American Avn. AA-1B · S/N AA1B-0624N2075DBeech D18S · S/N A-945N4701PPiper PA-23-250 · S/N 27-229N2068TPiper PA-28R-200 · S/N 28R-7135012N19683Cessna 172L · S/N 17260666N1922HAero Commander 680 · S/N 680-359-47N185TFBeech 65 · S/N LC-103N4702NHoward DGA-15P · S/N 834N470BBeech D18S · S/N A-476N17886Schweizer SGS 2-33A · S/N 256N1646JPiper PA-28-140 · S/N 28-24038N308SABoeing 737-3Y0 · S/N 23498N310SWBoeing 737-3H4 · S/N 22949N336SWBoeing 737-3H4 · S/N 23940N341SWBoeing 737-3H4 · S/N 24091N348SWBoeing 737-3H4 · S/N 24375N501SWBoeing 737-5H4 · S/N 24178N503SWBoeing 737-5H4 · S/N 24180N513SWBoeing 737-5H4 · S/N 24190N519SWBoeing 737-5H4 · S/N 25318N8134YHawker Beechcraft B200GT · S/N BY-134N4470NCessna T-50 · S/N 4754N1496GBeech 95-A55 · S/N TC-266N15424Piper PA-28-140 · S/N 28-7325065N15AZGrumman American Avn. G-164 · S/N 294N607UGrumman G-164 · S/N 336N14765Bellanca 17-30A · S/N 74-30625N4343MPiper PA-12 · S/N 12-3281N172MCessna 172M · S/N 17262322N330SPetrik-Pitts Special S1C · S/N 237HN39140Taylorcraft BC12-65 · S/N 3399N424HLockheed 18-56 · S/N 2324N42003Piper J3C-65 · S/N 14078N11728Cessna 150L · S/N 15075594N41MLockheed 18-56 · S/N 2406
Back to Dallas, TX