Thank you for this! A very comprehensive, helpful, and complete response.
Your statement: "you want a list of pilots who could be assigned to take a flight on 9-Feb-2020." almost hits the mark. "Available" in my world, only refers to a pilots rotation (in my case, the 8 or 15 days that a pilot...