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.

N518LWInfinity C-912S · S/N IPP8-372Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Bennett MontgomeryN8896CPiper PA-22 · S/N 22-1480Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1953 · Jly Aviation IncN667RTJohnson Ben RV-6A · S/N 60032Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 2001 · Johnson Ben AN2725VCessna 177RG · S/N 177RG0672Cancelled May 31, 2017 · Registration expired, pending cancellation · Built 1975 · Boyles George AN80556Globe GC-1B · S/N 59Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1946 · Jewell Duane WN309SWBoeing 737-3H4 · S/N 22948Cancelled May 22, 2017 · Registration expired, pending cancellation · Built 1985 · Southwest Airlines CoN3407BBeech D35 · S/N D-3645Cancelled May 22, 2017 · Registration expired, pending cancellation · Built 1953 · Weimar Gerald JN260MSSiai-Marchetti F.260 · S/N 3-76Cancelled May 15, 2017 · Registration expired, pending cancellation · Stevens MauriceN4061BBellanca 17-30A · S/N 76-30820Cancelled May 15, 2017 · Registration expired, pending cancellation · Built 1976 · Lanagan J AN91NAGrumman American Avn. G-1159 · S/N 198Cancelled May 10, 2017 · Built 1977 · Rbr Maintenance IncN5682TCessna 172E · S/N 17251582Cancelled Apr 19, 2017 · Registration expired, pending cancellation · Built 1964 · Gartside LiamN113SXAero Vodochody L29 · S/N 294899Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Wells John BN4671SMamzer MAMZER 1 · S/N 10-01Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1964 · Spangler Thomas MN61392Piper PA-31-350 · S/N 31-7552106Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1975 · Martin Bruce QN48MDSmith AEROSTAR 601P · S/N 61P-0492-201Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Wright MichaelN698BCEmbraer Empresa Brasileira De ERJ 190-100 IGW · S/N 19000019Cancelled Mar 28, 2017 · Sale reportedN504JRCessna 152 · S/N 15282563Cancelled Mar 24, 2017 · Registration expired, pending cancellation · Built 1978 · Jar Aircraft Services IncN4508UCessna 150D · S/N 15060508Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1964 · Sartain Thomas A SrN506JRCessna TP206B · S/N U206-0866Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1967 · Jar Aircraft Services IncN7923SBell 47G-3B-1 · S/N 6594Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1966 · Akana Francis DBAN509JRPiper PA-34-200T · S/N 34-7770149Cancelled Mar 6, 2017 · Registration expired, pending cancellation · Built 1977 · Jar Aircraft Services IncN408TECessna 401 · S/N 401-0269Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Built 1968 · Telesis Equipment IncN673ALCessna 152 · S/N 15281743Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1978 · Aviation Maintenance Training IncN8326SPiper PA-28RT-201 · S/N 28R-8118052Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1981 · Bockbrader Clayton EN9898CNorth American T-28A · S/N 49-1517ACancelled Feb 14, 2017 · Revoked, canceled · Built 1949 · Griffith Lee RN97657Stinson 108 · S/N 108657Cancelled Feb 13, 2017 · Revoked, canceled · Built 1946 · Kammerer Lester LN9852ZBeech C-45H · S/N AF-49Cancelled Feb 13, 2017 · Revoked, canceled · Built 1951 · Allred J VN6885ACessna 172 · S/N 28985Cancelled Feb 4, 2017 · Revoked, canceled · Built 1956 · French Clarence T DrN7286PPiper PA-24-250 · S/N 24-2464Cancelled Feb 4, 2017 · Revoked, canceled · Built 1961 · Hall J MN730EGLockheed PV-1 · S/N 5274Cancelled Feb 4, 2017 · Revoked, canceled · Built 1948 · Dallas ChapterN7411KPiper PA-20 · S/N 20-321Cancelled Feb 4, 2017 · Revoked, canceled · Built 1950 · Mcdonald Clarence JN74YLockheed 18-56 · S/N 2460Cancelled Feb 4, 2017 · Revoked, canceled · Built 1943 · Mallco Acft IncN80206Beech D18S · S/N A-183Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Hall J MN8149KStinson 108-1 · S/N 108-1149Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Oxford Sherman DN693BCEmbraer Empresa Brasileira De ERJ 190-100 IGW · S/N 19000018Cancelled Jan 5, 2017 · Beautech Power Systems LLCN384BBGulfstream Aerospace G-1159A · S/N 496Cancelled Oct 20, 2016 · Built 1987 · 384bb Aviation LLCN16777Ahrens AR 124 · S/N 124V1Cancelled Sep 9, 2016 · Sale reported, canceled · Built 1974N100CZColt Balloons 77A · S/N 093Cancelled Aug 17, 2016 · Third renewal notice · Built 1980 · Herbert H Adcock IncN602TEPiper AEROSTAR 601 · S/N 6105837962134Cancelled Aug 17, 2016 · Third renewal notice · Built 1978 · Danna Charlie V JrN34KWBeech A45 · S/N G-757Cancelled Aug 2, 2016 · Exported to Austria · Built 1955 · Shaw Lewis W IIN65494Beech AT-11 · S/N 3258Cancelled Jul 19, 2016 · Built 1942 · Commemorative Air ForceN7058ZRobinson Helicopter R22 BETA · S/N 2896Cancelled Jul 13, 2016 · Built 1998 · Aarow Aircraft Leasing LLCN129WAGulfstream Aerospace G1159B · S/N 009Cancelled Jan 20, 2016 · Built 1967 · Bondstone CorpN188JSGulfstream American G-1159 · S/N 29Cancelled Jan 20, 2016 · Second renewal notice · Built 1968 · Bondstone CorpN200ELGrumman G-1159 · S/N 71Cancelled Jan 20, 2016 · Built 1969 · Bondstone CorpN99PDGulfstream American G-1159A · S/N 314Cancelled Jan 20, 2016 · Built 1980 · Sowell Hb IncN6735Sikorsky UH-19D · S/N 54-1416Cancelled Oct 13, 2015 · Built 1971 · Commemorative Air ForceN836ASBombardier CL-600-2B19 · S/N 7263Cancelled Jul 7, 2015 · Sale reported · Built 1998N152YRCessna 152 · S/N 15283601Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1979 · J A R Aircraft Services IncN230EMBell 230 · S/N 23011Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1993 · Omniflight Inc
Back to Dallas, TX