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.

N15109Piper PA-34-200 · S/N 34-7350020Cancelled Aug 5, 2013 · Sale reported, canceled · Built 1972N179DDBeech F33A · S/N CE-743Cancelled Aug 5, 2013 · Sale reported, canceled · Built 1977N5916VPiper PA-28-161 · S/N 28-7716216Cancelled Aug 5, 2013 · Sale reported, canceled · Built 1977N21312Piper PA-32RT-300T · S/N 32R7887199Cancelled Jul 30, 2013 · Sale reported, canceled · Built 1978N2493APiper PA-38-112 · S/N 38-78A0713Cancelled Jul 30, 2013 · Sale reported, canceled · Built 1978N301TEPiper PA-32-300 · S/N 32-40216Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1967 · Telesis Equipment IncN5680TCessna 172E · S/N 17251580Cancelled Jul 30, 2013 · Sale reported, canceledN693PGSwearingen SA-226T · S/N T207Cancelled Jul 30, 2013 · Sale reported, canceled · Built 1971N14BAPiper PA-32R-301T · S/N 32R-8329033Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 1983 · Psc Air IncN97441Stinson 108 · S/N 108-441Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 1946 · Horton David RN3814GCessna 310R · S/N 310R0917Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Built 1977 · Mid-America Airways IncN3166PPiper PA-23 · S/N 23-1099Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Built 1957 · Jones Carl M DBAN2230FCessna 310L · S/N 310L-0030Cancelled Jul 16, 2013 · Sale reported, canceled · Built 1966N56FCChristen Industries PITTS S-2B · S/N 5207Cancelled Jul 16, 2013 · Sale reported, canceled · Built 1991N850TWBoeing 727-31 · S/N 18569Cancelled Jul 16, 2013 · Sale reported, canceled · Built 1954N990SABeech 65-A90 · S/N LJ-261Cancelled Jul 16, 2013 · Sale reported, canceled · Built 1967N5095YPiper PA-23-250 · S/N 27-2119Cancelled Jul 15, 2013 · Sale reported, canceled · Built 1962N663VBeech M35 · S/N D-6397Cancelled Jul 15, 2013 · Sale reported, canceled · Built 1960N730SHRobinson Helicopter R22 BETA · S/N 1730Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1991N368SRCirrus Design SR22 · S/N 2731Cancelled Jul 10, 2013 · Exported to Canada · Built 2007 · Great Gulf CorpN441KCKuehner Gregory A AVIAT EAGLE II · S/N 0001Cancelled Jul 10, 2013 · Sale reported, canceled · Built 1997N7UWBell TH-1L · S/N 157838Cancelled Jul 10, 2013 · Sale reported, canceled · Built 1970N3829DBeech 77 · S/N WA-229Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1981 · Chaparral Aviation IncN4632HPiper PA-17 · S/N 17-47Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1948 · Gentry Eugene FN603TESmith AEROSTAR 600 · S/N 60-0320-118Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1976 · Telesis Equipment IncN6608VBellanca 17-30A · S/N 30278Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1970 · Martin Heritage CorporationN6819TCessna 310D · S/N 39119Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1960 · H And H Aircraft CorpN731NJCessna P210N · S/N P21000505Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1980 · Hannon Joe EN4386CBuckeye SKY HAWK · S/N 6186Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 2000 · Lopez StevenN57516Taylorcraft DCO-65 · S/N 5230Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1943 · Dallas Independent School DistrictN217JMeyer LITTLE TOOT · S/N JDM-3Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1968N23035Cessna 150H · S/N 15068693Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1968N6841SAero Commander 680 · S/N 680-351-41Cancelled Jun 27, 2013 · Registration expired, pending cancellation · Built 1956 · Dalfort Training IncN89841Cessna 152 · S/N 15282887Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1978N9978Grumman Acft ENG Cor-Schweizer G-164A · S/N 1377Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1974N3725JCessna 150G · S/N 15065025Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1966 · Dallas Independent School DistrictN411PMCessna 411A · S/N 411-0297Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Harrell Robert EN501JRCessna 150G · S/N 15065928Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1966 · Jar Aircraft Services IncN697AADillard William JR FALCON-XP · S/N 600143Cancelled Jun 14, 2013 · Registration expired, pending cancellation · Dillard William JrN7727YPiper PA-30 · S/N 30-816Cancelled Jun 14, 2013 · Sale reported, canceled · Built 1965N5433JCessna 421B · S/N 421B0892Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Built 1975 · Blesse George BN43LBBradshaw Larry Charles SONERAI II L · S/N 771-2LCancelled Jun 12, 2013 · Registration expired, pending cancellation · Built 1986 · Bradshaw Larry CN22093Cessna 150H · S/N 15068060Cancelled Jun 11, 2013 · Sale reported, pending cancellation · Built 1968N2857JRheinhardt B-8M · S/N 1576Cancelled Jun 11, 2013 · Sale reported, canceled · Built 1966N6625YPiper PA-23-250 · S/N 27-3932Cancelled Jun 10, 2013 · Sale reported, canceled · Built 1968N7890WPiper PA-28-180 · S/N 28-1915Cancelled Jun 10, 2013 · Sale reported, canceled · Built 1964N22DLLewis Don Wayne KITFOX MODEL 2 · S/N 377Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1991 · Lewis Don WN6121JPiper PA-28-140 · S/N 28-7625220Cancelled Jun 7, 2013 · Sale reported, canceled · Built 1976N770JWCessna 421C · S/N 421C-1052Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1981 · Shaw S EN111NFIsrael Aircraft Industries 1123 · S/N 168Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Built 1973 · Martin Bruce Q
Back to Dallas, TX