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