This should find all manually installed packages on a Debian system:

aptitude search '~i!~E' | grep -v "i A" | cut -d " " -f 4