OpenAirDocs.org
Addison, TX

Cancelled registrations · 219

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 = 'ADDISON'
  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.

N755MAMitsubishi MU-2B-35 · S/N 553Cancelled Sep 17, 2010 · Built 1972 · Turbine Aircraft Marketing IncN982XPHawker Beechcraft HAWKER 850XP · S/N 258982Cancelled Aug 30, 2010 · Exported to Pakistan · Built 2008 · Triple S Aviation LLCN45EVMitsubishi MU-2B-20 · S/N 211Cancelled Jul 14, 2010 · Built 1971 · Turbine Aircraft Marketing IncN512DMMitsubishi MU-2B-20 · S/N 155Cancelled Jul 14, 2010 · Built 1969 · Turbine Aircraft Marketing IncN550MAMitsubishi MU-2B-20 · S/N 169Cancelled Jul 14, 2010 · Built 1969 · Turbine Aircraft Marketing IncN688RAMitsubishi MU-2B-36 · S/N 688Cancelled Jul 14, 2010 · Built 1975 · Turbine Aircraft Marketing IncN71DPMitsubishi MU-2B-60 · S/N 1502SACancelled Jul 2, 2010 · Turbine Aircraft Marketing IncN717PSMitsubishi MU-2B-36 · S/N 686Cancelled Jun 2, 2010 · Built 1975 · Turbine Aircraft Marketing IncN152CTCessna 182R · S/N 18268411Cancelled May 21, 2010 · Exported to Malaysia · Built 1984 · Lad (Aviation) IncN777DAPiper PA-31-350 · S/N 31-7552004Cancelled Dec 22, 2009 · Exported to Mexico · Built 1975N701NCBeech 200 · S/N BB324Cancelled Sep 3, 2009 · Exported to Canada · Built 1977 · Omniflight Helicopters IncN38921Bell 205 · S/N 66-1239Cancelled Aug 4, 2009 · Johnson Aviation IncN1995WBeech B19 · S/N MB-678Cancelled Jul 9, 2009 · Registration revoked · Built 1974 · Dallas Skyways IncN3110ECessna 172N · S/N 17271443Cancelled Apr 8, 2009 · Triennial form not returned · Built 1978 · Ameriflyers Of Texas IncN102BXMitsubishi MU-2B-60 · S/N 748SACancelled Mar 19, 2009 · Built 1980 · Turbine Aircraft Marketing IncN703DMMitsubishi MU-2B-20 · S/N 138Cancelled Oct 8, 2008 · Turbine Aircraft MarketingN749DXCessna 750 · S/N 750-0173Cancelled Sep 29, 2008 · Exported to Angola · Built 2002 · Cfs Air LLCN64197Cessna 172P · S/N 17275533Cancelled Jun 2, 2008 · Exported to Philippines · Built 1981 · Ameriflyers Of Texas IncN401FFBritish Aerospace BAE 125 SERIES 1000A · S/N 259021Cancelled May 2, 2008 · Exported to Switzerland · Built 1992 · Interjet IncN4046QCessna 402 · S/N 402-0146Cancelled Nov 21, 2007 · Built 1967 · Gta Air IncN56729Piper PA-32-300 · S/N 32-7440022Cancelled Jul 9, 2007 · Exported to Mexico · Built 1974 · N202w LLCN400SLBell Helicopter Textron 206L-1 · S/N 45235Cancelled Feb 7, 2006 · Triennial form not returned · Built 1979 · Omniflight Helicopters IncN300CPEurocopter Deutschland MBB-BK 117-B2 · S/N 7249Cancelled Apr 6, 2004 · Exported to Germany · Built 1995 · Cfs Air LLCN23WLearjet 25 · S/N 334Cancelled Nov 20, 2002 · Exported to Mexico · Interjet IncN298MAMitsubishi MU-2B-35 · S/N 594Cancelled Aug 20, 2001 · Turbine Aircraft Marketing IncN635DSSocata TBM 700 · S/N 19Cancelled Feb 7, 2001 · Exported to Canada · Bhm Associates IncN800PWBeech C90 · S/N LJ-548Cancelled Nov 8, 2000 · Exported to Mexico · Interjet IncN6701CBeech 76 · S/N ME-280Cancelled Feb 1, 2000 · Triennial form not returned · Ari Ben Aviator IncN2360APiper PA-38-112 · S/N 3878A0653Cancelled Dec 6, 1995 · Triennial form not returned · North Dallas Flight SchoolN5231MBeech B19 · S/N MB883Cancelled Aug 15, 1995 · Triennial form not returned · Ari Ben Aviator IncN119CAConstrucciones Aeronauticas 212-200 · S/N 357Cancelled Jul 24, 1995 · Triennial form not returned · U S Dept Of JusticeN68132Cessna 152 · S/N 15282137Cancelled May 3, 1995 · Second triennial mailing, no response · Griffin Investments Inc DBAN2226LBeech B19 · S/N MB818Cancelled Aug 24, 1994 · Triennial form not returned · Ari Ben Aviator IncN18989Beech B19 · S/N MB870Cancelled Jan 27, 1994 · Triennial form not returned · Ari Ben Aviator IncN5433MBeech 76 · S/N ME35Cancelled Mar 17, 1993 · Triennial form not returned · Ari Ben Aviator IncN2008ABeech 76 · S/N ME67Cancelled Feb 19, 1993 · Triennial form not returned · Cohen Michael EN9343SBeech B19 · S/N MB777Cancelled Jan 25, 1993 · Triennial form not returned · Ari Ben Aviator IncN4815GCessna 172N · S/N 17273363Cancelled Jan 14, 1993 · Exported to Malaysia · Prime Trade IncN3964GCessna 340A · S/N 340A0247Cancelled May 15, 1992 · Exported to Turkey · Interjet IncN9737NMesserschmitt-Bolkow-Blohm BO 105LS A-3 · S/N 2011Cancelled Jan 14, 1992 · Dept Of JusticeN2036WBeech 58 · S/N TH979Cancelled Mar 13, 1991 · Exported to United Kingdom · Interjet IncN761KWCessna T210N · S/N 21062326Cancelled May 21, 1986 · Exported to United Kingdom · C & C Aircraft Services IncN6772ZPiper PA-25 · S/N 252405Cancelled Nov 12, 1985 · Mckamy Aviation IncN6962ZPiper PA-25-235 · S/N 25-2631Cancelled Nov 7, 1985 · Mckamy Avaition IncN8423TCessna 182B · S/N 52323Cancelled Nov 4, 1985 · Exported to Australia · Ted Cooper & Associates IncN13870Piper AEROSTAR 601P · S/N 61P06727963315Cancelled Apr 5, 1984 · Built 1979 · Aviation Enterprises IncN2523LPiper PA-38-112 · S/N 38-79A0752Cancelled Feb 13, 1984 · Administratively canceled · Vari Services IncN2088JBell 206B · S/N 3441Cancelled Jul 22, 1983 · Administratively canceled · Pumpkin Air IncN44KXBeech 99 · S/N U-55Cancelled Sep 29, 1981 · Exported to Canada · Built 1968 · Friendly Aviation IncN4728CCessna 172 · S/N R-172-0233Cancelled Mar 31, 1980 · Johnson Aviation Inc
Back to Addison, TX