Lots of good schools all over the world. Many stand out in the US and Europe. However there are only a handful of US schools doing JAA/EASA training. Forget about FAA-JAA/EASA Conversions it's a dead end now, will cost you too much and will be a paperwork nightmare. At 41, you would need considerable hours before applying to any airline by the time you are done with 200-250 hours. I'm talking in the 2000 plus range at the very least. If you are very lucky, you may be able to land an instructor job or air-taxi charter job. You may even have to work towing gliders without pay, such a position is regarded as gold dust these days.
Find a good club type school, take a trial lesson, if you like it do your Private licence, then build your hours, study for the ATPL theory, etc, etc. This gives you the flexibility to opt out or change schools if it's not working out for you. Your fellow crew up front should be able to guide you to some extent, especially if they do any private flying.