This looks similar to my project <a href="https://github.com/ClickHouse/adsb.exposed/">https://github.com/ClickHouse/adsb.exposed/</a>, which allows us to analyze this data in real-time and is much simpler and elegant.