Sep 2024 – Aug 2026
ATR — Aircraft Modification Database
Foreign Validation Apprentice Engineer
Built a Python database consolidating 30,000+ aircraft modification records across FAA, TCCA, and ANAC. Cut search time from 20 min → under 5 seconds. Used daily by 20–30 engineers at ATR / Airbus Group.
Context
ATR manufactures turboprop regional aircraft (ATR 42, ATR 72). Foreign validation engineers ensure that modifications to aircraft type certificates are validated across international regulatory authorities: FAA (USA), TCCA (Canada), and ANAC (Brazil).
The team was manually searching through 30,000+ modification records scattered across multiple sources — each search taking up to 20 minutes. The scale of the dataset and the frequency of daily lookups made this a genuine bottleneck across three teams.
What I Built
- Python database consolidating 30,000 aircraft modification records across FAA, TCCA, and ANAC. Reduced average search time from 20 minutes to under 5 seconds. In daily use by 20–30 engineers across foreign validation, commercial, and design office teams.
- Proposed and executed an AI-assisted development strategy to hit the team's 6-month target. Secured internal access to AI tools that were still in PoC stage at ATR at the time.
- Designed an internal HTML / CSS / JS web prototype to scope requirements and validate UX before the external production tool is delivered (ships August 2026).
Technical Stack
- Python — data pipelines, search engine, record normalization
- HTML, CSS, JavaScript — internal web prototype for UX validation
- FAA / TCCA / ANAC regulatory data formats
Impact
- 20 min → <5 s search time (240× faster)
- Daily use by 20–30 engineers across three teams
- Unified FAA + TCCA + ANAC records in one place for the first time
- Production tool ships August 2026