OpenAirDocs.org
Tyler, TX

Cancelled registrations · 122

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

N238NYCessna 172M · S/N 17265540Cancelled Aug 11, 2004 · Second triennial mailing, no response · Built 1975 · K & S Enterprises LLCN734HGCessna 172N · S/N 17268862Cancelled Aug 11, 2004 · Triennial form not returned · Built 1977 · K & S Enterprises LLCN90DABeech E-90 · S/N LW-22Cancelled Oct 11, 2003 · Triennial form not returned · Built 1972 · Little Walden PN240AAAero Commander 1121 · S/N 82Cancelled Sep 22, 2003 · Built 1966 · Ron Farish Aircraft IncN5115QCessna 152 · S/N 15285077Cancelled Sep 3, 2003 · Exported to Poland · Built 1981 · Bill Wood Aviation LLC DBAN25217Cessna 152 · S/N 15280535Cancelled Mar 11, 2003 · Triennial form not returned · Built 1977 · Tyler International School Of Aviation IncN102TLBellanca 8KCAB · S/N 449-78Cancelled Nov 14, 2002 · Exported to Philippines · Built 1978 · Byars William GoebelN17JJSwearingen SA-26AT · S/N T26-166Cancelled Jun 11, 2001 · East Texas Turbines IncN345TJFairchild SA227-AC · S/N AC744BCancelled Apr 23, 2001 · Exported to Aruba · Tyler Jet LLCN83007Landes/Karich/Schmidt CHRISTEN EAGLE II · S/N LAN/KAR 0001Cancelled Mar 21, 2001 · Laughlin StanN2834WSiai-Marchetti S.205/22R · S/N 4-191Cancelled Feb 10, 2001 · Triennial form not returned · Johnson JohnnyN3036FCessna 182J · S/N 18257136Cancelled Nov 29, 2000 · Triennial form not returned · Hale Lura LN555LGGrumman G-1159 · S/N 10Cancelled Jul 16, 1999 · Tyler Jet LLCN10786Cessna 150L · S/N 15075038Cancelled Jun 24, 1999 · Exported to Paraguay · Johnson Aviation IncN761FMCessna T210M · S/N 21062222Cancelled Oct 5, 1998 · Triennial form not returned · Tyler Trinity CorporationN84561Cessna 172K · S/N 17258522Cancelled Aug 31, 1998 · Triennial form not returned · Conaway Bob GN4111MPiper PA-31-350 · S/N 318352001Cancelled Apr 15, 1998 · Exported to Philippines · Byars William GN770TJBritish Aerospace HS 125-700B · S/N 257175Cancelled Nov 10, 1997 · Exported to Cayman Islands · Tyler Jet LLCN246CGCessna U206G · S/N U20604013Cancelled Sep 10, 1997 · Exported to Mexico · System Engineering & LaboratoriesN4963HCessna 152 · S/N 15284048Cancelled Mar 25, 1997 · Triennial form not returned · Tyler Aero Company Of Texas IncN41093Cessna 421B · S/N 421B0445Cancelled Nov 29, 1996 · Exported to Canada · Southwest Business Jet IncN180TJCessna 180K · S/N 18053077Cancelled Jun 11, 1996 · Exported to Kenya · Tyler Jet Aircraft Sales IncN2279QSterling James RAF 2000 GTX · S/N H2945122Cancelled Jan 3, 1996 · Sterling James MN29341Cessna 177 · S/N 17700824Cancelled Jul 10, 1995 · Triennial form not returned · Cardinal Flyers Of Tyler IncN68TJGates Learjet 35A · S/N 168Cancelled Jan 20, 1995 · Exported to Canada · Tyler-Jet Aircraft Sales IncN17TJMcdonnell Douglas Helicopter 369E · S/N 0359ECancelled Aug 30, 1994 · Exported to Philippines · Tyler-Jet Aircraft Sales IncN94063Ercoupe 415-C · S/N 1386Cancelled Jul 19, 1994 · Triennial form not returned · Gardner Jerry G LN125TTPiper PA-31-325 · S/N 318012041Cancelled Jul 11, 1994 · Exported to Sweden · Tyler Turbine Sales IncN97TJGates Lear Jet 35 · S/N 012Cancelled Jun 15, 1994 · Exported to Mexico · Tyler Jet Aircraft Sales IncN2986TCameron Balloons US N-65 · S/N 5158Cancelled May 4, 1994 · Nautilus Balloon WorksN108TTBeech C90 · S/N LJ591Cancelled Feb 3, 1994 · Exported to Venezuela · Tyler Turbine Sales IncN81TTPiper PA-31-350 · S/N 318152013Cancelled May 13, 1993 · Exported to Canada · Tyler Turbine Sales IncN83TJBeech B200 · S/N BB-920Cancelled Jan 15, 1993 · Exported to Indonesia · Tyler-Jet Aircraft Sales IncN212MBeech K35 · S/N D5874Cancelled Jul 15, 1992 · Triennial form not returned · Mcchristy JohnN444FFHelio H-250 · S/N 2508Cancelled Mar 23, 1992 · Triennial form not returned · Mcburney James H DBAN401TJBeech 100 · S/N B84Cancelled Dec 19, 1991 · Exported to Canada · Tyler Jet Aircraft Sales IncN731HECessna P210N · S/N P21000459Cancelled Aug 7, 1986 · Exported to Australia · Pool Weldon CraigN2651XCessna P206 · S/N P2060151Cancelled Mar 1, 1983 · Exported to South Africa · Built 1966 · FgbmfiN6030SBeech B-60 · S/N P328Cancelled Dec 3, 1982 · Faulconer Vernon EN68CBCameron Balloons O-77 · S/N 142Cancelled Sep 30, 1982 · Nautilus Balloon Works IncN73DPPiccard AX-6 · S/N 720Cancelled Sep 28, 1982 · Air Safaris IncN6239CPiper PA-28R-201T · S/N 28R-7803213Cancelled Mar 12, 1982 · Tyler Skyharbor IncN22860Cessna 150H · S/N 15068569Cancelled Feb 26, 1982 · Built 1968 · Bland Billy JN7747CBeech A45 · S/N G-846Cancelled Oct 15, 1981 · Duncan Dewitt DN2770YBeech 95 · S/N TD-147Cancelled Oct 13, 1978 · Exported to Canada · Texas Aviation Service IncN444YBeech D35 · S/N D-3472Cancelled Feb 28, 1978 · Sale reported · Built 1953N34533Cessna 177B · S/N 17701860Cancelled Aug 6, 1976 · Exported to Canada · Woods Carey AN5607RCessna 172F · S/N 17253217Cancelled Mar 20, 1973 · Exported to Canada · Coker SteveN7392UCessna 411 · S/N 411-0092Cancelled Dec 28, 1971 · Fair-WolfN7314CLockheed 1649A-98 · S/N 1016Cancelled Sep 4, 1970 · Janus Enterprises Inc
Back to Tyler, TX