While those with small yards might get by with an inexpensive, easy-to-store hand aerator, it makes more sense for the vast majority of DIYers to rent a lawn aerator ... like a push mower or ...
For the former, a smaller, hand-operated aerator is probably fine ... Think of them as larger versions of push-mower-style ...