mrjackwills / adsbdb

public api for aircraft, airlines, & flightroutes

Mr Jack Wills

todo

• waste time creating a clean, simple, readable svg profile logo, which github won't display correctly
• change more repositories from private to public
• make a decent README.md

projects

name	description	language(s)	other notes
oxker	A simple tui to view & control docker containers	Rust	also published to crates.io, Docker Hub, and ghcr.io
adsbdb	A public api for aircraft, airlines, & flightroutes	Rust	adsbdb.com, TypeScript branch in repo
havn	A fast configurable port scanner with reasonable defaults	Rust	also published to crates.io, Docker Hub, and ghcr.io
Obliqoro	A cross-platform tauri gui where Oblique Strategies meets Pomodoro	Rust + Vue + TypeScript
staticPi_backend staticPi_frontend	The simple websocket messaging service	backend: Rust frontend: Vue + TypeScript	staticpi.com - invite on request
mealpedant_backend mealpedant_frontend	Daily (8+ years) meal tracking full-stack application	backend: Rust frontend: Vue + TypeScript	mealpedant.com - invite on request, TypeScript backend branch
leafcast_backend leafcast_frontend	Plant camera full-stack application	backend: Rust frontend: Vue + TypeScript	see the plants - password on request
belugasnooze_backend belugasnooze_frontend	Sunrise alarm clock full-stack application	backend: Rust frontend: Vue + TypeScript	belugasnooze.com - password on request, TypeScript backend branch
flightbox_backend flightbox_frontend	At home flightracker live data full-stack application	backend: Rust frontend: Vue + TypeScript	live flights - password on request
mrjackwills_vue	Personal portfolio website/PWA	Vue + TypeScript	mrjackwills.com

adsbdb's Issues

[NEW FEATURE] Update to postgres 15

Describe the solution you'd like
Update to postgres 15, currently waiting for alpine postgres15-client to be available - for backup container

[BUG]

the coming from and going to airports are the same on most of the flights

[NEW FEATURE] FAA search

Is your feature request related to a problem? Please describe.
Use the n-number to search FAA db for unknown aircraft

eventually search foreign db's as well

[NEW FEATURE] Public rust response serde API

Is your feature request related to a problem? Please describe.
When calling this library from Rust code, I would like the responses to use the same data structure as this library.

Describe the solution you'd like
Release a library exporting https://github.com/mrjackwills/adsbdb/blob/main/src/api/response.rs as a public API.

[DATA] VH & ZK, DQ, etc

