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.

N3935GCessna TU206C · S/N U206-0935Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 1967 · Industrial Flight ServiceN4174PRobinson Helicopter R44 II · S/N 12512Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 2008 · Gillian Blue Gp LLCN3220QCessna 401 · S/N 401-0020Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1967 · Telesis Equipment IncN405TECessna 401 · S/N 401-0121Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1967 · Telesis Equipment IncN406TECessna 402B · S/N 402B1366Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1978 · Telesis Equipment IncN409TECessna 401A · S/N 401A0118Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1969 · Telesis Equipment IncN8736YPiper PA-30 · S/N 30-1890Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1969 · Spartan Aviation IncN211VVIndus T-211 THORPEDO · S/N 017SCancelled Jan 16, 2018 · Registration expired, pending cancellation · Built 2005 · Indus Aviation IncN211ZZIndus T-211 THORPEDO · S/N 0803D0353Cancelled Jan 16, 2018 · Registration expired, pending cancellation · Indus Aviation IncN1248HPiper PA-28-181 · S/N 28-7790299Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Billion Air IncN12TXDassault-Breguet FALCON 10 · S/N 90Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Twelve Tx LLCN137VGeneva Aerospace DAKOTA · S/N 013Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Vought Aircraft Industries IncN799MDBeech 100 · S/N B8Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 1969 · Double D Aircraft Sales LLCN720JRBoeing 720-047B · S/N 18451Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1962 · Jar Aircraft ServicesN347SWBoeing 737-3H4 · S/N 24374Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Built 1989 · Southwest Airlines CoN350SWBoeing 737-3H4 · S/N 24409Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Built 1989 · Southwest Airlines CoN334SWBoeing 737-3H4 · S/N 23938Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1988 · Southwest Airlines CoN335SWBoeing 737-3H4 · S/N 23939Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1988 · Southwest Airlines CoN586WFFreefly Systems ALTA · S/N 2184960513Cancelled Dec 18, 2017 · Fleishman Samuel EN874BABombardier BD-700-1A11 · S/N 9693Cancelled Dec 13, 2017 · Exported to Bulgaria · Bombardier Aerospace CorpN897CWBritish Aerospace BAE 125 SERIES 800A · S/N 258077Cancelled Dec 13, 2017 · Redlich Enterprises LLCN2837MPiper PA-12 · S/N 12-1274Cancelled Nov 22, 2017 · Revoked, canceled · Built 1946 · Richardson Virgil Y JrN89975Cessna 140 · S/N 9027Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · White Rock Flg ClubN99359Engineering & Research 415-C · S/N 1982Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Wood Donald CN645SWBoeing 737-3H4 · S/N 28330Cancelled Nov 20, 2017 · Exported to Nigeria · Built 1997 · Southwest Airlines CoN646SWBoeing 737-3H4 · S/N 28331Cancelled Nov 20, 2017 · Exported to Nigeria · Built 1997 · Southwest Airlines CoN4114CStinson 108 · S/N 1085114Cancelled Nov 18, 2017 · Revoked, canceled · Built 1948 · Mastin Robert HN41615Culver LFA · S/N 374Cancelled Nov 18, 2017 · Revoked, canceled · Built 1941 · Mitchell Fred WN650SWBoeing 737-3H4 · S/N 27720Cancelled Nov 6, 2017 · Exported to Nigeria · Built 1997 · Southwest Airlines CoN1766BBoeing A75N1(PT17) · S/N 756682Cancelled Oct 30, 2017 · Revoked, canceled · Anderson And Creed Spraying SvcN1753BNorth American F-51D · S/N 12239932Cancelled Oct 28, 2017 · Revoked, canceled · Dal AirN3349BPiper PA-22-135 · S/N 22-2164Cancelled Oct 28, 2017 · Revoked, canceled · Built 1954 · Hall J MN84526Aeronca 7AC · S/N 7AC3230Cancelled Oct 28, 2017 · Revoked, pending cancellation · Built 1946 · January WayneN343SWBoeing 737-3H4 · S/N 24151Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Built 1989 · Southwest Airlines CoN504SWBoeing 737-5H4 · S/N 24181Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Built 1990 · Southwest Airlines CoN505SWBoeing 737-5H4 · S/N 24182Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Built 1990 · Southwest Airlines CoN303SWBoeing 737-3H4 · S/N 22943Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Built 1985 · Southwest Airlines CoN328SWBoeing 737-3H4 · S/N 23692Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Built 1988 · Southwest Airlines CoN342SWBoeing 737-3H4 · S/N 24133Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Built 1989 · Southwest Airlines CoN344SWBoeing 737-3H4 · S/N 24152Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Built 1989 · Southwest Airlines CoN6501QCessna 152 · S/N 15285264Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Built 1981 · Six Ten Ventures LLCN676SWBoeing 737-3A4 · S/N 23288Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Built 2000 · Southwest Airlines CoN2395QBeech 23 · S/N M-474Cancelled Oct 6, 2017 · Registration expired, pending cancellation · Built 1963 · Caylor Michael CN401JMCessna 210D · S/N 21058348Cancelled Oct 6, 2017 · Registration expired, pending cancellation · Built 1964 · Leyine Henry FN329SWBoeing 737-3H4 · S/N 23693Cancelled Sep 26, 2017 · Registration expired, pending cancellation · Built 1988 · Southwest Airlines CoN313SWBoeing 737-3H4 · S/N 23335Cancelled Sep 8, 2017 · Registration expired, pending cancellation · Built 1986 · Southwest Airlines CoN351SWBoeing 737-3H4 · S/N 24572Cancelled Sep 8, 2017 · Registration expired, pending cancellation · Built 1989 · Southwest Airlines CoN692SWBoeing 737-3T5 · S/N 23062Cancelled Sep 7, 2017 · Registration expired, pending cancellation · Built 1985 · Southwest Airlines CoN69JNRockwell International NA-265-80 · S/N 380-65Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 1978 · Compass Acquisitions & Development IncN1318CPiper PA-22-135 · S/N 22-1114Cancelled Jul 17, 2017 · Registration expired, pending cancellation · Built 1953 · Dallas Independent School District
Back to Dallas, TX