OpenAirDocs.org
Los Fresnos, TX

Cancelled registrations · 44

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 = 'LOS FRESNOS'
  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.

N1098VConsolidated Vultee BT-13 · S/N 6945Cancelled Feb 21, 2020 · Revoked, canceled · Built 1942 · Hughston Sam D JrN45180Naval Aircraft Factory N3N-3 · S/N 2682Cancelled Feb 21, 2020 · Revoked, canceled · Built 1941 · Hughston Sam JrN69713Consolidated Vultee BT-13A · S/N 10349Cancelled Oct 11, 2019 · Revoked, canceled · Built 1943 · Hughston Sam D JrN1118FCessna 172G · S/N 17254713Cancelled Mar 11, 2019 · Registration expired, pending cancellation · Built 1966 · Ecological Services InternationalN9919YAeronca 7GC · S/N 7GCB113Cancelled Aug 23, 2018 · Revoked, canceled · Built 1961 · Gomez GuadalupeN3126MPiper PA-12 · S/N 12-2004Cancelled Aug 2, 2018 · Revoked, canceled · Built 1947 · French Roy A Rt 1N9945YAeronca 7GC · S/N 7GCBA13Cancelled Jan 24, 2017 · Revoked, pending cancellation · Built 1962 · Gomez Guadalupe VN4389PPiper PA-23-160 · S/N 23-1901Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1960 · Whitehead Thomas WN100GLAero Commander 681 · S/N 6028Cancelled Aug 14, 2013 · Sale reported, canceled · Built 1969N69001Cessna 152 · S/N 15282424Cancelled May 31, 2013 · Sale reported, canceled · Built 1978N73074Air Tractor AT-301 · S/N 301-0620Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1985 · Ag-Air IncN65074Consolidated Vultee BT-13A · S/N 5252Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1942 · Hughston Sam D JrN148DDouglas DC3A-S4C4G · S/N 6335Cancelled Jun 21, 2012 · Sale reported, canceled · Built 1942N1591PCessna 337C · S/N 3370925Cancelled Apr 29, 1995 · Triennial form not returned · Aviation Enterprises IncN8902SAir Tractor AT-301 · S/N 3010229Cancelled May 7, 1991 · Exported to Mexico · Ag Air IncN70003Douglas DC3C-S1C3G · S/N 12938Cancelled Feb 14, 1986 · Aviation EnterprisesN7304LAir Tractor AT-301 · S/N 301-0599Cancelled Jun 28, 1985 · Exported to Mexico · Ag-Air IncN73052Air Tractor AT-301 · S/N 301-0619Cancelled Jun 28, 1985 · Exported to Mexico · Ag-Air IncN7307XAir Tractor AT-301 · S/N 301-0614Cancelled Apr 8, 1985 · Exported to Mexico · Ag-Air IncN7301CAir Tractor AT-301 · S/N 301-0586Cancelled Apr 2, 1985 · Exported to Mexico · Ag-Air IncN7305TAir Tractor AT-301 · S/N 301-0604Cancelled Mar 15, 1985 · Exported to Mexico · Ag-Air IncN7304HAir Tractor AT-301 · S/N 301-0598Cancelled Feb 25, 1985 · Exported to Mexico · Ag-Air IncN2384VAir Tractor AT-301 · S/N 301-0436Cancelled Apr 6, 1984 · Administratively canceled · Ag Air IncN36500Air Tractor AT-301 · S/N 301-0255Cancelled Mar 6, 1984 · Exported to Mexico · Built 1980 · Ag-Air IncN4413SAir Tractor AT-301 · S/N 301-0073Cancelled Sep 15, 1983 · Exported to Mexico · Built 1977 · Ag Air IncN738UJCessna 172N · S/N 17270245Cancelled Sep 4, 1983 · Reyes & Son IncN3656DAir Tractor AT-301 · S/N 301-0305Cancelled May 14, 1982 · Exported to Mexico · Built 1980 · Ag-Air IncN2347VAir Tractor AT-301 · S/N 301-0389Cancelled Dec 28, 1981 · Exported to Mexico · Ag-Air IncN3650FAir Tractor AT-301 · S/N 301-0241Cancelled Oct 27, 1981 · Exported to Mexico · Ag-Air IncN76MHAir Tractor AT-301 · S/N 301-0028Cancelled May 1, 1981 · Exported to Mexico · Ag-Air IncN3650PAir Tractor AT-301 · S/N 301-0250Cancelled May 23, 1980 · Exported to Mexico · Ag-Air IncN5187SAir Tractor AT-301 · S/N 3010121Cancelled Feb 11, 1980 · Exported to Mexico · Ag Air IncN4405SAir Tractor AT-301 · S/N 301-0065Cancelled Jan 14, 1980 · Exported to Mexico · Built 1977 · Ag-Air IncN4343SAir Tractor AT-301 · S/N 301-0023Cancelled Jan 26, 1977 · Built 1975 · Ag-Air IncN3012YCessna 182E · S/N 18254012Cancelled May 18, 1976 · Built 1961 · Breedlove Cleve T EtalN4325SAir Tractor AT-300 · S/N 300-0005Cancelled Aug 5, 1975 · Built 1974 · Ag Air IncN1660SSnow S2C · S/N 600-1225CCancelled Jul 1, 1974 · Built 1964 · Ag Air IncN6173BCessna 182A · S/N 34173Cancelled Mar 6, 1972 · Murray Wayland AN69956Consolidated Vultee BT-13A · S/N 7978Cancelled Feb 28, 1972 · Hughston Jr Sam DN7172ZPiper PA-25-235 · S/N 253038Cancelled Sep 9, 1971 · Exported to Mexico · Cloud C LN64724Piper J3C-65 · S/N 9070Cancelled Mar 30, 1955 · Exported to Mexico · Built 1942 · Hughston Sam D JrN33575Piper J3C-65 · S/N 14052Cancelled Jul 2, 1951 · Samuel D Hughston JrN81283Fairchild 24W-46 · S/N W46183Cancelled May 2, 1951 · Breedlove Ura JN75841Cessna T-50 · S/N 4553Cancelled May 16, 1949 · Owen Rolland
Back to Los Fresnos, TX