Use "of" not "in" but better is My ambition is to work as an aeroplane (airplane for me) pilot. I am an aeroplane pilot. And yes, there are other types of pilots, so saying airplane pilot is not as redundant as it may first appear.
New words, one handy idiom, and a 2-minute quiz — delivered to your inbox to keep your streak alive.