No, Yates did not win an Oscar for any Harry Potter film. Although he received nominations for Best Director for both "Harry Potter and the Order of the Phoenix" and "Harry Potter and the Deathly Hallows – Part 2," he did not ultimately win either award.
The David Yates Movie Magic: A Riveting Quiz on the Masterful English Filmmaker