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.
N61TBeech B35 · S/N D-2466N6004JCessna A150L · S/N A1500304N608TBeech B-55 · S/N TC-2021N594Hughes 269A · S/N 191061N595Bell TH-13T · S/N 67-17059N5701WRaven Industries RALLY RX7 · S/N RX7-200N5809GCessna 150K · S/N 15071309N551JMMorgan 1976 ICARUS V · S/N JM1N43GCCessna 182A · S/N 34222N5169WBurchinal I N JR F86-L · S/N 2837N33467Hiller H-23D · S/N 61-3201N348UBeech 58 · S/N TH-677N761VXCessna 210M · S/N 21062563N2177MAero Commander 680-F · S/N 680F-1170-89N2472TPiper PA-38-112 · S/N 38-78A0811N2527KPiper PA-38-112 · S/N 38-79A0674N300MGConvair 240-14 · S/N 130N1350PPiper PA-23 · S/N 23-399N1750ABeech 36 · S/N E-180N18HHinchliffe-Dorman CASSUTT DH2 · S/N 1002N8045FHughes TH-55A · S/N 66-18275N5388SCessna R182 · S/N R18201564N800GBBowling George W TIERRA II · S/N 4474N44599Head Balloons AX8-88 · S/N 109N6011PPiper PA-24-250 · S/N 24-1105N77MSBeech 65 · S/N LC-86N290JDConvair T-29B · S/N 272N3752APiper PA-22-135 · S/N 22-1995N5527E.A.A. Chapter 244 VP-1 · S/N 200N9807Grumman Acft ENG Cor-Schweizer G-164A · S/N 1267N5006UBell 206B · S/N 2489N9508TCessna 210 · S/N 57308N4695QCessna 210L · S/N 21059595N5150XLookis Gerald P 206L · S/N JPL002N9270FHughes 369HS · S/N 1050772SN88HRPiper PA-28R-200 · S/N 28R-7335320N89752Cessna 152 · S/N 15282852N89917Cessna 152 · S/N 15282913N9737UGrumman American Avn. AA-5A · S/N AA5A-0137N363NBeech 65-A90 · S/N LJ-236N8713HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1495N12130Smith Stephen R NIEUPORT 17 C-1 · S/N 00980N8028LCessna 172H · S/N 17256228N8502SCessna 182H · S/N 18256602N1233LConsolidated Aeronautics LAKE LA-4-200 · S/N 733N7604RBeech B23 · S/N M-1231N7627YPiper PA-30 · S/N 30-702N7700KCessna 182K · S/N 18258130N5773KBeech D95A · S/N TD-583N735TJCessna 182Q · S/N 18265668
Back to Dallas, TX