OpenAirDocs.org
Levelland, TX

Cancelled registrations · 33

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

N894TADJI PHANTOM 2 VISION + · S/N PH645275716Cancelled Mar 1, 2019 · Registration expired, pending cancellation · Titan Aerial LLCN806TADJI PHANTOM 2 · S/N PH645256319Cancelled Feb 26, 2019 · Registration expired, pending cancellation · Titan Aerial LLCN331TADJI PHANTOM 2 · S/N PH646003716Cancelled Feb 23, 2019 · Registration expired, pending cancellation · Titan Aerial LLCN5068MTaylorcraft BF · S/N 10368Cancelled Nov 18, 2017 · Revoked, canceled · Built 1946 · Westmoreland Ronny DN624TWAlliant FUSION · S/N F4A0020Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 2003 · Dunn Kelly WN6189KHortman David RAF 2000 GTX · S/N H2-92-3-71Cancelled May 24, 2017 · Registration expired, pending cancellation · Built 1994 · Hortman David AN72430Cessna 337G · S/N 33701580Cancelled Feb 4, 2017 · Revoked, canceled · Built 1973 · Mccutchin SonnyN7926UCessna 150M · S/N 15077863Cancelled Feb 4, 2017 · Revoked, canceled · Built 1976 · Ridpath J A Sr DBAN30778Air Tractor AT-504 · S/N 504-4025Cancelled Jun 29, 2015 · Exported to Philippines · Built 2015 · Hsi Turbines IncN704YFCessna 150M · S/N 15078973Cancelled Dec 2, 2014 · Revoked, canceled · Built 1976 · Ridpath J A DBAN8905GCessna A188B · S/N 18801319TCancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1973 · Stanley Cecil E DBAN453BBeech 35 · S/N D1469Cancelled Aug 20, 2013 · Registration expired, pending cancellation · Layton KirkN9486UCessna 150M · S/N 15078434Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1976N698BBeech A35 · S/N D-1701Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1948 · Harbour Rocky DN3783EAeronca 7AC · S/N 7AC7066Cancelled Jan 21, 2011 · Revoked, pending cancellation · Built 1947 · Rowland DavidN2524JCessna 150E · S/N 15061024Cancelled Feb 9, 2010 · Built 1964 · Bernstein Steven CN2TXBeech B100 · S/N BE-103Cancelled Nov 23, 2009 · Triennial form not returned · Built 1981 · Schumacher R JN11987Lockheed T-33A · S/N 51-9106Cancelled May 2, 2007 · Triennial form not returned · Built 1951 · Bernstein Steven CN201QKMooney M20J · S/N 24-0290Cancelled Sep 20, 2000 · Triennial form not returned · Shipley Bros IncN3143JCessna 150G · S/N 15065843Cancelled Nov 4, 1999 · Triennial form not returned · Bernstein Steven CharlesN8537LPiper PA-25-260 · S/N 25-4958Cancelled Sep 12, 1982 · Exported to Mexico · A-1 Flying Service IncN7353ZPiper PA-25-235 · S/N 25-3305Cancelled Oct 19, 1981 · A-1 Flying Service IncN54286Piper PA-31-350 · S/N 317405226Cancelled Sep 22, 1980 · Verna Drilling CoN4940YPiper PA-25-260 · S/N 25-4741Cancelled Aug 19, 1977 · A-1 Flying Service IncN9378GCessna 182P · S/N 18260918Cancelled Jun 9, 1975 · J A RidpathN7508DPiper PA-22-150 · S/N 22-5235Cancelled Jan 4, 1971 · Dan CaylorN6565VBellanca 17-30 · S/N 30244Cancelled Sep 3, 1970 · Built 1969 · Gardner Allen EN8770ABeech A35 · S/N D-2192Cancelled Jun 29, 1970 · John M SinadinN3518PPiper PA-22-150 · S/N 22-3272Cancelled Mar 31, 1958 · Built 1955 · Upshaw T A JrN43804Taylorcraft BC12-D · S/N 7463Cancelled Mar 31, 1958 · R E BullinN95512Taylorcraft BC12-D · S/N 7812Cancelled Feb 27, 1958 · Morris Robert EN77530Piper J3C-65 · S/N 22022Cancelled Jun 7, 1949 · Lawlis Frank MN47669Aeronca 0-58B · S/N 058B-4272Cancelled Nov 1, 1948 · Built 1942 · Hold Leonard Cliffie
Back to Levelland, TX