Search for actual departing flight number by codeshare flights number

FlightAware AeroAPI
1

Hi, everyone~

I’m looking for the following three flight numbers,
CI100, HA2830, JL5046
When I query CI100 through GET /flights/{ident} API, I can find the two codeshare flight numbers HA2830 and JL5046. However, I want to use HA2830 and JL5046 to look back for the actual flight number CI100, but I can’t do that.

Later, I discovered that I could find flight CI100 through the two flight numbers HAL2830 and JAL5046. However, I couldn’t find any information regarding the HA ↔ HAL and JL ↔ JAL mappings in the ICAO and IATA comparison tables available online.

Does FlightAware have its own internal mapping table or API that we can refer to?

In our current project, customers input flight numbers in the format HA2830 or JL5046, but our backend needs to automatically identify the corresponding flight CI100 for further processing. We are currently facing conversion issues because we cannot directly retrieve CI100 by searching HA2830 or JL5046. Instead, we first need to convert them to HAL2830 or JAL5046, then perform the search again to obtain CI100. However, we do not have access to a mapping table that provides the conversion information (e.g., HA ↔ HAL, JL ↔ JAL).

Could you provide guidance on resolving this issue? Thank you!

2

image
image824×942 58.6 KB

Later, I found some mapping tables on Wikipedia and some GitHub repositories, but I don’t know how to convert when the same two-digit IATA code corresponds to multiple three-digit ICAO codes, as shown in the picture. Additionally, since our project is in the financial sector, we need to ensure accuracy, as well as having the most up-to-date data that cannot be arbitrarily modified by the public. Does FlightAware provide an official comparison table or an API for conversion?