Url of request
[What was the url of the request that was made]
(https://api.adsbdb.com/v0/aircraft/VH-X4A)

Why was the data wrong
Which aspect of the response data was incorrect?
No Data, VH is downloadable like the N-reg system, they include numbers now! -see below-

Source of information
[If possible, would you be able to provide a link that shows the correct data?]
(https://www.casa.gov.au/aircraft/aircraft-registration/data-files-registered-aircraft#Tipstodownloadthefiles)

Additional context
Add any other context about the problem here.
This can be applied to other sites like ZK, DQ.
Need to introduce prefix filter to different database to allow for no/low change to store info.

[DATA] SKW9799 is 'special'

Url of request
https://api.adsbdb.com/v0/callsign/SKW9799

Why was the data wrong
this callsign is 'special'. SkyWest appears to use it for test flights and when shuttling aircrafts.
Right now, as I type it, it's a plane transfer flight from Palm Springs to Seattle, yesterday they used it to move a plane from Spokane to Portland.

Additional context
This isn't a flight with a 'regular' route at all - so giving one of the past values for it might not be the right thing to do.

[DATA] EJA / 1L airline code

Url of request
any request for an EJA or 1L (NetJets) flight

Why was the data wrong
Because these aren't scheduled flights - they are on demand. So storing them as 'routes' really doesn't make much sense.

[DATA] Type returned for operator code for abe19d

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.

502 Bad Gateway Error on web page.

When I look up the aircraft information for Aircraft registration: PR-AYZ I get 502 Bad Gateway address on the web page.

Steps to reproduce the behavior:

1. Goto https://api.adsbdb.com/v0/aircraft/pr-ayz
2. Wait about 10 - 20 seconds.
3. Will return an error message.

502 Bad Gateway
mrjackwills.com

Expected behavior

To return valid registration information for this Aircraft

Desktop (please complete the following information):

• Windows 11 using chrome / edge.

Additional information.

Flight Radar returns the aircraft information but no flight data is returned.

[DATA] Type returned for operator code for a87f4d

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

Why was the data wrong
The ICAO type (E50P) is being returned for the registered_owner_operator_flag_code.

Additional context

[DATA] DAL2393

Url of request
https://api.adsbdb.com/v0/callsign/DAL2393

Why was the data wrong
as of last week this is no longer BOS-LAS but instead SFO-SEA

[NEW FEATURE] put rate limits in app_env

Is your feature request related to a problem? Please describe.
Upper and lower rate limits are currently hard-coded into the source code, making changing them require a re-compile/re-build.

Describe the solution you'd like
Put the rate limits into the .env, so that restarting the container will use the new rate limits, without a rebuild/re-release

[DATA] DAL2090

Url of request
https://api.adsbdb.com/v0/callsign/DAL2090

Why was the data wrong
This is SJC-SEA and not JFK-TPA

[NEW FEATURE] Callsign classification

Describe the solution you'd like
Serialize incoming callsign into ICAO, IATA or Other

Additional context
Callsign JSON response should include both callsigns, as well as the carrier - if applicable

[BUG] Rate limiter

Describe the bug
There is an issue with the rate limiter, where the TTL is reported as 1, and points are reported over 200, but the TTL does not reset correctly

Appears to occur after application has been running for one week

To Reproduce
Struggle to replicate, only noticed twice when checking status of site

Expected behavior
Rate limits & TTL get reset correctly

Additional context
Keep checking the status of the site, and check internal redis database to get the value of the Ratelimiter, in points, and the TTL

[NEW FEATURE] Return registration for non-US aircraft

Only US aircraft return a registration number. Given that the field is called "n_number" and not "registration", I'm assuming that's intentional, but that's a pretty important piece of information to leave out. It would be helpful if the registration were returned for all aircraft where one is known.

[DATA]

Url of request
https://api.adsbdb.com/v0/callsign/SWA1593

Why was the data wrong
At the time of the query (2023-04-07 22:37:50) the flight was SAN -> OAK

Additional context
Spotted from the Bay Area

[NEW FEATURE] Return flightroute for search with registration

I would like to know the current position and flight details for a specific aircraft registration.
Would it be possible to include the current flightroute, callsign etc when looking up https://api.adsbdb.com/v0/aircraft/[MODE_S || REGISTRATION] (without knowing the current callsign)?

[DATA] incorrect route for DAL1088

Url of request
https://api.adsbdb.com/v0/callsign/DAL1088
Why was the data wrong
data returned indicates a flight from YUL to ATL
the flight is actually LAX to SEA

[DATA] missing aircraft

Url of request
[What was the url of the request that was made]
(https://api.adsbdb.com/v0/aircraft/se-rta)

Why was the data wrong
Which aspect of the response data was incorrect? Aircraft not found

Source of information
If possible, would you be able to provide a link that shows the correct data? https://www.flightradar24.com/data/aircraft/se-rta#

Additional context
Add any other context about the problem here.
Find many missing planes, especially from Norwegian.

BTW, thanks a lot for providing this service, really a nice, clean, free and excellent API - Thank you !

I am new to this, so I could be wrong, but A/C lookup have succeeded many times, but also failed sometimes as described above.

Best regards,
Peter

[NEW FEATURE] Return IATA callsign for flight

Would it be possible to return the IATA callsign for a flight for a /callsign request. E.g., for https://api.adsbdb.com/v0/callsign/QFA409, could it return QF409? For many flights this is straightforward (just change that airline ICAO code its IATA code, e.g. QFA to QF), but for some it is trickier, e.g., QLK10 is QF2010.

Additional context: I've been building a split flap display (using https://github.com/scottbez1/splitflap) to show the planes flying overhead (what I've built: https://photos.app.goo.gl/SUe6HfQkHJN3Eo6X9). I've got an ADS-B receiver set up to get the callsign then use this API in order to get the route (thankyou!). But I'd also like to display the flight callsign in the form that people are more familiar with (and so that it will always fit on my 6 character display!).

[DATA] missing G-POLU, G-HMGD, G-HMGE

Url of request
https://api.adsbdb.com/v0/aircraft/G-POLU
https://api.adsbdb.com/v0/aircraft/G-HMGD
https://api.adsbdb.com/v0/aircraft/G-HMGE

Why was the data wrong
No data - unknown aircraft

Source of information
https://www.caa.co.uk/aircraft-register/g-info/search-g-info/

Additional context
N/A

[NEW FEATURE] n-number & icao routes

Describe the solution you'd like
add two new routes /icao, and /n-number, to convert from one to the other

/icao/A897E4 => N653AE
/n-number/N653AE => A897E4

[NEW FEATURE] how to obtain callsign

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

[DATA] SKW4040

Url of request
https://api.adsbdb.com/v0/callsign/SKW4040

Why was the data wrong
instead of ATL-HPN this is a flight that goes back and forth (sadly, both directions, same flight number, again) between SEA and MFR

[NEW FEATURE] remove environmental variables

Load up environmental variables from a read only mounted volume, need to adjust api_healthchceck to read this file

Following registrations return no information.

The following Aircraft registrations return unknown aircraft. They do exist in Flight Radar 24. Use the following URL:

https://api.adsbdb.com/v0/aircraft/

A6-WAB
CS-TAX
CS-TAY
SE-RSR
SE-RSS
SE-RST
C-GKQN
TC-MCU

[DATA] DAL1045

Url of request
https://api.adsbdb.com/v0/callsign/DAL1045

Why was the data wrong
api returns JFK-LAX, the flight is actually LAX-SEA

[DATA] SKW 3370 is changing

Url of request
https://api.adsbdb.com/v0/callsign/SKW3370

Why was the data wrong
SkyWest changes route on many of their flights fairly frequently. This one is currently used for both directions of Seattle / Rogue Valley, but starting on Thursday it will switch to Seattle Glacier Park

Additional context
I really don't know what the best way is to deal with flights like that... especially the increasingly common practice that both directions of a city pair have the same flight number...

[NEW FEATURE] Batch Requests

Is your feature request related to a problem? Please describe.
I'm trying to make an initial batch query of ~15 aircraft callsigns to populate a map. From that point on, with caching, it would only be the addition of new callsigns that triggers a request. Still, I imagine it's better for all involved if the first request could be batched.

Describe the solution you'd like
Expose a REST endpoint with a reasonable batch size limit:
https://api.adsbdb.com/v0/callsign?callsigns=ACA123,ACA321

Describe alternatives you've considered
Looping through individual queries within the bounds of the rate limit.

Additional context
Love this service! Exactly what I'm after for my little hobby project.

[DATA] SWA2238

Url of request
https://api.adsbdb.com/v0/callsign/swa2238

Why was the data wrong
This is now PDX-PHX

We gotta automate this :)

[DATA] VOI200

Url of request
https://api.adsbdb.com/v0/callsign/VOI200

Why was the data wrong
Showed as MID -> MEX, should have been MEX -> OAK

Additional context
Spotted at 2023-03-26 19:49:19 Pacific