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.
N21LFLear Fan LF 2100 · S/N E003N7942DBeech H35 · S/N D-5192N86495Hafe CH-1 · S/N 1N89268Cessna 152 · S/N 15282693N2251CCessna 180 · S/N 30551N3672RPiper PA-28-180 · S/N 28-5775N4267CCessna 340A · S/N 340A0519N83TGGordy Thomas O QUICKIE Q2 · S/N 2151N90ADCessna P210N · S/N P21000156N914WSopwith PUP · S/N NCH1N91WTPiper PA-32R-300 · S/N 32R-7680525N42CBBodin Charles J XTC · S/N 053N89282Cessna 152 · S/N 15282699N222KCPiper PA-28-140 · S/N 28-7525290N5625LAmerican AA-5 · S/N AA5-0225N5745RCessna 172G · S/N 17253414N6101KCessna 150M · S/N 15077527N69172Cessna 152 · S/N 15282526N33FCessna 310 · S/N 35077N3864XAero Commander 100 · S/N 190N48721Grumman Acft ENG Cor-Schweizer G-164B · S/N 122BN4872PCessna P210N · S/N P21000125N49788Cessna 152 · S/N 15283515N6363PPiper PA-24 · S/N 24-1473N4596TPiper PA-28R-200 · S/N 28R-7235103N65147Carey Richard L KITFOX · S/N 529N7567VCessna 177RG · S/N 177RG0858N117GKPiper PA-23-250 · S/N 27-7304955N21594Rainville Mini Bi Plane Dsa-1 MINIPLANE · S/N ER 2926N64921Cessna 152 · S/N 15281477N67739Cessna 152 · S/N 15281988N948BBAir Tractor AT-502A · S/N 502A-0478N36RZNorth American NA-265-60 · S/N 306-2N57706Piper PA-36-285 · S/N 36-7660032N8057ZRobinson Helicopter R22 BETA · S/N 2396N807LACessna 208 · S/N 20800026N901NSCessna 172M · S/N 17265031N9336HCessna 172M · S/N 17266094N17254Cessna 150L · S/N 15073690N19884Cessna 177B · S/N 17702611N2675JCessna 150G · S/N 15065675N6533HPiper J3C-65 · S/N 19724N16BABeech D55 · S/N TE-590N311DSBeech F90 · S/N LA-41N32925Piper PA-28-140 · S/N 28-7525128N63577Cessna 150M · S/N 15077406N6474DHolden THE APARATUS · S/N 1N70646Cessna 182M · S/N 18259339N9317GCessna 182P · S/N 18260857N11DNHandley Page HP-137 MK1 · S/N 204
Back to Dallas, TX