OpenAirDocs.org
Anderson, SC

Cancelled registrations · 46

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 = 'SC' AND d.registrant_city = 'ANDERSON'
  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.

N790RKSkyrocket Toys V950HD · S/N LANAK215Cancelled Dec 31, 2022 · Registration expired, pending cancellation · King Lana LN91021Aerostar International RX-7 · S/N RX7-3286Cancelled Jan 20, 2022 · Registration expired, pending cancellation · Built 1993 · Skyscapes Of America LLCN155CLPipistrel Doo Ajdovscina VIRUS SW · S/N 817 SWN 100Cancelled Jun 26, 2019 · First renewal notice · Built 2016 · Stevens Riley RN307ACDJI PHANTOM 2 VISION + · S/N PH645301088Cancelled Sep 15, 2018 · First renewal notice · Anderson County Sheriffs OfficeN5797WPiper PA-28-150 · S/N 28-1810Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Built 1964 · Parker Trucking IncN51WHCameron Balloons US V-90 · S/N 6148Cancelled Mar 27, 2018 · Registration expired, pending cancellation · Built 1998 · Davis Steven MN644DFKnupp Bradley SR DRAGONFLY · S/N 101042Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Knupp Bradley SrN10XBBarney Oldfield BABY LAKES · S/N 9118-J-1107BCancelled Jan 2, 2018 · Registration expired, pending cancellation · Hornbeck John M IIIN7976NPiper PA-28-180 · S/N 28-5398Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1969 · Carolina Fleets IncN6392Hanks BENSEN 8MKDLX · S/N AF14465011Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1974 · Lee Cleve LN3102EHead Balloons AX8-88B · S/N 283Cancelled Sep 22, 2014 · Registration expired, pending cancellation · County Of Anderson FinanceN701BEEvans Blair RAF 2000 · S/N H2-91-2-38Cancelled Oct 28, 2013 · Registration expired, pending cancellation · Evans BlairN30552Piper J5A · S/N 5-209Cancelled Aug 5, 2013 · Sale reported, canceled · Built 1940N42SEDiamond Aircraft Ind DA 40 · S/N 40.353Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 2004 · Accu Pad IncN1028PPiper PA-23 · S/N 23-30Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1954 · Boyd John LN5422ZPiper PA-22-108 · S/N 22-9195Cancelled Aug 21, 2012 · Revoked, canceled · Built 1962 · Kubik Richard GN12TFBeech E18S · S/N BA-300Cancelled Oct 9, 2009 · Registration revoked · American Lease Plans IncN3303CBeech E35 · S/N D-3969Cancelled Oct 11, 2007 · Built 1954 · Sperr David FN32928Piper PA-28-151 · S/N 28-7515275Cancelled Nov 4, 2004 · Built 1974 · Davhen Aero LLCN6688PPiper PA-24-250 · S/N 24-1329Cancelled May 13, 2002 · Triennial form not returned · Built 1960 · Davis John JN333JVRutan VARIEZE · S/N 947Cancelled Aug 22, 2001 · Triennial form not returned · Votaw James SN5JRAero Commander 1121 · S/N 49Cancelled Sep 9, 1998 · Triennial form not returned · Bowman Jacob CN50JPAero Commander 1121 · S/N 69Cancelled Jan 10, 1998 · Triennial form not returned · Bowman Jacob C JrN11219Cessna 421 · S/N 421-0165Cancelled Oct 31, 1977 · First National Lease CorpN6177FCessna 210J · S/N 21059077Cancelled Nov 7, 1975 · American Lease Plans IncN6486VHelio H-295 · S/N 1452Cancelled Mar 1, 1974 · American Lease Plans IncN7089DPiper PA-18A 150 · S/N 18-5577Cancelled Oct 25, 1973 · American Lease Plans IncN60419Cessna 150J · S/N 15070292Cancelled Aug 22, 1973 · American Lease Plans IncN9613FHughes 269C · S/N 700022Cancelled Jul 26, 1973 · Exported to United Kingdom · Tribble Construction CoN9546FHughes 269B · S/N 390417Cancelled Jul 17, 1973 · Exported to United Kingdom · Tribble Rufus BN9674WPiper PA-28-140 · S/N 28-23139Cancelled Jun 27, 1973 · Built 1967 · American Lease Plans IncN419FLPiper PA-28-140 · S/N 28-7125199Cancelled Apr 10, 1972 · Built 1971 · Carolina Fleets IncN5385SCessna 337A · S/N 337-0485Cancelled Mar 22, 1971 · Carolina Fleets IncN4896APiper PA-18A · S/N 18-4999Cancelled Feb 9, 1971 · Johnson Jr Ben FN66277Consolidated Vultee BT-13A · S/N 5253Cancelled Nov 24, 1959 · Johnson Ben FN3742PPiper PA-22-150 · S/N 22-3462Cancelled Jan 4, 1956 · Exported to Austria · Built 1955 · Ballentine Motors IncN96942Taylorcraft BC12-D · S/N 9242Cancelled Oct 17, 1955 · Built 1946 · Garrison Arthur L / Garrison Lillian JN46529Taylorcraft DCO-65 · S/N 04253Cancelled Oct 12, 1955 · Built 1942 · Robinson J BN46815Fairchild M-62A · S/N 5983AECancelled Oct 9, 1950 · Burriss FrankN71007Piper J3C-65 · S/N 18023Cancelled May 2, 1949 · Charles S WellsN2828Arkansas CX-3 · S/N 1Cancelled Feb 15, 1936 · Barnes J FletcherN974Alexander EAGLEROCK · S/N 226Cancelled Jul 1, 1935 · Built 1927 · Drake Howard T/Rosenberg SamN925Waco GXE · S/N 955Cancelled May 15, 1935 · Built 1927 · Adams Eugene JN1947Curtiss Wright JN4C · S/N M-708Cancelled Feb 7, 1933 · Foster Joe & Paul ParsonN1073Ludington Exhibition JN CLARK Y · S/N Y1Cancelled Oct 22, 1927 · Behr Howard SN3198KCessna 421A · S/N 421A0008Cancellation date not recorded · Carolina Fleets Inc
Back to Anderson, SC