OpenAirDocs.org
West Helena, AR

Cancelled registrations · 110

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 = 'AR' AND d.registrant_city = 'WEST HELENA'
  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.

N3109DBeech B36TC · S/N EA-475Cancelled Sep 17, 2026 · Exported to Namibia · Built 1988 · South Delta Aviation IncN10YPBeech 65-A90 · S/N LJ-265Cancelled May 3, 2018 · Registration expired, pending cancellation · Built 1967 · South Delta Aviation IncN8188RBeech 95-B55 (T42A) · S/N TC-1761Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1974 · South Delta Aviation IncN8517MAir Tractor AT-602 · S/N 602-1126Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 2004 · South Delta Aviation IncN78614Cessna 172K · S/N 17257687Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1968 · Crowley Ridge Aviation IncN10DGCessna 182P · S/N 18262608Cancelled Mar 17, 2017 · Exported to Guatemala · Built 1974 · South Delta Aviation IncN12131Cessna 172M · S/N 17261829Cancelled Feb 4, 2017 · Revoked, canceled · Built 1973 · Harry Charlie LN75678Boeing E75N1 · S/N 75-8366Cancelled Feb 4, 2017 · Revoked, canceled · Alder Mccarty Flying Service IncN3163UAir Tractor AT-400 · S/N 400-0512Cancelled Sep 16, 2016 · Exported to Mexico · Built 1983 · South Delta Aviation IncN6442BBeech A36 · S/N E-1957Cancelled Dec 3, 2015 · Exported to Philippines · Built 1982 · South Delta Aviation IncN42210Air Tractor AT-502B · S/N 502B-2674Cancelled Oct 15, 2015 · Exported to Canada · Built 2009 · South Delta Aviation IncN7080GCessna 172K · S/N 17258780Cancelled Dec 2, 2014 · Revoked, canceled · Built 1969 · Harry Charlie LN14SCBeech 95-B55 (T42A) · S/N TC-720Cancelled Aug 26, 2014 · Exported to Philippines · Built 1964 · South Delta Aviation IncN23189Air Tractor AT-301 · S/N 301-0366Cancelled Feb 25, 2014 · Exported to Honduras · Built 1981 · South Delta Aviation IncN2318QAir Tractor AT-301 · S/N 301-0365Cancelled Nov 18, 2013 · Exported to Nicaragua · Built 1981 · South Delta Aviation IncN6451HPiper J3C-65 · S/N 19629Cancelled Nov 8, 2013 · Registration expired, pending cancellation · Built 1946 · Robason Gene AN4732SPiper PA-32-260 · S/N 32-1171Cancelled Aug 30, 2013 · Exported to Dominican Republic · Built 1969 · South Delta Aviation IncN40117Ayres S2R-T15 · S/N T15-003Cancelled Aug 23, 2013 · Sale reported, canceled · Built 1979N64926Boeing A75N1(PT17) · S/N 75-1653Cancelled Aug 6, 2013 · Revoked, canceled · Built 1941 · Alder Mccarty Flying Service IncN4619EWeatherly 620 · S/N 1513Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Built 1982 · South Delta Aviation IncN59117Boeing E75N1 · S/N 75-8075Cancelled Feb 26, 2013 · Revoked, canceled · Alder Mccarty Flying Service IncN57932Boeing E75N1 · S/N 75-4839Cancelled Feb 21, 2013 · Revoked, canceled · Built 1943 · Alder Mccarty Flying Service IncN53543Boeing E75N1 · S/N 75-8525Cancelled Dec 18, 2012 · Sale reported, canceledN4445QCessna A188B · S/N 18800845Cancelled Dec 17, 2012 · Exported to Paraguay · Built 1971 · South Delta Aviation IncN4911NBoeing B75N1 · S/N 75-7615Cancelled Dec 7, 2012 · Sale reported, canceledN5274Grumman G-164A · S/N 559Cancelled Sep 18, 2012 · Sale reported, pending cancellation · Built 1968N4729MPiper PA-11 · S/N 11-241Cancelled Aug 6, 2012 · Revoked, canceled · Built 1947 · Cunningham James RN469RBoeing B75N1 · S/N 75-7439Cancelled Aug 1, 2012 · Revoked, canceled · Built 1943 · E E Terry IncN354MRPiper PA-28-181 · S/N 2843315Cancelled Jul 30, 2012 · Exported to Australia · Built 2000 · South Delta Aviation IncN3667ZBeech A36TC · S/N EA-91Cancelled Feb 3, 2012 · Exported to Argentina · Built 1980 · South Delta Aviation IncN759DMCessna 182Q · S/N 18265911Cancelled Jan 6, 2012 · Exported to Canada · Built 1977 · South Delta Aviation IncN3260BBeech A36 · S/N E-2959Cancelled Oct 11, 2011 · Exported to Brazil · Built 1995 · South Delta Aviation IncN8521LAir Tractor AT-602 · S/N 602-0703Cancelled Sep 7, 2011 · Third renewal notice · Built 2004 · South Delta Aviation IncN9833PPiper PA-25-260 · S/N 25-7556151Cancelled Sep 7, 2011 · Exported to Argentina · Built 1975 · South Delta Aviation IncN75BPCessna 182P · S/N 18264520Cancelled Apr 14, 2011 · Exported to Canada · Built 1976 · South Delta Aviation IncN3102BAyres S2R-T34 · S/N T34-133DCCancelled Jan 31, 2011 · Exported to Philippines · Built 1990N203HWSK PZL Mielec M-18 DROMADER · S/N 1Z004-09Cancelled Jan 3, 2011 · Expired dealer · Riddell Flying Service IncN2150QCessna 177RG · S/N 177RG0550Cancelled Jan 3, 2011 · Expired dealer · Built 1974 · Riddell Flying Service IncN4940XRockwell International S-2R · S/N 5001RCancelled Jan 3, 2011 · Expired dealer · Built 1975 · Riddell Flying Service IncN5345Grumman G-164A · S/N 625Cancelled Jan 3, 2011 · Expired dealer · Built 1969 · Riddell Flying Service IncN31215Cessna A188A · S/N 18800602Cancelled Jun 25, 2010 · Exported to Argentina · Built 1970 · South Delta Avaition IncN30914Maule M-7-235 · S/N 4129CCancelled May 3, 2010 · Exported to Kazakhstan · South Delta Aviation IncN934XGrumman G-164A · S/N 446Cancelled Sep 16, 2009 · Registration revoked · Built 1967 · Riddell Flying Service IncN9943GCessna A188A · S/N 18800743Cancelled Aug 14, 2009 · Exported to Paraguay · Built 1974 · South Delta Aviation IncN6105ZPiper PA-25 · S/N 25-122Cancelled Dec 29, 2008 · Exported to Argentina · South Delta Aviation IncN4844QCessna A188B · S/N 18802580TCancelled Nov 12, 2008 · Exported to Paraguay · Built 1976 · South Delta Aviation IncN7326QCessna 172M · S/N 17267582Cancelled Aug 15, 2008 · Exported to Uruguay · Built 1976 · South Delta Aviation IncN620SDWeatherly 620B · S/N 1627Cancelled Mar 25, 2008 · Exported to Uruguay · South Delta Aviation IncN40445Thrush S2R-T34 · S/N T34-275Cancelled Dec 19, 2007 · Exported to Ecuador · A & L Farm Services IncN8980GCessna A188B · S/N 18801335TCancelled Nov 9, 2007 · Exported to Philippines · Built 1973 · South Delta Aviation Inc
Back to West Helena, AR