I'll ignore other destinations, but for the two most likely of Boston and New York, the A332 can do both, fully loaded. The A333 can only do Boston.
Ignore who has these for the moment, but A350 and 787 can do anywhere in North America from Cork.
I also echo 840's assessment.