Lubbock, TX

Cancelled registrations · 276

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

N488UHHughes 369A · S/N 480405Cancelled Sep 19, 1996 · United States HelicopterN665UHHughes 369A · S/N 880665Cancelled Sep 19, 1996 · United States HelicopterN8894EPiper PA-34-200T · S/N 347670186Cancelled May 15, 1996 · Triennial form not returned · Wright Fred G JrN6108CCessna T210N · S/N 21063803Cancelled Sep 30, 1994 · Exported to Brazil · Abilene Aero Inc DBAN5283PCessna 152 · S/N 15284906Cancelled Sep 14, 1993 · Triennial form not returned · Flight Tech IncN25285Luscombe 8C · S/N 1192Cancelled Apr 22, 1993N201BLMooney M20J · S/N 241259Cancelled Mar 30, 1993 · Abilene Aero Inc DBAN1JGCessna P210N · S/N P21000561Cancelled Feb 4, 1992 · Hampton DavidN9997QLet BLANIK L-13 · S/N 026010Cancelled Jan 7, 1992 · Triennial form not returned · Caprock Soaring Club IncN150TXRaven S-60A · S/N S60A185Cancelled Sep 25, 1991 · Second triennial mailing, no response · Meyer StephenN6344ZPiper PA-25 · S/N 25454Cancelled Aug 13, 1991 · Triennial form not returned · Lovejoy SteveN7504TCessna 172A · S/N 17247104Cancelled Aug 7, 1991 · Triennial form not returned · Hanley John WN29612Cessna 177 · S/N 17700991Cancelled Jul 29, 1991 · Triennial form not returned · Black Walter HN57870Piper PA-36-300 · S/N 367760035Cancelled Apr 8, 1991 · Exported to Ecuador · Neal Aircraft IncN59693Piper PA-36-300 · S/N 367760110Cancelled Mar 1, 1991 · Exported to Ecuador · Neal Larry TN2448LPiper PA-38-112 · S/N 3879A0706Cancelled Jan 29, 1991 · Bernstein Steven CN69138Cessna 152 · S/N 15282508Cancelled Jun 14, 1986 · Sandene Aviation IncN9035NLox Charles D MONERAI · S/N 80Cancelled Mar 17, 1986 · Registration expired, pending cancellation · Built 1980 · Lox Charles DN6185APiper PA-36-375 · S/N 36-8102020Cancelled Apr 19, 1985 · Exported to Portugal · Wta IncN82195Piper PA-28RT-201T · S/N 28R-8031109Cancelled Feb 14, 1985 · Administratively canceled · Wes-Tex Aircraft IncN7429ZPiper PA-25-235 · S/N 25-3411Cancelled Jan 14, 1985 · Exported to Mexico · Wta IncN7467ZPiper PA-25-235 · S/N 25-3467Cancelled Jan 4, 1985 · Exported to Mexico · Ag Central Aircraft IncN9320UCessna 150M · S/N 15078270Cancelled Sep 3, 1983 · Administratively canceled · Sky Brezze Aviation IncN26828Cessna 404 · S/N 404-0602Cancelled Jul 8, 1983 · Built 1979 · Texas Air Center IncN4413YPiper PA-25-235 · S/N 25-4029Cancelled Jun 2, 1983 · Exported to Mexico · Built 1966 · Ag Central Aircraft IncN2352YPiper PA-36-300 · S/N 36-8160015Cancelled Apr 19, 1983 · Exported to Mexico · Wta IncN57767Piper PA-36-285 · S/N 36-7660042Cancelled Feb 28, 1983 · Exported to Mexico · Avtech Aviation IncN4070XAero Commander S2R · S/N 1914RCancelled Sep 28, 1982 · Exported to Venezuela · Built 1973 · Ag Central Aircraft IncN6191APiper PA-36-375 · S/N 36-8102023Cancelled Apr 5, 1982 · Exported to Portugal · Wta IncN6443YCessna T210N · S/N 210-64383Cancelled Mar 8, 1982 · Exported to Mexico · Texas Air Center IncN2334YPiper PA-36-300 · S/N 36-8160005Cancelled Mar 3, 1982 · Exported to Ecuador · Wta IncN6854BCessna 441 · S/N 4410224Cancelled Feb 11, 1982 · Exported to Mexico · Texas Air Center IncN419CCPiper PA-28-235 · S/N 28-7610151Cancelled Apr 8, 1981 · Built 1976 · Young Paul D Et AlN8696LPiper PA-25-235 · S/N 255128Cancelled Feb 5, 1981 · Exported to Mexico · Wta IncN4944YPiper PA-25-260 · S/N 254746Cancelled Sep 25, 1980 · Exported to Mexico · Wta IncN8495VRockwell International S-2R · S/N 2255RCancelled Mar 7, 1980 · Exported to Antigua and Barbuda · Ag Central Aircraft IncN3726EPiper PA-36-300 · S/N 36-7960056Cancelled Oct 15, 1979 · Exported to Mexico · Built 1978 · Wta IncN3888EPiper PA-36-375 · S/N 36-7802035Cancelled Jul 31, 1979 · Exported to Mexico · Built 1978 · Wta IncN3947EPiper PA-36-375 · S/N 36-7802067Cancelled Jul 9, 1979 · Exported to Mexico · Wta IncN3795EPiper PA-36-375 · S/N 36-7802004Cancelled Jul 2, 1979 · Exported to Mexico · Built 1978 · Wta IncN36169Piper PA-28-181 · S/N 28-7890498Cancelled Jun 21, 1979 · Exported to Canada · Wta IncN60969Cessna 150J · S/N 15070703Cancelled Aug 3, 1978 · Exported to Canada · Sisk BillN735CWCessna 182Q · S/N 18265328Cancelled Dec 30, 1977 · Exported to Mexico · Avtech Aviation IncN4918XRockwell International S-2R · S/N 2112RCancelled Oct 12, 1977 · Exported to Guadeloupe · Ag Central Aircraft IncN6554ZPiper PA-25-235 · S/N 25-2099Cancelled Aug 16, 1977 · Exported to El Salvador · Horton Aero Service IncN3414DCessna 170B · S/N 26957Cancelled May 5, 1977 · Exported to Canada · Sky Breeze Aviation IncN4200BHelio H-391B · S/N 004Cancelled Sep 2, 1976 · Martin Milton WN1495XPiper PA-34-200T · S/N 34-7570263Cancelled Feb 19, 1976 · S & R Flyers IncN1428XPiper PA-28-180 · S/N 28-7505227Cancelled Dec 10, 1975 · Exported to Canada · Built 1975 · Wes-Tex Aircraft IncN5570VBoeing A75N1 · S/N 751269Cancelled Jun 10, 1975 · Moberg John
Back to Lubbock, TX