Roddy - born Roderick George Toombs - is believed to have died in his sleep.
His representative told the website: "I am devastated at this news. Rod was a good friend as well as a client and one of the most generous, sincere and authentic people I have ever known. This is a true loss to us all."
And a family member added: "Our family is saddened by the sudden passing of our father and beloved husband, Roderick Toombs aka Rowdy Roddy Piper."
He is survived by his wife Kitty and their four children.
Roddy had been diagnosed with Hodgkin's Lymphoma in 2006 but was cancer-free at the time of his death.