If a private pilot is rated for the airplane, there's no size limit. Single engine or multi engine.
A private pilot with a type rating for a B747...can fly a B747.
Getting the type rating and getting in a position to be able to fly the aircraft...that's another matter.