Triggering Emails Based on Field Status

Hello,

I am trying to automate an email either by email notifications or a Pipeline based on updating a related field.

I have 3 tables:
1. All Flights
          - Enter any new flight in the schedule
          - I have a field called "flight verification" that is a multiple choice field allowing to show the flight as "pending" or "final.")
          - I have another multiple choice field for "Flight Status" with options "Active" or "Flown"
2. Current Flights
           - Connected to "All Flights" and pulls only "Active" flights
3. Request Log
            - Where passenger requesting a seat are entered
           - I have a related field from "Current Flights" so there is a drop down menu that only allows you to select "Active" flights
- There is also a related field for the "Flight Verification"


I would like to trigger an email that sends the list of passengers entered in the "Request Log" when "Flight Verification" status is changed to "Final."  Since this is a related field, this field changes when the "All Flights" table is updated and the subsequent tables are refreshed.   Is this possible?

I don't think the email notification will work since the field in the "Request Log" table isn't being updated and saved.  Is it possible to utilize pipelines?  If so, how do I do this to include a table of passenger information from the request log?

Thank you!