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.

N1917MPoland LIM-5 · S/N IC-0508Cancelled Sep 18, 2017 · Registration expired, pending cancellation · Cavanaugh Collection IncN871HMDassault MYSTERE-FALCON 50 · S/N 318Cancelled Aug 11, 2017 · Exported to Aruba · Built 2001 · Interjet IncN117UCMesserschmitt BK 117 B-1 · S/N 7206Cancelled May 30, 2017 · Third renewal notice · Built 1989 · Omniflight Helicopters IncN69XDAmerican Champion 8KCAB · S/N 1154-2015Cancelled May 24, 2017 · Exported to Norway · Built 2014 · Arnzen PatrickN2GZMitsubishi MU-2B · S/N 025Cancelled Apr 5, 2017 · Built 1967 · Turbine Aircraft Marketing IncN213SCSwearingen SA-26AT · S/N T26-135Cancelled Mar 21, 2017 · Registration expired, pending cancellation · Built 1969 · Baskidball IncN749TAMitsubishi MU-2B-60 · S/N 749SACancelled Mar 13, 2017 · Turbine Aircraft Marketing IncN8435MCessna A150K · S/N A15000135Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Built 1969 · Manley Steven TN5110RBeech B19 · S/N MB-644Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1974 · Ari Ben Aviation IncN311RNMitsubishi MU-2B-25 · S/N 311Cancelled Feb 9, 2017 · Built 1974 · Turbine Aircraft Marketing IncN102SKSportshares West SKYCRUISER · S/N K16001Cancelled Jan 25, 2017 · Sportshares West LLCN22XYMitsubishi MU-2B-35 · S/N 599Cancelled Dec 7, 2016 · Built 1973 · Turbine Aircraftmarketing IncN3217QCessna 401 · S/N 401-0017Cancelled Nov 1, 2016 · Third renewal notice · Built 1966 · Gta Air IncN207BAMitsubishi MU-2B-36 · S/N 666Cancelled Dec 2, 2015 · Built 1974 · Turbine Aircraft Marketing IncN4677VCessna 172RG · S/N 172RG0224Cancelled Oct 23, 2015 · Built 1980 · Ameriflyers Of Florida LLCN9592BCessna 172RG · S/N 172RG0905Cancelled May 21, 2015 · Registration expired, pending cancellation · Built 1981 · Ameriflyers Of Illinois IncN76CFPiper PA-31-350 · S/N 31-7552052Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1975 · Aquila Aviation LLCN221AGMckinnon G21G · S/N 1240Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1944 · Triple S Aviation LLCN5421MCessna 402B · S/N 402B0021Cancelled Apr 2, 2015 · Registration expired · Built 1970 · Gta Air IncN1140HMBB BK 117 A-3 · S/N 7078Cancelled Mar 25, 2015 · First renewal notice · Omniflight Helicopters IncN617BBMitsubishi MU-2B-30 · S/N 522Cancelled Dec 22, 2014 · Registration pending, canceled · Built 1970N711GMBeech 100 · S/N B-31Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1970 · T & W LeasingN421ETCessna 421B · S/N 421B0399Cancelled Dec 17, 2014 · Sale reportedN38BEMitsubishi MU-2B-20 · S/N 210Cancelled Nov 20, 2014 · Built 1971 · Turbine Aircraft Marketing IncN118LLMBB BK 117 A-3 · S/N 7097Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Omniflight Helicopters IncN5102RBeech B19 · S/N MB-636Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1974 · Ari Ben Aviator IncN140CMMitsubishi MU-2B-20 · S/N 190Cancelled Sep 23, 2014 · Built 1970 · Turbine Aircraft Marketing IncN22345Aeronca 65-C · S/N C-3439Cancelled Sep 16, 2014 · Registration expired, pending cancellation · Built 1939 · Noell Milton JN868MAMitsubishi MU-2B-36A · S/N 708SACancelled Aug 13, 2014 · Turbine Aircraft Marketing IncN21JAMitsubishi MU-2B-35 · S/N 614Cancelled Jul 24, 2014 · Sale reported · Built 1973N334EBMitsubishi MU-2B-35 · S/N 568Cancelled Jul 24, 2014 · Built 1972 · Turbine Aircraft Marketing IncN637WGMitsubishi MU-2B-35 · S/N 637Cancelled Jul 24, 2014 · Sale reportedN52CDMitsubishi MU-2B-20 · S/N 174Cancelled Jul 17, 2014 · Built 1969 · Turbine Aircraft Marketing IncN66CYMitsubishi MU-2B-35 · S/N 562Cancelled Jun 4, 2014 · Built 1972 · Turbine Aircraft Marketing IncN5362BCessna 152 · S/N 15283847Cancelled Mar 4, 2014 · Exported to United Kingdom · Built 1979 · Campion Maximilian RN361JAMitsubishi MU-2B-36 · S/N 681Cancelled Jan 7, 2014 · Turbine Aircraft Marketing IncN211BEMitsubishi MU-2B-35 · S/N 641Cancelled Nov 13, 2013 · Built 1974 · Turbine Aircraft Marketing IncN400RXMitsubishi MU-2B-35 · S/N 593Cancelled Nov 13, 2013 · Built 1978 · Turbine Aircraft Marketing IncN40751Eurocopter AS 350 B2 · S/N 3154Cancelled Sep 24, 2013 · Exported to New Zealand · Built 1998 · Omniflight Helicopters IncN9844ACessna 182R · S/N 18268413Cancelled Sep 13, 2013 · Exported to Mexico · Built 1984 · Lad (Aviation) IncN36GMitsubishi MU-2B · S/N 035Cancelled Sep 5, 2013 · Turbine Aircraft Marketing IncN1425JRockwell International 112A · S/N 425Cancelled Aug 28, 2013 · Sale reported, canceled · Built 1975N56495Piper PA-34-200 · S/N 34-73-50340Cancelled Aug 23, 2013 · Sale reported, canceled · Built 1973N6813TCessna 310D · S/N 39113Cancelled Aug 16, 2013 · Sale reported, canceled · Built 1959N121KJBeech C35 · S/N D-3045Cancelled Aug 14, 2013 · Sale reported, canceledN50MMCessna 500 · S/N 500-0118Cancelled Aug 13, 2013 · Sale reported, canceledN227TXCirrus Design SR22T · S/N 0029Cancelled Jul 18, 2013 · Built 2010 · Cam & Muz Industries LLCN5445GCessna 404 · S/N 404-0062Cancelled Jun 27, 2013 · Registration expired, pending cancellation · Addison Piper IncN5426ACessna T210N · S/N 21063430Cancelled Jun 26, 2013 · Exported to Brazil · Built 1979 · Turbine Aircraft Marketing IncN15ETMitsubishi MU-2B-60 · S/N 733SACancelled Jun 20, 2013 · Turbine Aircraft Market Inc
Back to Addison, TX