I'm not aware of any dual-use (soccer and US football) stadiums being used at present. I think the main issue is the differing dimensions of the pitch required for soccer vs US football. I'd be curious if anyone has seen a dual-use stadium.
http://en.wikipedia.org/wiki/Soccer-specific_stadium