One portion of our lawn was looking a little brown and water seemed to run right off it into the drain, so I decided it needed a good aerating. I bought this manual aerator on Amazon and went to town.
It worked pretty darn well, with each subsequent stab pushing out the core of the previous one. Now it looks like we have a bunch of little turds on the lawn. I hope it helps.