Skip to main content
AERONAV AMO Hero Light

​
Welcome to AERONAV AMO ✈️

AERONAV AMO is a modern, aviation-grade inventory management system designed specifically for Aircraft Maintenance Organizations. Track serialized parts, manage issuance workflows, and maintain complete traceability—all in one powerful platform.

Quick Start

Get up and running in under 5 minutes

API Reference

Explore our comprehensive API documentation

Database Schema

Understand the data structure and relationships

Best Practices

Learn tips and tricks from aviation experts
New to inventory systems? No worries! This documentation will guide you through every feature, from basic inventory tracking to advanced requisition workflows.

​
🎯 What Can You Do?

Manage both serialized components (individual tracking) and bulk items (quantity-based) with intelligent grouping and expandable views.
Use serialized tracking for critical components like engines, propellers, and avionics. This ensures full traceability for regulatory compliance!
Process part issuances with automatic inventory deduction, movement logging, and requisition creation.
Always verify aircraft registration and technician details before issuing parts. Incorrect data can lead to audit issues!
Create, approve, reject, and track requisitions from creation to completion with full status management.
Export stock movement history, issuance logs, and inventory reports in PDF or CSV format for regulatory compliance.
All reports include timestamps and user attribution for complete audit trails.
Import hundreds of parts in seconds with intelligent duplicate detection and quantity merging.
Download our CSV template to ensure your data is formatted correctly before upload!

​
🚀 Key Features

Real-Time Sync

Instant updates across all users

Low Stock Alerts

Automated threshold monitoring

Role-Based Access

Secure permission management

Complete Audit Trail

Track every stock movement

Mobile Responsive

Access anywhere, anytime

Export Everything

PDF and CSV reports
Aviation Compliant: Built to meet AMO traceability and regulatory requirements

​
📊 System Architecture

Understanding the architecture helps you troubleshoot issues and optimize performance!
The system uses Supabase for backend services, providing instant APIs, real-time subscriptions, and PostgreSQL database—all in one!

​
🛠️ Tech Stack

LayerTechnologyPurpose
FrontendReact 18 + TypeScriptComponent-based UI with type safety
StylingTailwind CSS + Shadcn UIModern, responsive design system
BackendSupabaseDatabase, authentication, real-time
StateReact Hooks + Local StorageClient-side state management
BuildViteLightning-fast development
RoutingReact Router v6Client-side navigation
All technologies are open-source and production-ready!

​
🎓 Core Concepts

​
Understanding Serialized vs Non-Serialized Parts

Serialized parts have unique serial numbers and are tracked individually.Examples:
  • Aircraft engines (S/N: ABC123456)
  • Propellers (S/N: PR-7891)
  • Avionics units (S/N: AV-2024-01)
Behavior:
  • Each serial number is a separate database row
  • Quantity is always 1 per serial
  • Issuance requires selecting specific serial
  • Full individual history tracking
Use serialized tracking for high-value or critical safety components!
Fun Fact: ✈️ The average commercial aircraft contains over 600,000 individual parts! AERONAV AMO can handle inventory of any scale.

​
🔄 Workflow Examples

​
📦 Adding New Inventory

1

Navigate to Inventory Page

Click “Add New Part” button in the top right
2

Fill in Part Details

  • Part Number (required)
  • Description
  • Location (e.g., Bin A-12)
  • Serial Number (if applicable)
  • Quantity
  • Low Stock Threshold
3

Save and Verify

System automatically logs the addition in stock history
Pro Tip: Use consistent location naming (e.g., BIN-A-12, SHELF-B-05) to make searching easier!

​
🔧 Issuing Parts

1

Locate the Part

Use search bar to find part by number, description, or serial
2

Click 'Issue' Action

Opens the issuance modal with pre-filled part details
3

Enter Required Information

  • Aircraft registration (e.g., 5Y-ABC)
  • Technician name
  • Quantity (for non-serialized) or select serial (for serialized)
  • Optional remarks
4

Confirm Issuance

System validates stock availability and processes the transaction
Important: For serialized parts, you can only issue ONE unit at a time. The system will reject requests for quantities greater than 1.
Remember: All issuances are automatically logged with timestamp, user, aircraft, and technician details for complete audit compliance!

​
📤 CSV Bulk Import

