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.

N46745Ryan Aeronautical ST3KR · S/N 2131Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1942 · Neuzil Carl DN5893JBeech 35-C33 · S/N CD-921Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1965 · Thompson John SN618DRBostic Ron THORP T-18 · S/N 1223Cancelled May 19, 2015 · Registration expired, pending cancellation · Bostic RonN62788Piper PA-23-250 · S/N 27-7754025Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1976 · Oler Gayle EN2847KLuscombe 8A · S/N 5574Cancelled May 13, 2015 · Sale reported, canceled · Built 1947N3584RBeech A23 · S/N M760Cancelled May 13, 2015 · Sale reported, canceledN8497ZCessna 210-5A(205A) · S/N 205-0497Cancelled May 12, 2015 · Sale reported, canceled · Built 1964N503JRCessna 152 · S/N 15280223Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1977 · Jar Aircraft Services IncN6099GCessna 150K · S/N 15071599Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1969 · Oconner MarkN83ECessna T337G · S/N P3370141Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1973 · Planes Unlimited IncN9801JCessna A150M · S/N A1500610Cancelled May 11, 2015 · Sale reported, canceled · Built 1975N1048ZBeech C-45H · S/N AF-203Cancelled May 8, 2015 · Registration expired, pending cancellation · Built 1951 · Dallas Independent School DistrictN987NFerrel J D TEMPLE SPORTSMAN · S/N 107RCancelled May 7, 2015 · Registration expired, pending cancellation · Built 1990 · Frontiers Of Flight MuseumN682SWBoeing 737-3Y0 · S/N 23496Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1986 · Southwest Airlines CoN18111Douglas DC3 · S/N 1983Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1945 · Mercantile National Bank At DallasN41TMPiper PA-34-200T · S/N 34-8070017Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1979 · Gregory M LN7103ZPiper PA-25-235 · S/N 25-2897Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1964 · Rickman Albert CN6291QCessna 401A · S/N 401A0091Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1969 · Bank One Texas NaN4382DPiper PA-28-181 · S/N 28-8590015Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Spratt ReaneeN4826JBeech 95-C55 · S/N TE-330Cancelled Apr 27, 2015 · Registration expired, pending cancellation · Built 1967 · Cohlmia K E DBAN2191VPiper PA-34-200T · S/N 34-7970166Cancelled Apr 24, 2015 · Registration expired, pending cancellation · Built 1979 · Avimach Trade CorporationN3504KPiper J3C-65 · S/N 22194Cancelled Jan 27, 2015 · Sale reported, canceled · Built 1946N2571VCessna 170 · S/N 18109Cancelled Jan 8, 2015 · Revoked, canceled · Built 1948 · Sandford O BN1771DCessna 170B · S/N 20214Cancelled Dec 22, 2014 · Revoked, canceled · Built 1952 · Rohe Gordon SN310VRCessna 310D · S/N 39100Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1960 · J A R Aircraft Services IncN5058FFairchild Hiller FH-1100 · S/N 218Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1970 · Morris LarryN1353GRussell John R PAZMANY PL-4A · S/N 298Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Built 1981 · Russell John RN7097PPiper PA-24-250 · S/N 24-2252Cancelled Dec 2, 2014 · Revoked, canceled · Built 1960 · Sellars RodneyN211ERIndus T-211 THORPEDO · S/N 0803D0373Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Indus Aviation IncN211GGIndus T-211 THORPEDO · S/N 0802D0323Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Indus Aviation IncN211PRIndus T-211 THORPEDO · S/N 0805D0403Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Indus Aviaiton IncN211SXIndus T-211 THORPEDO · S/N 0803D0343Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Indus Aviation IncN211UIndus T-211 THORPEDO · S/N 0804D0393Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Indus Aviation IncN211XSIndus T-211 THORPEDO · S/N 0802D0333Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Indus Aviation IncN800DHFokker F.28 MK4000 · S/N 11176Cancelled Nov 25, 2014 · Registration expired, pending cancellation · Ddh Aircraft CorpN829NLGrumman G-1159 · S/N 128Cancelled Nov 25, 2014 · Registration expired, pending cancellation · Bondstone CorpN9582ACessna 170A · S/N 19143Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1949 · Jendruck Gary LN211KKIndus T-211 THORPEDO · S/N 0803D0363Cancelled Nov 21, 2014 · Registration expired, pending cancellation · Indus Aviation IncN544WThorp T-211 · S/N 1Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1946 · Indus Aviation IncN89945Cessna 152 · S/N 15282923Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1978 · West Air II IncN679AABoeing 737-3A4 · S/N 23291Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1986 · Southwest Airlines CoN7776YPiper PA-30 · S/N 30-862Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1965 · Graham Bobby DN778CBBarry-Curtis VARIEZE · S/N 1779Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1981 · Voris MarshallN7999DBeech H35 · S/N D-5286Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1957 · Page LarryN7348ACessna 172 · S/N 29448Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1956 · Geisinger Smith Mays Aviation IncN74409Bellanca 14-13-2 · S/N 1522Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1947 · Cass Walter MalcolmN6815ZCessna 414A · S/N 414A0648Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1981 · Davis Wirt IIIN7029YPiper PA-30 · S/N 30-30Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1963 · Ivy James EN6511ABensen B-8F · S/N CF101Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1966 · Pyland Jack W IVN8204APiper PA-34-220T · S/N 34-8233143Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Pointer Martha J
Back to Dallas, TX