Welcome to Radarspotting. Please login or sign up.

September 25, 2025, 05:59:16 AM

Login with username, password and session length

New Members

New Members

You should get an activation email when you join.  If not, please use the Contact option.

[Free API] Including ICAO24 Hex to Aircraft Registration/Type/Airline & Routes

Started by joshuadouch, June 12, 2016, 02:41:05 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

joshuadouch


[2021 EDIT - I'm now maintaining this monthly. Check out https://api.joshdouch.me/]

[2019 EDIT - These URLs are outdated. Please see https://api.joshdouch.me/]


Hey!
When I first made my DVB-T radar I wanted to add more details about the aircraft but there weren't any/any free ways to get that data openly. Using a BaseStation.sqb database I found somewhere online I made something that will allow you to do what I wasn't. I don't know if there is anything available now but anyway I made this:

How to use & API links (neater than below): https://api.joshdouch.me/

Aircrafts - converting ICAO24 Hexidecimal codes to the aircraft's registration (e.g. G-EZBV), type (e.g. Airbus A319-111) or airline (e.g. Easyjet).

ICAO24 Hex - Aircraft Registration https://ae.roplan.es/api/hex-reg.php?hex=PUT_HEX_HERE
ICAO24 Hex - Aircraft Type https://ae.roplan.es/api/hex-type.php?hex=PUT_HEX_HERE
ICAO24 Hex - Airline https://ae.roplan.es/api/hex-airline.php?hex=PUT_HEX_HERE

Routes - converting a callsign to the aircrafts route (e.g. EGLL-LEBL).

Callsign - Route https://ae.roplan.es/api/callsign-route.php?callsign=PUT_CALLSIGN_HERE
Callsign - Destination(ICAO) https://ae.roplan.es/api/callsign-des_ICAO.php?callsign=PUT_CALLSIGN_HERE
Callsign - Destination(IATA) https://ae.roplan.es/api/callsign-des_IATA.php?callsign=PUT_CALLSIGN_HERE
Callsign - Origin(ICAO) https://ae.roplan.es/api/callsign-origin_ICAO.php?callsign=PUT_CALLSIGN_HERE
Callsign - Origin(IATA) https://ae.roplan.es/api/callsign-origin_IATA.php?callsign=PUT_CALLSIGN_HERE

Airports - converting IATA/ICAO airport codes to airport name.

IATA - Airport https://ae.roplan.es/api/IATA-airport.php?iata=PUT_IATA_HERE
ICAO - Airport https://ae.roplan.es/api/ICAO-airport.php?icao=PUT_ICAO_HERE



Use for whatever you like although please give me some credit (ae.roplan.es) ;)

Hope this helps someone?

Anmer

Thanks for sharing this.

Does this work for all allocated hex codes for all countries?
Here to Help.

joshuadouch

The database isn't very up to date but it does work for most airlines/countries slightly older fleet. If somebody could send me an updated BaseStation.sqb I will update the website with it.

graeme61

Hi Josh

I just finished the Matt Dyson FlightPi project and got it up and running.
Unfortunately the url was outdated in the FlightDetails.py which gave an error.
Through searching the commits on his github i came across the FlightDetails file with (Thanks to 'joshuadouch' for the API - https://radarspotting.com/forum/index.php?topic=6117.0)
I went to the link and copied the info required to remove the error in FlightPI.
This worked first time .
So i thank you for making the data available .

Would you like an up to date Basestation.sqb from my 24/7 SBS1-ER setuphere in Aberdeen,Scotland,UK

Kind Regards
Graeme

Andos

Hi Josh,
            I have for sometime now been trying to find a way to populate Field 13 (Generic Name) on my BaseStation (now using a FlightAware dongle) with Routes. I suspect that another .sqb file might be required but I am interested to learn how you have managed to achieve this. 

Do the routes populate both in your BaseStation's  Aircraft and on screen?


                   Brgds,

                            Andos.
Andos.

joshuadouch

Hey guys!

I didn't realise how much this was used.

I have just updated all of the databases and moved it onto its own box. I plan on maintaining this monthly in line with new database releases.

Enjoy!

https://api.joshdouch.me/

ebc