Bulk import is the fastest way to populate your inventory! You can add hundreds of parts in seconds.
Required CSV Columns: 
part_no,description,location,serial_no,quantity,store_name,remarks
Example CSV Data: 
part_no,description,location,serial_no,quantity,store_name,remarks
PN-12345,Engine Oil Filter,BIN-A-12,,50,Main Hangar,Batch 2024-A
PN-67890,Aircraft Propeller,SHELF-B-05,PR-001,1,Main Hangar,Overhauled
PN-67890,Aircraft Propeller,SHELF-B-05,PR-002,1,Main Hangar,New
PN-11111,Safety Wire,BIN-C-01,,200,Tool Crib,
1

Download Template

Navigate to CSV Upload page and download the template
2

Prepare Your Data

Fill in the template with your inventory data
  • Leave serial_no empty for non-serialized parts
  • Each serialized part should be on a separate row
  • Quantity should be 1 for serialized parts
3

Upload CSV

Drag and drop your file or click to browse
4

Preview & Validate

System shows preview and validates all data
Fix any validation errors before proceeding!
5

Confirm Import

Click “Import” to add all parts to inventory
Smart Merging: The system automatically merges quantities for duplicate non-serialized parts while keeping serialized parts separate!

​
⚠️ Common Pitfalls

Avoid these common mistakes to ensure smooth operations!
Problem: Adding quantity > 1 for a part with a serial numberWhy it fails: Serialized parts must have quantity = 1 per serialSolution: Create separate rows for each serial number
❌ WRONG:
PN-123,Propeller,SHELF-A,SN-001,3,Main

✅ CORRECT:
PN-123,Propeller,SHELF-A,SN-001,1,Main
PN-123,Propeller,SHELF-A,SN-002,1,Main
PN-123,Propeller,SHELF-A,SN-003,1,Main
Problem: Trying to issue 10 units when only 5 are in stockWhy it fails: System prevents negative inventorySolution: Check available quantity before issuing. The system will show an error message.
Problem: Leaving aircraft registration or technician name blankWhy it fails: Required for audit trail and complianceSolution: Always fill in all required fields during issuance
Create a list of standard aircraft registrations and technician names to ensure consistency!
Problem: Using “Bin A12”, “BIN-A-12”, “bin a 12” for the same locationWhy it’s bad: Makes searching and reporting difficultSolution: Establish a standard naming convention and stick to itRecommended Format:
  • BIN-[LETTER]-[NUMBER] → BIN-A-12
  • SHELF-[LETTER]-[NUMBER] → SHELF-B-05
  • RACK-[NUMBER] → RACK-001

​
💡 Best Practices

Follow these best practices to maximize efficiency and maintain compliance!

​
📋 Inventory Management

Set Realistic Thresholds

Configure low stock alerts based on:
  • Lead time from suppliers
  • Average consumption rate
  • Critical vs non-critical parts
Critical parts should have higher thresholds!

Regular Stock Audits

Perform monthly cycle counts to ensure accuracy:
  • Verify physical count matches system
  • Check for damaged or expired parts
  • Update locations if changed

Clear Location Labeling

Use consistent, descriptive location codes:
  • Include physical labels on bins/shelves
  • Map locations in a diagram
  • Train all staff on the system

Detailed Remarks

Add useful notes when:
  • Receiving new stock (batch number, supplier)
  • Issuing parts (work order reference)
  • Finding discrepancies (reason for adjustment)

​
🔧 Issuance Workflow

1

Verify Work Authorization

Confirm the work order or maintenance schedule before issuing
2

Check Part Eligibility

Ensure the part is serviceable and within shelf-life limits
3

Document Everything

Include work order numbers and maintenance references in remarks
4

Double-Check Serial Numbers

For critical components, verify serial number matches maintenance records
Compliance Alert: Aviation regulations require complete traceability of critical parts. Always record serials for life-limited components!

​
📊 Reporting & Analytics

Generate reports regularly to identify trends and prevent stockouts!
Weekly Reports:
  • Parts issued by aircraft (helps predict maintenance patterns)
  • Low stock alerts (reorder list)
  • Fast-moving items (consider increasing stock levels)
Monthly Reports:
  • Stock movement analysis
  • Technician issuance activity
  • Inventory turnover rate
  • Dead stock identification
Quarterly Reports:
  • Compliance audit reports (full movement history)
  • Cost analysis (parts consumed vs budget)
  • Supplier performance (lead times, quality issues)
Export reports in PDF for management reviews and CSV for further analysis in Excel!

​
🔐 Security & Permissions

Properly configure user roles to maintain data integrity and compliance!

​
Role-Based Access Control

