Finder - search in specific subfolders across the whole drive
You can make a script that uses the find command and the dirname command to do this but as for doing it in spotlight somehow I don't think so. If you'd like to see a one-liner to do this on the command line I can do this, but it depends on what you want it to output- the containing directory or the full path to the file.