It's not a matter of where you travel to...but where you get paid from. I travel all over the world for Coyle, but am paid and 1099'ed in US funds, from an American company.
Since it's a business-to-business transaction, I don't think there is any issue with a Canadian contractor working for an American company. It may make a bit work work at tax time, though.