An Excel-based aircraft airworthiness and maintenance control system designed to consolidate aircraft records, airworthiness directives, defects, AMP tasks, life-limited parts, risk assessment, and maintenance planning into a dynamic control dashboard.
This project demonstrates how Microsoft Excel can be used to build an integrated aircraft maintenance monitoring system rather than a collection of disconnected spreadsheets.
The workbook uses a central aircraft selector to dynamically update aircraft-specific information across multiple maintenance and airworthiness views.
- Dynamic aircraft selection
- Aircraft fleet information
- Airworthiness Directive (AD) tracking
- AD compliance and due-date monitoring
- Defect and MEL category tracking
- AMP task monitoring
- Life-limited part monitoring
- Risk scoring and priority classification
- Attention-required monitoring
- Aircraft technical-log history
- Maintenance planning
- Maintenance packaging
- Dynamic maintenance dashboard
- Conditional formatting for maintenance priorities
- Automated cross-sheet calculations
The workbook is structured into several functional layers:
- Aircraft Information
- AD Status
- AMP
- CRS
- Technical Log
- Life Limited Parts
- Risk Priority
- Risk AMP
- Risk Defects
- Risk & Priority
- Attention Required
- Maintenance Planning
- Maintenance Packaging
- Aircraft History
The Dashboard provides a consolidated aircraft-level view of:
- Aircraft information
- Open ADs
- Overdue ADs
- Deferred defects
- Life-limited parts approaching limits
- AMP tasks due
- Maintenance planning priorities
Selecting a different aircraft automatically updates the relevant workbook views.
- Select an aircraft from the Dashboard.
- Review the aircraft's current information and status.
- Review outstanding ADs and compliance requirements.
- Check defects and AMP tasks requiring attention.
- Review risk and priority information.
- Review the maintenance planning schedule.
- Review maintenance packages generated from applicable tasks.
This project demonstrates practical use of:
- Microsoft Excel
- Dynamic array formulas
FILTERXLOOKUPCOUNTIFSLETCHOOSECOLS- Data Validation
- Conditional Formatting
- Cross-sheet data integration
- Automated maintenance-status logic
- Dashboard design
- Maintenance planning logic
- Risk-based prioritization
The purpose of this project is to demonstrate practical understanding of aircraft maintenance and airworthiness workflows while applying spreadsheet automation and data-management techniques to create a functional maintenance-control system.
This project was developed as an academic and portfolio project to demonstrate skills relevant to aircraft maintenance, airworthiness, MRO, and aviation engineering environments.
This is a student-developed demonstration project using fictional/sample aircraft maintenance data.
It is not intended for operational aircraft maintenance, regulatory compliance, or use as an approved aviation maintenance-control system.
Mohammed Faraz Ahmed
Aerospace/Aeronautical Engineering Student