Bridging flight operations and data science — from EBT/SBT training analytics and commercial strategy to network intelligence and product development. Based in Abu Dhabi, building tools that put real aviation insight in the hands of the people who need it.
I'm Cristian Villada — Aeronautical Engineer and Data Scientist currently serving as Flight Crew Training Officer (DS) at Etihad Airways in Abu Dhabi. I design EBT/SBT digital training programmes, build BI solutions, and develop Python automations across a fleet of over 106 aircraft.
Before Etihad I led commercial strategy and pricing at TAAG Angola Airlines — building their Google Cloud data infrastructure and BI framework from scratch — and worked in ancillary revenue and fuel analytics at Viva Air Colombia.
My work sits at the intersection of flight operations, commercial intelligence, and applied machine learning. The tools on this site are side projects that turn that expertise into something tangible and useful for the wider aviation community.
Aviation took me from the Andes to the Angolan coast to the Gulf — each move adding a new layer of operational context, commercial depth, and technical capability.
218 ZED agreements with the full fare matrix — SSC, ZEP, ZES, TC across Subload and Firm, Economy and Business. Interactive world map with 6 view modes, scenario builder, airline deep-dive with FR24 routes and fleet data for 38 carriers. One-click CSV and JSON export.
Etihad's full network and schedule intelligence — route scatter across 6 dimensions, 2025→2026 expansion map, Cirium schedule deep dive (58k+ flight records), and a live FR24 snapshot: 44 flights airborne, 37 destinations, 9 aircraft types with full registration lists and per-route intelligence.
Progressive web app for tracking pre-departure milestones and on-time performance. In-app alerts, background push notifications via Upstash QStash, and a service worker for offline capability. Built for Etihad pilots and crew operating in fast-paced turnaround environments.
Digital pilot logbook built for professional aviators — log flights, track hours by aircraft type, monitor currency and recency requirements, and maintain a complete aeronautical record compliant with regulatory standards. Clean, fast, and designed for cockpit professionals.
Technical blueprint gallery — Airbus A380-800 and A350 XWB. Structural analysis, aerodynamics, composite systems and general arrangement drawings rendered in full engineering-documentation style with interactive lightbox and category filtering.
Power BI dashboard suite for airline commercial analytics — revenue management, network performance, load factors, and schedule efficiency. Built with DAX and aviation-specific data models drawing on experience across TAAG and Etihad commercial teams.
Per-city layover guide — hotel tier, transport cost, must-do attractions, currency and tips, local crew recommendations, and best ZED routing for onward travel from each EY outstation.