Tools For Capturing PiAware Data in MySQL/MariaDB Database

FlightAware ADS-B Flight Tracking
1

A few weeks ago I posted about “Analyzing Minimum Altitudes in Range Rings”. Since then I have taken the project to a new level. It is capturing data from PiAware and a local copy of the FAA Registry. As the data is processed I am adding additional data elements that can be queried for deeper analysis.

All of the code has been made available on GitHub. This is still an early stage project so there are frequent changes being made.

This is a non-trivial installation that requires you to be familiar with a Linux command line, but nothing is too challenging. Feel free to pull the code down and give it a spin.

2

Something similar regarding MySQL storage, but already some years old:

3

I added a new graph to show the RSSI at ranges. I’m working on antenna position and this has been helpful to see where I’m getting the best reception. More to come…

Screen Shot 2025-05-19 at 8.37.57 AM
Screen Shot 2025-05-19 at 8.37.57 AM614×653 64.9 KB