This may work, although I don't understand why the date for AB22 shouldn't be 2017-02-09?

WITH MaxDates AS (
    SELECT
         STAT_CODE
    ,    DATE
    ,    PART_NO
    ,    MAX(DATE) OVER (PARTITION BY STAT_CODE)) AS MaxDate
    )
UPDATE MaxDates
SET DATE = MaxDate

John