RolePermissionsUse Case
AdminFull access - Create, Read, Update, DeleteSystem administrators, store managers
StorekeeperAdd inventory, issue parts, view reportsDay-to-day operations staff
TechnicianView inventory, request requisitionsMaintenance technicians
ViewerRead-only access to inventory and reportsManagement, auditors
Best Practice: Follow the principle of least privilege—give users only the access they need!

​
Data Backup

1

Automatic Backups

Supabase performs automatic daily backups of your database
2

Manual Exports

Export critical data weekly as CSV for local backup
3

Audit Logs

All changes are logged in stock_history table—never delete this data!
Remember: Backup retention policies vary by Supabase plan. Check your plan details!

​
🐛 Troubleshooting

Cause: Trying to issue more quantity than available in inventorySolutions:
  1. Check current stock level for the part
  2. Verify you’re looking at the correct part number
  3. For serialized parts, ensure serial is still in stock (not already issued)
  4. Reduce requested quantity
Use the History button to see recent movements that might have reduced stock!
Cause: Attempting to add a serial number that already exists in the databaseSolutions:
  1. Search inventory to verify if serial already exists
  2. If it’s a data entry error, correct the serial number
  3. If part was returned to stock, use “Add Quantity” instead of CSV upload
Never create duplicate serial numbers—this violates aviation traceability requirements!
Cause: CSV file doesn’t match required formatRequired headers:
part_no,description,location,serial_no,quantity,store_name,remarks
Solutions:
  1. Download the official template from the Upload page
  2. Ensure no extra spaces in header names
  3. Save file as UTF-8 encoded CSV
  4. Don’t add extra columns
Open your CSV in a text editor to verify headers are exactly correct!
Cause: Threshold not configured or set too lowSolution:
  1. Edit the part and set low_stock_threshold value
  2. Recommended: Set threshold at 2-3x average monthly usage
  3. For critical parts, set higher thresholds (50-100% higher)
Low stock alerts appear on the dashboard and in inventory table when quantity ≤ threshold
Still having issues? Check the browser console (F12) for detailed error messages or contact support!

​
📚 Additional Resources

Video Tutorials

Watch step-by-step guides for common tasks

API Documentation

Complete reference for RPC functions and endpoints

Database Schema

Detailed table structures and relationships

Community Forum

Get help from other AERONAV users

​
🎉 Fun Facts

Did You Know? ✈️
  • The Boeing 747 has over 6 million parts from suppliers in 65 countries!
  • An aircraft’s average part lifecycle spans 20-30 years
  • Proper inventory management can reduce aircraft downtime by up to 40%
  • The most tracked serial number in aviation history belongs to Wright Brothers’ Flyer I (1903)
  • Modern airlines track over 1 million inventory items on average

​
🚀 What’s Next?

Ready to get started? Here’s your roadmap:
1

Complete Initial Setup

Follow our Quick Start Guide to configure your environment
2

Import Your Inventory

Use CSV upload to populate your parts database
3

Configure User Roles

Set up permissions for your team members
4

Train Your Team

Share this documentation and conduct hands-on training sessions
5

Go Live!

Start tracking parts and processing issuances in production
Congratulations! You’re now ready to revolutionize your hangar inventory management! 🎊

​
⚖️ Disclaimer

Important Legal NoticeThis software is provided “as is” without warranty of any kind, express or implied. While AERONAV AMO is designed to help maintain compliance with aviation regulations, users are solely responsible for:
  • Ensuring compliance with local and international aviation regulations
  • Verifying accuracy of inventory data
  • Maintaining proper documentation as required by regulatory authorities
  • Implementing appropriate backup and disaster recovery procedures
AERONAV AMO is a tool to assist with inventory management and should be used in conjunction with—not as a replacement for—proper aviation maintenance practices and regulatory compliance programs.Users must:
  • Verify all data before making operational decisions
  • Follow manufacturer recommendations and regulatory requirements
  • Maintain independent records as required by law
  • Conduct regular audits and validations of system data
For aviation regulatory compliance questions, consult with your local Civil Aviation Authority or an aviation compliance specialist.

​
📧 Contact

For questions, feedback, or support:

Email Support

📨 [email protected]

Developer Portfolio

🌐 Brian Kimemia
Response Time: We typically respond to inquiries within 24-48 hours during business days.
Built with ✈️ for Aviation ProfessionalsMaking hangar inventory management simple, compliant, and efficient.
Last Updated: November 2025
Version: 1.0.0
License: MIT