Overview
The Parts Inventory lets admins, owners, and mechanics track spare parts for the fleet — part numbers, quantities on hand, minimum stock levels, supplier information, and storage location. Low-stock alerts appear automatically when quantities fall to or below the minimum.
Accessing Parts Inventory
Parts Inventory is available in the left sidebar under Parts Inventory. It's visible to admins, owners, and mechanics only.
Adding a Part
- Click Add Part.
- Fill in:
- Description (required) — what the part is (e.g., "Oil Filter, Lycoming LW-13956-1")
- Part Number — manufacturer or supplier part number (e.g., "LW-13956-1")
- Aircraft — link to a specific aircraft (optional), or leave blank for fleet-wide parts
- Qty on Hand — current stock count
- Min Qty — minimum acceptable stock level before the low-stock warning triggers
- Unit Cost ($) — cost per unit for reference
- Supplier — vendor name (e.g., "Aircraft Spruce", "Spruce & Specialty")
- Storage Location — where to find it (e.g., "Shelf A-3", "Hangar B cabinet 2")
- Notes — any additional info
- Click Add Part.
Adjusting Quantity
Use the + and − buttons next to each part's quantity to increment or decrement stock on hand. Changes are saved immediately.
For larger adjustments, click the edit (pencil) icon and update the Qty on Hand field directly.
Low Stock Warnings
When a part's quantity on hand reaches or falls below its minimum quantity, it is highlighted in the table and a yellow warning banner appears at the top of the page:
"2 parts are at or below minimum stock level"
Searching Parts
Use the search bar to filter by description, part number, supplier, or storage location. The table updates in real time as you type.
Editing or Deleting a Part
- Edit: Click the pencil icon to update any field including description, part number, costs, or quantities.
- Delete: Click the trash icon. This permanently removes the part from inventory. Confirm the deletion when prompted.
Notes
- Parts Inventory requires migration
supabase-migration-v38.sql.
- Parts linked to a specific aircraft show a tail number badge in the Aircraft column. Fleet-wide parts show "Fleet."
- The inventory has no direct integration with work orders today — tracking parts used on a work order is done manually by adjusting quantities.