search

mrjackwills / adsbdb

public api for aircraft, airlines, & flightroutes
https://adsbdb.com
MIT License
138 stars 6 forks source link

[NEW FEATURE] how to obtain callsign #25

Open ggoodloff opened 1 year ago

ggoodloff commented 1 year ago

It's there a way to obtain the Callsign based off the data retrieved from the mode-s query?

mrjackwills commented 1 year ago

Sadly not, it is basically a static database, so the CallSigns are not linked up the Aircraft's ModeS hex string.

It is a great feature to want to implement, but I think that it's quite far out of scope of the project at the moment.

ggoodloff commented 1 year ago

I understand, I loaded the Opensky .csv into a mysql database on my network I pull from. I just get trustee owners instead of the actual airlines, hence why I was trying to get the Callsign from a hex query.

Somewhere down the road.

Thanks for all your hard work.

On Wed, Mar 29, 2023, 9:18 PM Jack Wills @.***> wrote:

Sadly not, it is basically a static database, so the CallSigns are not linked up the Aircraft's ModeS hex string.

It is a great feature to want to implement, but I think that it's quite far out of scope of the project at the moment.

— Reply to this email directly, view it on GitHub https://github.com/mrjackwills/adsbdb/issues/25#issuecomment-1489587754, or unsubscribe https://github.com/notifications/unsubscribe-auth/A5FW5OWBXRS3ULHUGVH6CCLW6TUPPANCNFSM6AAAAAAWMTKBQU . You are receiving this because you authored the thread.Message ID: @.***>

mrjackwills commented 1 year ago

ah, can you give me an example, and I'll take a look

ggoodloff commented 1 year ago

A61fa4 from yours is great: registered_owner":"Hawaiian Airlines

From the Opensky database I have locally: Bcc Equipment Leasing Corp

I'm gonna work on implementing your API into my program, I do have times where it's a high traffic area that would query the API over the limit I think.

On Wed, Mar 29, 2023, 9:25 PM Jack Wills @.***> wrote:

ah, can you give me an example, and I'll take a look

— Reply to this email directly, view it on GitHub https://github.com/mrjackwills/adsbdb/issues/25#issuecomment-1489591709, or unsubscribe https://github.com/notifications/unsubscribe-auth/A5FW5OTJIHJYNBG7BMAAN3TW6TVIXANCNFSM6AAAAAAWMTKBQU . You are receiving this because you authored the thread.Message ID: @.***>

mrjackwills commented 1 year ago

Thanks, according to the search via the FAA, the owner is indeed Bcc Equipment Leasing Corp, whereas planespotters suggests that it's owned by Hawaiian Airlines.

I'm not knowledgeable to know which one adsbdb should use.

Also, the Opensky.csv data looks good, I think I had been made aware of it earlier, but should investigate it more

ggoodloff commented 1 year ago

I was using another API for my spotter bots and they would crash because the API server would get to busy and crash.

I wish theirs showed like yours does though.

Thanks for all your hard work though

On Wed, Mar 29, 2023, 9:52 PM Jack Wills @.***> wrote:

Thanks, according to the search via the FAA https://registry.faa.gov/AircraftInquiry/Search/NNumberResult?nNumberTxt=N494HA, the owner is indeed Bcc Equipment Leasing Corp, whereas planespotters https://www.planespotters.net/hex/A61FA4 suggests that it's owned by Hawaiian Airlines.

I'm not knowledgeable to know which one adsbdb should use.

Also, the Opensky.csv data looks good, I think I had been made aware of it earlier, but should investigate it more

— Reply to this email directly, view it on GitHub https://github.com/mrjackwills/adsbdb/issues/25#issuecomment-1489608516, or unsubscribe https://github.com/notifications/unsubscribe-auth/A5FW5OWAW4NDNDTXMG2NE3DW6TYN3ANCNFSM6AAAAAAWMTKBQU . You are receiving this because you authored the thread.Message ID: @.***>

ggoodloff commented 1 year ago

Sent you an email from your website

On Wed, Mar 29, 2023, 9:55 PM Gary Goodloff @.***> wrote:

I was using another API for my spotter bots and they would crash because the API server would get to busy and crash.

I wish theirs showed like yours does though.

Thanks for all your hard work though

On Wed, Mar 29, 2023, 9:52 PM Jack Wills @.***> wrote:

Thanks, according to the search via the FAA https://registry.faa.gov/AircraftInquiry/Search/NNumberResult?nNumberTxt=N494HA, the owner is indeed Bcc Equipment Leasing Corp, whereas planespotters https://www.planespotters.net/hex/A61FA4 suggests that it's owned by Hawaiian Airlines.

I'm not knowledgeable to know which one adsbdb should use.

Also, the Opensky.csv data looks good, I think I had been made aware of it earlier, but should investigate it more

— Reply to this email directly, view it on GitHub https://github.com/mrjackwills/adsbdb/issues/25#issuecomment-1489608516, or unsubscribe https://github.com/notifications/unsubscribe-auth/A5FW5OWAW4NDNDTXMG2NE3DW6TYN3ANCNFSM6AAAAAAWMTKBQU . You are receiving this because you authored the thread.Message ID: @.***>