Is the Key field of the Aircraft Master Aircraft table the tail #?
If so, you have two choices.
You can make a relationship based on that multiple choice field to the Master Aircraft table and then look up any fields that you need, and it will act identically to if you had a local list of aircraft.
If you have not done this before I suggest making a copy of you app to practice this first. Note that you will need to go to the Advanced Properties for the Master table to give this other app permission to create cross app relationships and also note that you need to build the relationship from the child side.
