Codeshares are not Synchronized

FlightAware AeroAPI
1

Using the GET /airports/{id}/flights endpoint with params

id = CYVR
airline = WJA

one of the results i receive is the following

{
      "ident": "WJA723",
      "fa_flight_id": "WJA723-1640128560-schedule-0389",
      "operator": "WJA",
      "operator_iata": "WS",
      "flight_number": "723",
      "registration": "C-FWVJ",
      "atc_ident": null,
      "inbound_fa_flight_id": "WJA430-1640110560-schedule-0072",
      "codeshares": [
        "AFR3026",
        "CES1992",
        "CPA7047",
        "DAL6890"
      ],
      ...

Note codeshare "DAL6890". What i would expect is that if i were to use the /flights/{ident} endpoint with DAL6890 as the param, i would see “WJA723” as a codeshare, by the nature of ‘transitive properties’ and all that.

However my results are not accurate. I receive WEN3194 and it doesn’t even contain a codeshare for WJA723.

"flights": [
    {
      "ident": "WEN3194",
      "fa_flight_id": "WEN3194-1640176200-schedule-0002",
      "operator": "WEN",
      "operator_iata": "WR",
      "flight_number": "3194",
      "registration": "C-FOEN",
      "atc_ident": null,
      "inbound_fa_flight_id": "WEN3197-1639542790-airline-0059",
      "codeshares": [
        "DAL6890",
        "DAL7258",
        "JAL5725",
        "KLM9695",
        "WJA3194"
      ],
      ...

This result would completely ruin someones (or multiple people’s) day if this api were to be relied upon and not double checked in my application. So this is something that really need to be addressed.

Interestingly if i search DL6890 on google, the auto top result thing is sourcing flightaware for the result, as well as flightstats and OAG. When i click the source link for flightaware, it does take me to the correct flight on the flightaware website. So somehow google is able to find the correct flight, but i cannot? What’s going on?