If one did want to become a pilot, I do think it would be critical to determine whether or not they were prone to manic episodes. That really could be very dangerous to a pilot and their crew, passengers, etc.
Also, from my 15 minutes of preliminary research, I don't think that applies to pilots of ultralights. So if your dream is simply to fly, it's still achievable.
