OpenAirDocs.org
Rockport, TX

Cancelled registrations · 41

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

N731KTDJI PHANTOM 3 PROFESSION · S/N P76DCG20017176Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Texas Parks And Wildlife DeptN8284TCessna 175B · S/N 17556984Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Built 1961 · Crawford Gary NN786RSDJI S1000+ · S/N 03P0011722Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Spinnaker Systems LLCN786PSDJI PHANTOM 3 PROFESSION · S/N P76DCH03016089Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Spinnaker Systems LLCN925BBeech B200 · S/N BB-1050Cancelled Dec 18, 2019 · Exported to Mexico · Built 1982 · Atlantic Coast Leasing CorpN211FSBeech B-60 · S/N P-420Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Shumate Frank TN690XSDJI PHANTOM 3 PROFESSION · S/N P76DCH24A26994Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Spinnaker Systems LLCN92539Piper PA-12 · S/N 12-66Cancelled Jul 3, 2019 · Revoked, pending cancellation · Built 1946 · United Arcft And Marine Eng SvcN650EPiper PA-32R-300 · S/N 32R-7680006Cancelled Mar 9, 2019 · Registration pending, canceled · Built 1975N76VNavion NAVION E · S/N NAV-4-1474Cancelled Feb 2, 2019 · Registration expired, pending cancellation · Built 1948 · Elder James LN201VGMooney M20J · S/N 24-0396Cancelled Jan 30, 2019 · Registration expired, pending cancellation · Built 1977 · Southwest Medical Associates IncN427TCQuicksilver MXL II SPORT · S/N 000875Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 2003 · Corry Thomas FN86268Aeronca 11AC · S/N 11AC-73Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1946 · Buffalo Park IncN6675HPiper J3C-65 · S/N 19880Cancelled Sep 11, 2013 · Registration expired, pending cancellation · Built 1946 · Snead Justin RN618TBeech H35 · S/N D-5242Cancelled Aug 19, 2013 · Registration expired, pending cancellation · Built 1957 · Gilbert Garland CN925TBBeech E50 · S/N 57-6034Cancelled May 31, 2013 · Sale reported, canceledN87250Cessna 310R · S/N 310R0320Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1975 · Baczewski Jerry EN6248NBell 47G-4A · S/N 7605Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1967 · Perry R Bass IncN6387ADouglas C-47D · S/N 45-1088Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1945 · Shapiro SamN5934LAmerican AA-1 · S/N AA1-0234Cancelled Apr 24, 2013 · Registration expired, pending cancellation · Built 1969 · Coggins T RN87JWAgri-Flite TIERRA II · S/N R250005Cancelled Apr 2, 2013 · Sale reported, canceledN345MPAero Commander 500 · S/N 819Cancelled Feb 28, 2013 · Exported to Venezuela · Built 1959 · Heatherington MaxN732NXCessna 210M · S/N 21061653Cancelled Feb 21, 2013 · Sale reported, canceled · Built 1976N4968KBeech U-8D · S/N 56-3702Cancelled Dec 18, 2012 · Registration expired, pending cancellation · Solterra CorporationN4650Williams Gurganus CAVALIER SA102.5 · S/N 69120Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Built 1974 · Szasz John RN6124UPaige James G KOLB MARK III · S/N M3-304Cancelled Nov 21, 2012 · Registration expired, pending cancellation · Built 2001 · Paige James GN3840RCessna 172H · S/N 17255340Cancelled Nov 13, 2012 · Registration expired, pending cancellation · Built 1966 · Tchida Rodney SN7528HPiper PA-12 · S/N 12-392Cancelled Oct 19, 2012 · Sale reported, pending cancellation · Built 1946N2867JCessna T188C · S/N T18803542TCancelled Oct 18, 2012 · Registration expired, pending cancellation · Built 1979 · Schindler Charles JN11770Cessna 150L · S/N 15075622Cancelled Aug 22, 2001 · Triennial form not returned · Taylor Thomas EN1258JAero Commander 112 · S/N 258Cancelled Jun 23, 1999 · Second triennial mailing, no response · Baczewski JerryN5115BCessna 152 · S/N 15283755Cancelled Dec 8, 1998 · Triennial form not returned · Heldenfels W Dailey JrN117LRDouglas C-117D · S/N 138820Cancelled Jan 25, 1984 · Administratively canceled · Foreman Clyde E DBAN4782LPiper PA-28-180 · S/N 284117Cancelled Aug 23, 1982 · Russ Carl F JrN8502ZDouglas R4D-8 · S/N 43316Cancelled Jul 10, 1982 · Foreman Clyde EN117RRDouglas C-117D · S/N 012422Cancelled Jun 25, 1982 · Second triennial mailing, no response · Built 1951 · Foreman Clyde Earl DBAN3542PCessna P210N · S/N P21000028Cancelled Aug 29, 1979 · Exported to Mexico · Aransas Aviation IncN53394Cessna 172G · S/N 5725RCancelled May 4, 1976 · Exported to Canada · Canterbury Construction Co IncN76416Cessna 120 · S/N 10842Cancelled Nov 2, 1965 · Coward BusterN59443Cessna T-50 · S/N 6623Cancelled Jun 21, 1957 · Exported to Mexico · United Air Service Of TexasN11896Curtiss Wright CW-1 · S/N 1266Cancelled Apr 27, 1948 · J N Cole
Back to Rockport, TX