Pacpal is a tool which combines several Pacman-related Perl scripts. Among other things, it can list all executable files owned by a package or list all unpackaged files in a given path. Please read the man page for more information and a complete list of what it can do.