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.

N17103Cessna 150L · S/N 15073625Cancelled Jun 5, 2013 · Sale reported, canceled · Built 1972N2577FPiper PA-38-112 · S/N 38-79A0486Cancelled Jun 5, 2013 · Sale reported, canceled · Built 1979N96868Cessna 172P · S/N 17276125Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Built 1984 · Richard Vehorn Enterprises IncN99515Cessna 172P · S/N 17276458Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Built 1985 · Ate Of Texas Inc DBAN121BTCessna 421C · S/N 421C0806Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1979 · Continental Mortgage IncN3819DBeech 76 · S/N ME-392Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1981 · Ari Ben Aviator IncN3850ABeech 77 · S/N WA-247Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1981 · Bolen Max EN5429BCessna 182 · S/N 33429Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1956 · Rouillard Jerry MN6782YPiper PA-23-250 · S/N 27-4118Cancelled May 31, 2013 · Sale reported, canceled · Built 1968N702TSBeech M35 · S/N D-6479Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1960 · Crim Michael LN9629XCessna 210B · S/N 21057929Cancelled May 23, 2013 · Registration expired, pending cancellation · Metro Optics IncN9674UGrumman American Avn. AA-1C · S/N AA1C0093Cancelled May 23, 2013 · Registration expired, pending cancellation · Lee J KennethN92252Cessna 182N · S/N 18260112Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1969 · Aerobanc Of America IncN9240TPiper PA-38-112 · S/N 38-78A0288Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1978 · Stramel Aviation IncN9400CPiper PA-28R-201 · S/N 28R-7837196Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1978 · Medal Leasing CompanyN89100Cessna 140 · S/N 8104Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1946 · Leonard James RN89892Cessna 152 · S/N 15282905Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1978 · Redding PatN905CLDouglas DC-8-31 · S/N 45274Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1960 · Parrish Frank JrN8853LGrumman American Avn. AA-1B · S/N AA1B-0353Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1974 · Seaton Norman NN88659Cessna 404 · S/N 404-0208Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1977 · Coltharp James HN81MCGates Lear Jet 24F · S/N 344Cancelled May 14, 2013 · Registration expired, pending cancellation · Lisle Aircraft IncN835CBeech D55 · S/N TE-588Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1968 · Cohlmia Kay DBAN8392QCessna U206F · S/N U20603253Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1976 · Kennemur B JN8RJPiper PA-28-180 · S/N 28-7305528Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1973 · Marx Irvin H JrN5617KBeech 95-B55 (T42A) · S/N TC-606Cancelled May 10, 2013 · Sale reported, canceled · Built 1964N3722GBalloon Works FIREFLY 7-B · S/N F7B-087Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1983 · Braasch Steven MarkN76541Cessna 140 · S/N 10977Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1946 · Bell Paul JN7765Bell-K-Copter 47G · S/N K7015Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1970 · Noel HaroldN7774Pinwheel HELICOPTER · S/N RH-1Cancelled May 9, 2013 · Registration expired, pending cancellation · Comtec Aeronautics IncN7800NPiper PA-28-180 · S/N 28-5250Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1968 · Woodruff Ralph SN7917XCessna 172B · S/N 17248417Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1961 · Horton Laine AN7929ECessna 150 · S/N 17729Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1959 · Dalfort Training L PN741BBeech A35 · S/N D-1747Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1948 · Pate Charles R IIIN74316Bellanca 14-13-2 · S/N 1429Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1946 · Williams DavidN7602RCessna R182 · S/N R18200655Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1978 · Poynor C BN7327BBeech E35 · S/N D-3790Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1954 · Robinson Bernard RN732RNCessna T210M · S/N 21061715Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1977 · Dayton Edward PN150PCCessna 150H · S/N 15067751Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1967 · Mann Tracy AN68000Douglas DC3C · S/N 13847Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1943 · Garrison RoyN67069Convair 440 · S/N 488Cancelled May 1, 2013 · Registration expired, pending cancellation · Air D Aircraft Sales IncN3628GBell 47G · S/N 808Cancelled Apr 30, 2013 · Sale reported, pending cancellation · Built 1960N6606SCessna 150H · S/N 15067406Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1967 · Mcclellan W MN6631DBeech C23 · S/N M-2189Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1979 · Chaparral Aviation IncN6670XCessna 210A · S/N 21057670Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1961 · Dallas Independent School DistrictN7168JSeveren Scott QUICKSILVER MX 2A · S/N 2043Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Theriot Oswald AN92FZMair F N LITTLE TOOT · S/N FM-2Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1998 · Bell James R JrN6318YCessna T210N · S/N 21064335Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1981 · Bland James EN6320APiper PA-38-112 · S/N 38-78A0384Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1978 · Richardson Dennis KN6369LAmerican AA-1A · S/N AA1A-0369Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1972 · Probst Daniel TN63900Piper PA-23-250 · S/N 27-7854046Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1977 · P T A Sales Inc
Back to Dallas, TX