DuckDB Tutorial Uses 100,000 Caribbean Aircraft Records to Teach Streaming Data Queries

A new tutorial from the ADSBiq community project demonstrates how to query a free sample dataset of approximately 100,000 Caribbean aircraft state observations using DuckDB. The dataset, hosted on Zenodo and citable via DOI 10.5281/zenodo.22062551, covers aircraft positioned between 5 and 30 degrees north latitude and includes fields such as timestamp, callsign, position, altitude, and ground speed. Because real-world streaming data arrives as sparse differential updates rather than complete rows, the tutorial explains how to distinguish full state snapshots from partial diffs and how to forward-fill missing values. The guide walks through grid aggregation for geographic overviews, snapshot filtering for a specific Caribbean region, and trajectory reconstruction by partitioning on aircraft identifier and ordering by timestamp. The dataset is intended for educational and analytical purposes only and must not be used for navigation, separation, or safety-critical decisions.