Vernon, TX

Cancelled registrations · 102

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

N9008HBrantly B-2B · S/N 2017Cancelled Aug 11, 2005 · Built 2000 · Brantly International IncN9013QBrantly B-2B · S/N 2018Cancelled Feb 18, 2005 · Exported to China · Built 2001 · Brantly International IncN9022YBrantly B-2B · S/N 2019Cancelled Feb 18, 2005 · Exported to China · Built 2001 · Brantly International IncN9025NBrantly B-2B · S/N 2008Cancelled Sep 15, 2004 · Exported to Australia · Built 1998 · Brantly International IncN413JFCessna 152 · S/N 15284259Cancelled Aug 27, 2004 · Triennial form not returned · Built 1980 · Byars Matthew LonN6301GCessna A188B · S/N 18801184TCancelled Oct 14, 2003 · Exported to Brazil · Built 1973 · Mac Flying Services IncN2550UBrantly B-2B · S/N 2006Cancelled Jun 26, 2000 · Exported to China · Brantly International IncN90099Brantly B-2B · S/N 2005Cancelled Jun 6, 2000 · Exported to China · Brantly International IncN25411Brantly B-2B · S/N 2001Cancelled Apr 12, 2000 · Exported to China · Brantly International IncN9012ABrantly B-2B · S/N 2012Cancelled Feb 3, 2000 · Exported to China · Brantly International IncN9015MBrantly B-2B · S/N 2011Cancelled Feb 3, 2000 · Exported to China · Brantly International IncN90161Brantly B-2B · S/N 2009Cancelled Feb 3, 2000 · Exported to China · Brantly International IncN9016MBrantly B-2B · S/N 2010Cancelled Feb 3, 2000 · Exported to China · Brantly International IncN90212Brantly B-2B · S/N 2007Cancelled Dec 1, 1998 · Exported to Australia · Brantly International IncN8537VRockwell International S-2R · S/N 2366RCancelled Jul 11, 1996 · Exported to Canada · Mccarty DallasN96807Taylorcraft BC12-D · S/N 9107Cancelled Jul 3, 1995 · Exported to United Kingdom · Screws Harlan DN9398RCessna 188B · S/N 18802274Cancelled Jun 21, 1994 · Exported to Chile · Rozzell MelvinN4862Grumman Acft ENG Cor-Schweizer G-164A · S/N 1015Cancelled Mar 30, 1993N6082FCessna 182P · S/N 18264097Cancelled Apr 10, 1991 · Triennial form not returned · Lemons WoodyN43235Taylorcraft BC12-D · S/N 6894Cancelled Nov 16, 1982 · Built 1946 · Screws Harland DN8736LPiper PA-25-235 · S/N 25-5200Cancelled Nov 1, 1982 · Registration revoked · Built 1970 · Shivers B RN5268Grumman G-164A · S/N 552Cancelled Jul 8, 1981 · Exported to Mexico · Shivers Flying Service IncN6918ZPiper PA-25-235 · S/N 25-2661Cancelled Dec 16, 1980 · Sale reported · Built 1964N7784RBeech V35A · S/N D8883Cancelled Apr 23, 1975 · Exported to Canada · Haynes GordonN24126Beech 3N · S/N CA48Cancelled Jun 29, 1974 · Shrivers B RN8073SCessna 150F · S/N 15061673Cancelled Jan 29, 1974 · Taylor Authur BN10231Grumman G-164 · S/N 31Cancelled Jun 26, 1973N7656ZPiper PA-25-235 · S/N 25-3797Cancelled May 18, 1973 · Exported to France · Shivers Bobby RN7088CNorth American AT-6C · S/N 88-12826Cancelled Feb 4, 1971 · Naylor Flying ServiceN9412RSnow S2A · S/N 1042Cancelled May 20, 1965 · Hamilton NaylorN6199ZPiper PA-25 · S/N 25-233Cancelled Aug 31, 1964 · Shivers Flying ServiceN911BBell 47D1 · S/N 482Cancelled Feb 16, 1955 · W T Waggoner EstateN4480NCessna AT-17 · S/N 2031Cancelled Nov 9, 1953 · Kassell Aircraft Sales LtdN4819NCessna AT-17E · S/N 1900Cancelled Feb 1, 1952 · Built 1947 · Russell Aircraft SalesN4464NConsolidated Vultee BT-13A · S/N 6144Cancelled Oct 2, 1951 · Hall M IN4680NConsolidated Vultee BT-13A · S/N 11289Cancelled Sep 7, 1951 · Gaare Supply CoN4750NConsolidated Vultee BT-13A · S/N 7564Cancelled Sep 7, 1951 · Gaare Supply CoN75792Consolidated Vultee BT-13A · S/N 10410Cancelled Apr 30, 1951 · Built 1943 · Gaare Supply CoN4679NConsolidated Vultee BT-13A · S/N 8728Cancelled Jul 12, 1950 · Gaare Supply CoN4682NConsolidated Vultee BT-13A · S/N 6869Cancelled Mar 31, 1950 · Gaare Supply CoN75794Consolidated Vultee BT-13A · S/N 8143Cancelled Feb 15, 1949 · Exported to Mexico · Built 1942 · Gaare Supply CoN75791Consolidated Vultee BT-13A · S/N 3322Cancelled Nov 2, 1948 · Exported to Dominican Republic · Built 1942 · Gaare Supply CoN75795Consolidated Vultee BT-13A · S/N 6140Cancelled Nov 2, 1948 · Exported to Dominican Republic · Built 1942 · Gaare Supply CoN4437NConsolidated Vultee BT-13A · S/N 5522Cancelled Nov 1, 1948 · Exported to Dominican Republic · Gaare Supply CoN4452NConsolidated Vultee BT-13A · S/N 5521Cancelled Nov 1, 1948 · Exported to Dominican Republic · Gaare Supply CoN4453NConsolidated Vultee BT-13 · S/N 2342Cancelled Nov 1, 1948 · Exported to Dominican Republic · Gaare Supply CoN4752NConsolidated Vultee BT-13A · S/N 6678Cancelled Nov 1, 1948 · Exported to Dominican Republic · Gaare Supply CoN75796Consolidated Vultee BT-13A · S/N 1278Cancelled Nov 1, 1948 · Exported to Dominican Republic · Built 1941 · Gaare Supply CoN4448NConsolidated Vultee BT-13A · S/N 2973Cancelled Oct 7, 1948 · Exported to Dominican Republic · Gaare Supply CoN4751NConsolidated Vultee BT-13A · S/N 7265Cancelled Jun 10, 1948 · Gaare Supply Co
Back to Vernon, TX