I heard this noise in my backyard and was surprised to see this woodpecker. I guess the surprise was more in how big it was in relation to the smaller more common woodpeckers I am used to seeing. I was also surprised by the red head. I did some searching and believe it is a Pileated Woodpecker. Sadly, I have not seen or heard him anymore.