mrjackwills / adsbdb

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

[DATA] Type returned for operator code for abe19d #12

Open ladewig opened 1 year ago

ladewig commented 1 year ago

Url of request https://api.adsbdb.com/v0/aircraft/ABE19D

Why was the data wrong The type "C68" is being returned for the operator code.

Additional context This is happening to multiple aircraft, so looks more like a bug than a data issue.

mrjackwills commented 1 year ago

Thanks,

Am trying to work out what the correct registered_owner_operator_flag_code should be, do you happen to know?

Due to the size of the original data set, I was unable to do any major data cleaning operation (other than some obvious country & airline typos)

ladewig commented 1 year ago

I'm still seeing you return the aircraft type as the operator three letter code on various aircraft. Any chance of that getting fixed?

mrjackwills commented 1 year ago

I am in the process of merging, and cleaning up, a lot of new data, as well as some refactors into how callsigns are stored in the database, as well as treated by the api, but it is a long, slow process

ladewig commented 1 year ago

One workaround as a temporary measure would be to compare the type and operator code for the aircraft to be returned and if they are the same, return null for the operator code. That would let you stop returning invalid data for that field while you do cleanup. I'm doing that on the data I'm currently pulling, but just a suggestion for other users.

Thanks!