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.

N5182Scheutzow B · S/N 103Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1970 · Mosley Lonnie GN5269CBeech B35 · S/N D-2663Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1950 · Moore Alger IIIN5524ZPiper PA-22-108 · S/N 22-9312Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1962 · Jones George C JrN13RLLindsey CA-65A · S/N 1Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1978 · Lindsey Ricky AN4400EHawker Siddeley DH.125-1A · S/N 25026Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1965 · Ransom Aircraft IncN4808ZPiper PA-22-108 · S/N 22-8377Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1961 · Clough A MichaelN3528QQuicksilver GT-400 · S/N 2801462Cancelled Oct 8, 2014 · Built 2002 · Hubka TravisN3411Convair 640-340D · S/N 31Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1952 · Sedalia Marshall Boonvle Stg LineN34530Aeronca 65-TC · S/N C15181Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1941 · Henthorn George DN302SWBoeing 737-3H4 · S/N 22942Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1984 · Southwest Airlines CoN26075Piper PA-28-161 · S/N 28-8516087Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1985 · Thacker Blaine LN2700SCessna 414A · S/N 414A0607Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1980 · Micuda John KN2755HAero Commander 680T · S/N 1628Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1966 · Astro Wing Airlines IncN281FPLearjet 24D · S/N 281Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1973 · Valhi IncN28364Douglas DC3A · S/N 4108Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1941 · Pan-Southern Air Transport Inc.N2325HBalloon Works FIREFLY 7 · S/N 7739Cancelled Sep 19, 2014 · Registration expired, pending cancellation · Built 1978 · Fantasy Flights IncN23384Piper PA-38-112 · S/N 38-81A0120Cancelled Sep 19, 2014 · Registration expired, pending cancellation · Built 1981 · B & W InvestmentsN2381HErcoupe 415-C · S/N 3006Cancelled Sep 19, 2014 · Registration expired, pending cancellation · Built 1946 · Braun Lea ON555SGLockheed 1329 · S/N 5090Cancelled Sep 16, 2014 · Registration expired, pending cancellation · Built 1966 · United Ccm CorpN17GACessna 402 · S/N 402-0139Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1967 · Mcdonald John AN29NRAerovodochody L-29 DELFIN · S/N 194144Cancelled Sep 9, 2014 · First renewal notice · Built 1971 · Cnr Aircraft IncN12KVAero Commander 680T · S/N 1675-58Cancelled Sep 3, 2014 · Registration expired, pending cancellation · Built 1966 · Mathews Robert AN69147North American AT-6D · S/N 88-14152Cancelled Sep 3, 2014 · Revoked, canceled · Built 1943 · Wisner William HN900ADHawker Siddeley BH.125-400A · S/N NA769Cancelled Aug 28, 2014 · Registration expired, pending cancellation · T Graham Capital LLCN961TXAviat A-1C-180 · S/N 3078Cancelled Nov 25, 2013 · Exported to Canada · Built 2010 · Larrydavid Aviation LLCN7198URobinson Helicopter R22 BETA · S/N 3251Cancelled Nov 13, 2013 · Registration expired, pending cancellation · Built 2001 · Holzsweig Leon GN5470VBeech A36 · S/N E-1712Cancelled Nov 8, 2013 · Registration expired, pending cancellation · Built 1980 · Moose Ranch IncN604TESmith AEROSTAR 600 · S/N 60-0206-091Cancelled Nov 8, 2013 · Registration expired, pending cancellation · Built 1975 · Telesis Equipment IncN6542JCessna 172N · S/N 17273887Cancelled Nov 8, 2013 · Registration expired, pending cancellation · Built 1980 · Ate Of Texas IncN8096FCessna 150F · S/N 15064196Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Built 1966 · Hutchinson MichaelN304FWPiper PA-32R-301T · S/N 32R-8129063Cancelled Oct 25, 2013 · Registration expired, pending cancellation · Mattson C WN37620Balloon Works FIREFLY 7 · S/N F7-154Cancelled Oct 25, 2013 · Registration expired, pending cancellation · Built 1984 · Beighley Sidney L IIIN311SWBoeing 737-3H4 · S/N 23333Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1986 · Southwest Airline CoN507JRCessna 172N · S/N 17270378Cancelled Oct 18, 2013 · Registration expired, pending cancellation · Built 1978 · Jar Aircraft Services IncN1024VCessna 206H · S/N 20608170Cancelled Sep 30, 2013 · Exported to Bolivia · Built 2001 · Morales RobertN403TECessna 401 · S/N 401-0008Cancelled Sep 27, 2013 · Registration expired, pending cancellation · Built 1966 · Telesis Equipment IncN7686CNorth American T-28A · S/N 49-1687Cancelled Sep 26, 2013 · Revoked, canceled · Built 1958 · Graham Elliott Associates IncN1408PPiper PA-23 · S/N 23-463Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 1956 · Dallas Independent School DistrictN56BLGreer William B RUTAN VARIEZE · S/N 1425Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Greer William BN7RJHandley Page HP-137 MK1 · S/N 231Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1969 · Jetstream IncN80RHHuffman Raymond A BUSHBY MUSTANG II · S/N 494Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1981 · Oconner Mack AllenN83WBBowman Willis F AMERICAN EAGLET · S/N 0402Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1983 · Davis Walker BN129DMLearjet 24B · S/N 187Cancelled Sep 12, 2013 · Registration expired, pending cancellation · B B Barr Enterprises IncN99GSAero Commander 1121 · S/N 31Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1965 · Shaw Stanley EN8485XCessna 172C · S/N 17248985Cancelled Sep 10, 2013 · Registration expired, pending cancellation · Built 1961 · Bolen Max EN7037SCessna 150H · S/N 15067737Cancelled Aug 29, 2013 · Revoked, pending cancellation · Built 1967 · Meldin Henry Key JrN24MLLyeth SHOESTRING K-10 · S/N 27Cancelled Aug 27, 2013 · Sale reported, canceled · Built 1972N2547SSouthern Powered Parachutes CONDOR · S/N 6140719Cancelled Aug 27, 2013 · Sale reported, canceled · Built 2007N8793BCessna 172 · S/N 36493Cancelled Aug 27, 2013 · Sale reported, canceled · Built 1957N9418NPiper PA-28R-200 · S/N 28R-35130Cancelled Aug 27, 2013 · Sale reported, canceled · Built 1969
Back to Dallas, TX