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.

N61TBeech B35 · S/N D-2466Cancelled Apr 26, 2013 · Registration expired, pending cancellation · Built 1950 · Shannon Freddie JN6004JCessna A150L · S/N A1500304Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1971 · Manley Steven TN608TBeech B-55 · S/N TC-2021Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1977 · Dunlap James HN594Hughes 269A · S/N 191061Cancelled Apr 24, 2013 · Registration expired, pending cancellation · Built 1969 · Dallas Independent School DistrictN595Bell TH-13T · S/N 67-17059Cancelled Apr 24, 2013 · Registration expired, pending cancellation · Built 1967 · Dallas Independent School DistrictN5701WRaven Industries RALLY RX7 · S/N RX7-200Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1979 · Briggs DavidN5809GCessna 150K · S/N 15071309Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1969 · Turner HoseaN551JMMorgan 1976 ICARUS V · S/N JM1Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Morgan Jack DN43GCCessna 182A · S/N 34222Cancelled Apr 17, 2013 · Registration expired, pending cancellation · Built 1957 · Henthorn George DN5169WBurchinal I N JR F86-L · S/N 2837Cancelled Apr 17, 2013 · Registration expired, pending cancellation · Ball Randy WN33467Hiller H-23D · S/N 61-3201Cancelled Apr 16, 2013 · Registration expired, pending cancellation · Built 1972 · Braniff Education Systems IncN348UBeech 58 · S/N TH-677Cancelled Apr 16, 2013 · Registration expired, pending cancellation · Built 1975 · Taylor John HN761VXCessna 210M · S/N 21062563Cancelled Apr 16, 2013 · Sale reported, pending cancellation · Built 1978N2177MAero Commander 680-F · S/N 680F-1170-89Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1962 · Quibell Ronald LN2472TPiper PA-38-112 · S/N 38-78A0811Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1978 · Dalfort Training IncN2527KPiper PA-38-112 · S/N 38-79A0674Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1979 · Dalfort Training IncN300MGConvair 240-14 · S/N 130Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1949 · Grubbs Aviation IncN1350PPiper PA-23 · S/N 23-399Cancelled Apr 11, 2013 · Registration expired, pending cancellation · Built 1955 · Dalfort Training IncN1750ABeech 36 · S/N E-180Cancelled Apr 11, 2013 · Registration expired, pending cancellation · Built 1969 · Mathai PauloseN18HHinchliffe-Dorman CASSUTT DH2 · S/N 1002Cancelled Apr 11, 2013 · Registration expired, pending cancellation · Built 1978 · Hinchliffe Dorman WN8045FHughes TH-55A · S/N 66-18275Cancelled Apr 11, 2013 · Registration expired, pending cancellation · Los Hermanos De La FronteraN5388SCessna R182 · S/N R18201564Cancelled Apr 9, 2013 · Registration expired, pending cancellation · Built 1980 · Garrison Glen KN800GBBowling George W TIERRA II · S/N 4474Cancelled Apr 2, 2013 · Sale reported, canceledN44599Head Balloons AX8-88 · S/N 109Cancelled Apr 1, 2013 · Sale reported, pending cancellation · Built 1984N6011PPiper PA-24-250 · S/N 24-1105Cancelled Mar 26, 2013 · Revoked, canceled · Built 1959 · Carter Dale FN77MSBeech 65 · S/N LC-86Cancelled Mar 26, 2013 · Sale reported, pending cancellation · Built 1961N290JDConvair T-29B · S/N 272Cancelled Mar 25, 2013 · Sale reported, canceledN3752APiper PA-22-135 · S/N 22-1995Cancelled Mar 25, 2013 · Sale reported, pending cancellation · Built 1954N5527E.A.A. Chapter 244 VP-1 · S/N 200Cancelled Mar 25, 2013 · Sale reported, pending cancellation · Built 1974N9807Grumman Acft ENG Cor-Schweizer G-164A · S/N 1267Cancelled Mar 21, 2013 · Sale reported, canceled · Built 1974N5006UBell 206B · S/N 2489Cancelled Mar 20, 2013 · Registration expired, pending cancellation · Built 1978 · Helicorp CoN9508TCessna 210 · S/N 57308Cancelled Mar 20, 2013 · Sale reported, canceled · Built 1960N4695QCessna 210L · S/N 21059595Cancelled Mar 18, 2013 · Registration expired, pending cancellation · Built 1972 · Wright GeneN5150XLookis Gerald P 206L · S/N JPL002Cancelled Mar 18, 2013 · Sale reported, pending cancellation · Built 1991N9270FHughes 369HS · S/N 1050772SCancelled Mar 18, 2013 · Sale reported, canceled · Built 1975N88HRPiper PA-28R-200 · S/N 28R-7335320Cancelled Mar 11, 2013 · Sale reported, canceled · Built 1973N89752Cessna 152 · S/N 15282852Cancelled Mar 11, 2013 · Sale reported, canceled · Built 1978N89917Cessna 152 · S/N 15282913Cancelled Mar 11, 2013 · Sale reported, canceled · Built 1978N9737UGrumman American Avn. AA-5A · S/N AA5A-0137Cancelled Mar 11, 2013 · Sale reported, pending cancellation · Built 1976N363NBeech 65-A90 · S/N LJ-236Cancelled Mar 7, 2013 · Registration expired, pending cancellation · Built 1967 · 363n King Air LimitedN8713HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1495Cancelled Mar 7, 2013 · Sale reported, canceled · Built 1975N12130Smith Stephen R NIEUPORT 17 C-1 · S/N 00980Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1999N8028LCessna 172H · S/N 17256228Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1967N8502SCessna 182H · S/N 18256602Cancelled Feb 27, 2013 · Sale reported, pending cancellation · Built 1965N1233LConsolidated Aeronautics LAKE LA-4-200 · S/N 733Cancelled Feb 26, 2013 · Sale reported, pending cancellation · Built 1976N7604RBeech B23 · S/N M-1231Cancelled Feb 26, 2013 · Sale reported, canceled · Built 1969N7627YPiper PA-30 · S/N 30-702Cancelled Feb 26, 2013 · Sale reported, canceled · Built 1964N7700KCessna 182K · S/N 18258130Cancelled Feb 26, 2013 · Sale reported, canceled · Built 1967N5773KBeech D95A · S/N TD-583Cancelled Feb 21, 2013 · Revoked, canceled · Built 1964 · N D Aviation IncN735TJCessna 182Q · S/N 18265668Cancelled Feb 21, 2013 · Sale reported, canceled · Built 1977
Back to Dallas, TX