Flight Oracle

This tool triangulates flight status using a required flight date and flight number plus an optional raw_data_json payload. Inputs are: date_iso as the flight departure date in ISO format YYYY-MM-DD, flight_number as the carrier code and flight number (for example CX509), and raw_data_json as raw JSON or text from external sources describing flight status and related details. When raw_data_json is present it is parsed and treated as the primary source of truth, and the tool must handle partial or missing data by returning an Unknown status and omitting or nulling fields that cannot be derived instead of failing or returning empty JSON, subject to what the output schema allows. All outputs must strictly validate against the system-provided structured output schema for normalized flight status, which is auto-produced and not included here, with no extra fields and correct types and value ranges.