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.

N151WWLearjet 24 · S/N 24-170Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Built 1968 · Addison Aviation Services IncN32GTBell Helicopter Textron 206L-1 · S/N 45663Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1981 · Execucopter IncN7873YPiper PA-30 · S/N 30-957Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1965 · R S Lease CoN51SFHawker SEA FURY TMK 20 · S/N ES3613Cancelled Apr 25, 2013 · Exported to Germany · Built 1948 · Cavanaugh Flight MuseumN3194MBell 222U · S/N 47538Cancelled Mar 7, 2013 · Sale reported, pending cancellation · Built 1985N117MMBB BK 117 A-3 · S/N 7023Cancelled Feb 22, 2013 · Omniflight Helicopters IncN731DWCessna A188B · S/N 18802824TCancelled Feb 21, 2013 · Sale reported, canceledN500XXMitsubishi MU-2B-25 · S/N 250Cancelled Feb 5, 2013 · Built 1975 · Turbine Aircraft Marketing IncN305CWMitsubishi MU-2B-36 · S/N 667Cancelled Dec 18, 2012 · Registration pending, canceled · Built 1975N5013MBeech V35B · S/N D-10139Cancelled Dec 10, 2012 · Sale reported, canceled · Built 1978N8444NBeech A65 · S/N LC-289Cancelled Nov 13, 2012 · Sale reported, pending cancellation · Built 1968N31WMMitsubishi MU-2B · S/N 031Cancelled Oct 25, 2012 · Built 1967 · Turbine Aircraft Marketing IncN30RRMitsubishi MU-2B-25 · S/N 263Cancelled Oct 1, 2012 · Built 1973 · Turbine Aircraft Marketing IncN5925SBeech 95-C55 · S/N TE-122Cancelled Sep 27, 2012 · Sale reported, pending cancellation · Built 1966N228MDHawker Siddeley HS-125-600A · S/N 256037Cancelled Aug 30, 2012 · Registration pending, canceled · Built 1976N55VMConvair 240 · S/N 3Cancelled Aug 23, 2012 · Revoked, canceled · Built 1947 · L & J CoN4688Beech E50 · S/N EH-6Cancelled Aug 22, 2012 · Sale reported, pending cancellation · Built 1956N311KBBeech A200 · S/N BD-003Cancelled Jun 18, 2012 · Expired dealer · Built 1973 · Aquila Aviation LLCN637BBeech A200 · S/N BC-62Cancelled Jun 18, 2012 · Expired dealer · Built 1978 · Aquila Aviation LLCN344KLMitsubishi MU-2B-25 · S/N 257Cancelled Jun 15, 2012 · Built 1973 · Turbine Aircraft Marketing IncN154WCMitsubishi MU-2B-30 · S/N 509Cancelled Apr 17, 2012 · Turbine Aircraft Marketing IncN4065DMitsubishi MU-2B-36 · S/N 660Cancelled Apr 9, 2012 · Turbine Aircraft Marketing IncN940MAMitsubishi MU-2B-35 · S/N 615Cancelled Apr 9, 2012 · Built 1973 · Turbine Aircraft Marketing IncN450MAMitsubishi MU-2B-35 · S/N 587Cancelled Apr 5, 2012 · Built 1973 · Turbine Aircraft Marketing IncN580AFMitsubishi MU-2B-35 · S/N 580Cancelled Apr 5, 2012 · Built 1973 · Turbine Aircraft Marketing IncN3504LCessna 172S · S/N 172S8853Cancelled Mar 22, 2012 · Sale reportedN37KKMitsubishi MU-2B-35 · S/N 588Cancelled Feb 14, 2012 · Built 1985 · Turbine Aircraft Marketing IncN51567Maule M-5-210C · S/N 6022CCancelled Jan 20, 2012 · Exported to Italy · Built 1974 · Interjet IncN69RPBeech D55 · S/N TE-766Cancelled Dec 1, 2011 · Third renewal notice · Built 1969 · Gta Air IncN172RQCessna 172P · S/N 172-76324Cancelled Nov 28, 2011 · Exported to Panama · Built 1985 · Miguez EricN6KFMitsubishi MU-2B-36 · S/N 659Cancelled Aug 4, 2011 · Built 1975 · Turbine Aircraft Marketing IncN132BKMitsubishi MU-2B-60 · S/N 1529 S.A.Cancelled Aug 3, 2011 · Built 1981 · Turbine Aircraft Marketing IncN3260QCessna 401 · S/N 401-0060Cancelled Aug 3, 2011 · Third renewal notice · Built 1967 · Gta Air IncN211RVMitsubishi MU-2B-30 · S/N 502Cancelled Jul 22, 2011 · Turbine Aircraft Marketing IncN157CAMitsubishi MU-2B-60 · S/N 1558S.ACancelled Jul 14, 2011 · Built 1982 · Turbine Aircraft Marketing IncN15YSMitsubishi MU-2B-35 · S/N 598Cancelled Jul 14, 2011 · Turbine Aircraft Marketing IncN35RRMitsubishi MU-2B-60 · S/N 1525 S.A.Cancelled Jul 8, 2011 · Built 1981 · Turbine Aircraft Marketing IncN60FLMitsubishi MU-2B-60 · S/N 1512SACancelled Jul 8, 2011 · Built 1981 · Turbine Aircraft Marketing IncN740PBMitsubishi MU-2B-36 · S/N 657Cancelled Jul 8, 2011 · Turbine Aircraft Marketing IncN34ALMitsubishi MU-2B-60 · S/N 792 S.A.Cancelled Jun 29, 2011 · Built 1980 · Turbine Aircraft Marketing IncN2699GSmith AEROSTAR 601 · S/N 61-0163-083Cancelled Jun 14, 2011 · Second renewal notice · Built 1974 · Turbine Aircraft Marketing IncN26956Cessna 340A · S/N 340A0775Cancelled May 18, 2011 · Exported to Mexico · Built 1979 · Aquila Aviation LLCN747GMGates Learjet 35A · S/N 308Cancelled May 11, 2011 · Exported to Mexico · Built 1980 · 2010 Gmlj LLCN1714UCessna 207 · S/N 20700314Cancelled Apr 27, 2011 · Sale reported, pending cancellation · Built 1975N941SMitsubishi MU-2B-60 · S/N 738SACancelled Apr 19, 2011 · Built 1979 · Turbine Aircraft Marketing IncN49490Cessna 411 · S/N 411-0020Cancelled Mar 11, 2011 · Expired dealer · Addison Piper IncN629MUMitsubishi MU-2B-35 · S/N 629Cancelled Feb 4, 2011 · Built 1974 · Turbine Aircraft Marketing IncN950MAMitsubishi MU-2B-36 · S/N 671Cancelled Dec 7, 2010 · Turbine Aircraft Marketing IncN963BPSwearingen SA-26AT · S/N T26-114Cancelled Dec 7, 2010 · Built 1968 · Turbine Aircraft Marketing IncN375CAMitsubishi MU-2B-35 · S/N 643Cancelled Oct 21, 2010 · Built 1974 · Turbine Aircraft Marketing Inc
Back to Addison, TX