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

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