AvDB Aviation Platform .
BigQuery cloud warehouse modeling 54.3M DOT flight records, featuring 1990s geodesic great-circle cartography, multi-airport catchment systems, and network route dynamics.
End-to-End Aviation Ingestion & Analytical Marts
Sourced from the U.S. Department of Transportation Bureau of Transportation Statistics (BTS) T-100 domestic segment reports and DB1B 10% Ticket Sample surveys.
DOT Raw Datasets
14.0M rows T-100 capacity data and 40.3M rows DB1B OD40 10% ticket sample ingested into raw BigQuery staging tables.
Catchment Systems
Mapping multi-airport metropolitan catchments (WAS → DCA/IAD/BWI, NYC → JFK/LGA/EWR, CHI → ORD/MDW) and airport code migrations.
Analytical Marts
Materialized summaries partitioned by month and clustered by route: reporting.mart_airport_network_summary & mart_airline_network_performance.
Interactive Web App
Streamlit multi-page interface deployed to Google Cloud Run with Google OAuth 2.0 authentication and PyDeck geodesic visualizers.
1990s Geodesic Route Atlas
Renders 2D geodesic great-circle lines hugging the surface with fixed-pixel pin nodes, IATA 3-letter typography, and concentric bullseye origin hub markers.
Unserved Target Proposals
Identifies unserved 1-stop connecting passenger flows, classifies Business vs. Leisure yield premiums, and proposes carrier expansion candidates.
Airline Network Dynamics
Multi-carrier route competition matrices, stage-length economics, historical merger lineage resolution, and fleet gauge capacity analytics.
Explore the interactive AvDB Streamlit application
Live on Cloud Run with full carrier fleet economics and airport catchment filters.