On Debian-derived systems, the list can be found with:

  aptitude search '?installed ?not(?automatic)'

(or filter with that within the program, etc.)

There's probably a way without aptitude, but using Debian without aptitude is like riding a bicycle without gears.