I'm not exactly sure about the painted turtle status. I don't keep all 486 in my head. This may well be federally listed, but I don't believe so. However, on the way the legislation and the accord works, each jurisdiction can--and in many cases does--have their own endangered species or species at risk legislation. For example, in Quebec or B.C. they have legislation, and they may list species provincially that may or may not be listed federally. Even if it is listed provincially and federally, it may or may not be at the same status, because in one jurisdiction it may be highly endangered, and in another jurisdiction it may be of special concern.
On March 1st, 2011. See this statement in context.