Spare Parts & Inventory Forms
The 25 forms that control the complete AGL spare-parts cycle — Spare Identification → Stock Registration → Min/Max/Reorder Control → Requisition → Issue → Consumption → Return → Reconciliation → Critical-Spare Management → Lifecycle → Obsolescence. Grouped into Stock Registration & Control, Transaction Control, Critical & Special Inventory, Traceability, Equipment-Specific Registers, Audit & Reconciliation, and Lifecycle, this division is the spare-parts reliability and availability layer that connects tightly with Division 08 — Maintenance and Division 11 — Asset Management, since spare demand should come from actual maintenance requirements, asset criticality, failure history and lifecycle planning.
Where this fits — Division 08 generates the maintenance demand and Division 11 supplies the asset criticality and lifecycle context; this division turns that demand into stocked, traceable, available spares. Every issue record here should trace back to a work order and asset, and every critical spare should trace forward into min/max/reorder planning and procurement, so the system shows not only how many spares are in stock, but which spares must never be unavailable.
A · Spare Parts Registration & Stock Control
5 of 25 formsSP-01 Spare Parts Register Register
Purpose
To maintain the master register of all AGL spare parts maintained in stores, covering identification, stock, procurement and status of every part.
Key Fields
- Spare Part ID, description, category, equipment type
- Manufacturer, manufacturer part no., model, specification
- Applicable asset / applicable system
- Store location, bin location, unit
- Current, minimum, maximum, reorder, safety, reserved and available quantity
- Supplier, purchase order, lead time, unit cost, currency, warranty
- Status: active, critical, slow moving, obsolete, under warranty, discontinued
SP-02 Spare Parts Stock Sheet Tracker
Purpose
To provide the current stock position of individual spare parts through a running opening, receipt, issue, return, adjustment and closing balance.
Key Fields
- Spare ID, description, date, store, bin
- Opening / receipt / issue / return / adjustment / closing quantity
- Batch/lot, serial number where applicable
- Physical quantity, system quantity, difference
- Storekeeper, verified by, date
SP-03 Minimum Stock Level Reference Sheet
Purpose
To establish the minimum quantity of a spare that should normally be maintained, below which inventory requires management attention.
Key Fields
- Spare Part ID, description, equipment
- Average consumption, lead time, criticality
- Minimum stock, safety stock, basis of calculation
- Considers historical consumption and failure frequency
- Considers procurement lead time and asset criticality
- Considers operational consequence and supplier availability
- Approved by
SP-04 Maximum Stock Level Reference Sheet
Purpose
To establish the maximum practical inventory quantity for a spare, preventing overstocking, capital blockage, expiry, obsolescence and unnecessary duplication.
Key Fields
- Spare Part ID, description
- Minimum level, maximum level, consumption rate
- Lead time, storage limitation, shelf life, cost
- Approved quantity
- Control objective: prevent overstocking, capital blockage, expiry, obsolescence, duplication
SP-05 Reorder Level Reference Sheet
Purpose
To define the stock level at which a replenishment order should be initiated: Reorder Level = Expected Consumption During Lead Time + Safety Stock, with the exact methodology standardized by the inventory-management procedure.
Key Fields
- Spare ID, average consumption, lead time, safety stock
- Reorder level, supplier, procurement lead time
- Current stock, reorder required
- Status: above reorder level, at reorder level, below reorder level, emergency procurement required
B · Spare Parts Transaction Control
4 of 25 formsSP-06 Spare Parts Requisition Requisition
Purpose
To request spare parts from the store for maintenance or other authorized work.
Key Fields
- Requisition No., date, Work Order No., Asset ID
- Equipment, location, maintenance type, requesting person
- Spare ID, description, part no., required qty, purpose
- Approval: Technician, Supervisor, Maintenance Engineer, authorized approver
- Store action: issued, partially issued, not available, alternative proposed
SP-07 Spare Parts Issue Record Record
Purpose
To record actual issue of spare parts from stores against an approved requisition.
Key Fields
- Issue No., date, Spare ID, description, part number
- Quantity, unit, work order, Asset ID, location
- Issued to, storekeeper
- Verification: quantity issued, condition, batch/serial number
- Recipient signature, stock balance
SP-08 Spare Parts Return Record Return Form
Purpose
To record unused, excess or removed parts returned to stores, including failed components returned for investigation.
Key Fields
- Return No., work order, Asset ID, Spare ID, quantity
- Return type: unused spare, excess material, removed serviceable component, incorrectly issued part, failed component
- Reason for return, inspection result
- Condition: new, serviceable, repairable, failed, scrap, quarantine
SP-09 Spare Parts Consumption Tracker
Purpose
To track actual spare-part consumption against maintenance activities and analyze consumption trends across equipment, location and time.
Key Fields
- Date, WO, asset, Spare ID, description, qty, unit cost, total cost
- Analysis by equipment, location, month, failure, maintenance type
- Outputs: high-consumption parts, recurring component failures
- Outputs: abnormal consumption, future procurement requirement
C · Critical & Special Inventory
5 of 25 formsSP-10 Critical Spare Register Register
Purpose
To identify spare parts whose absence could significantly affect AGL operational availability or safety.
Key Fields
- Spare ID, description, equipment, asset criticality
- Failure consequence, current stock, minimum stock, lead time
- Supplier, criticality class, emergency availability
- Criticality factors: safety impact, operational impact, failure frequency, availability of alternatives
- Status: adequately stocked, below minimum, emergency procurement, supplier risk
SP-11 Emergency Spare Register Register
Purpose
To identify parts that must be immediately available for emergency AGL restoration.
Key Fields
- Spare ID, equipment, description, required qty, available qty
- Storage location, emergency use, responsible person
- Examples: critical fixture components, CCR components, isolation transformers
- Examples: connectors, cable joint components, PAPI, sign, control/ALCMS components
- Control: emergency stock checked, seal/security checked, expiry checked, availability verified
SP-12 Slow-Moving Spare Register Register
Purpose
To identify spare parts with very low consumption before they become a stranded, obsolete cost.
Key Fields
- Spare ID, description, stock quantity
- Last issue date, last receipt date, consumption rate
- Stock age, value, reason for slow movement
- Management action: retain, reduce stock, transfer, return to supplier, reuse, dispose
SP-13 Obsolete Spare Register Register
Purpose
To control spare parts that are no longer technically or commercially suitable for use.
Key Fields
- Spare ID, description, applicable equipment, quantity, value
- Obsolescence date, reason, replacement part, disposal decision
- Reasons: equipment discontinued, manufacturer discontinued, technology replaced
- Reasons: no supplier, no compatible equipment, shelf-life expired, specification changed
- Action: consume, substitute, return, dispose, retain for legacy equipment
SP-14 Spare Parts Warranty Record
Purpose
To maintain warranty information for spare parts and replacement components, and track claims against manufacturer or supplier.
Key Fields
- Spare ID, part number, manufacturer, supplier
- Purchase date, warranty start, warranty expiry, warranty terms, applicable equipment
- Claim: failure date, claim number, claim submitted
- Claim: supplier response, replacement, repair, closure
D · Spare Traceability
1 of 25 formsSP-15 Spare Parts Traceability Traceability Record
Purpose
To establish complete traceability from procurement through storage, issue, installation and final use — particularly important for critical AGL components.
Key Fields
- Spare ID, part number, serial number, batch/lot
- Supplier, PO, receipt, store location
- Issue, work order, asset, installation date
- Traceability chain: Purchase Order → Delivery → Batch/Lot/Serial No. → Store Receipt
- Chain continues: Storage Location → Issue Record → Work Order → Asset ID → Installation → Maintenance History
E · Equipment-Specific Spare Registers
7 of 25 formsSP-16 Fixture Spare Register Register
Purpose
To manage spare parts applicable to AGL fixtures.
Key Fields
- Spare ID, fixture type, manufacturer, model, part number
- Quantity, minimum, maximum, location, status
- Categories: LED module, driver where applicable, optical components, lens
- Categories: gasket, housing component, fasteners, mounting components, connector accessories
SP-17 Transformer Spare Register Register
Purpose
To control spares for AGL isolation transformers and associated components.
Key Fields
- Applicable transformer, rating, manufacturer, part number
- Stock, minimum stock, lead time, criticality
- Categories: isolation transformer, connector, connector components
- Categories: secondary leads, protection components, sealing components, associated accessories
SP-18 CCR Spare Register Register
Purpose
To control spare parts required for Constant Current Regulators.
Key Fields
- CCR manufacturer, model, part number, compatibility
- Stock, minimum, lead time, criticality
- Categories: control components, power components, fuses, contactors, relays
- Categories: cooling, display/HMI, communication, protection components, manufacturer-specific assemblies
SP-19 PAPI Spare Register Register
Purpose
To control spare parts for PAPI/APAPI systems.
Key Fields
- PAPI type, unit compatibility, manufacturer, model, part number
- Quantity, criticality, storage condition
- Categories: light source, optical, electronic, housing components
- Categories: adjustment components, power components, connectors, mounting components
SP-20 Sign Spare Register Register
Purpose
To control spares for illuminated airfield signs.
Key Fields
- Sign type, manufacturer, model, part number
- Quantity, minimum, maximum, location
- Categories: light source, LED/module, power components, transformer
- Categories: connector, sign face/component, internal wiring, mounting hardware
SP-21 Connector Spare Register Register
Purpose
To maintain stock of AGL cable and connector components.
Key Fields
- Connector type, connector ID/part number, cable compatibility
- Manufacturer, application, stock quantity, minimum, maximum, lead time, criticality
- Categories: primary connector, secondary connector, plug, receptacle
- Categories: connector kit, sealing accessories
SP-22 Cable Spare Register Register
Purpose
To control spare cable materials required for AGL maintenance and emergency repair.
Key Fields
- Cable ID, cable type, voltage class, size, manufacturer, part number
- Length available, storage location, minimum length, reorder level
- Control: cable drum ID, batch, length received, length consumed
- Control: balance length, work order used
F · Inventory Audit & Reconciliation
2 of 25 formsSP-23 Inventory Audit Checklist
Purpose
To verify that physical inventory matches inventory records and that storage controls are effective.
Key Fields
- Audit areas: stock quantity, part identification, bin location, condition
- Audit areas: shelf life, traceability, stock labeling, security, storage environment
- Audit areas: critical spares, obsolete spares
- Audit result: compliant, minor discrepancy, major discrepancy, corrective action required
- Findings: physical shortage, excess stock, wrong location, unidentified/damaged/expired/obsolete item
SP-24 Stock Reconciliation Record
Purpose
To reconcile physical stock against ERP/store records and close out discrepancies.
Key Fields
- Spare ID, system qty, physical qty, difference, reason, adjustment, approved by
- Possible causes: unrecorded issue, unrecorded receipt, return not recorded
- Possible causes: counting error, damage, scrap, data-entry error, wrong item identification
- Closure: investigation completed, adjustment authorized, inventory updated, records corrected
G · Spare Parts Lifecycle
1 of 25 formsSP-25 Spare Parts Lifecycle Record Record
Purpose
To track the complete lifecycle of a spare part from procurement through final consumption, replacement or disposal.
Key Fields
- Spare ID, part number, manufacturer, purchase date, receipt date
- Storage location, issue history, consumption history, warranty
- Failure history, obsolescence, disposal
- Lifecycle: Requirement → Procurement → Receipt → Inspection → Storage → Issue → Installation/Consumption → Return/Failure → Warranty → Obsolescence/Disposal
- Final status: in stock, issued, consumed, returned, repairable, obsolete, disposed
How Division 12 Connects
These 25 forms turn spare-parts management from a store inventory register into the AGL spare-parts reliability and availability system — showing not only how many spares are in stock, but which spares must never be unavailable, which parts are being consumed excessively, which parts are becoming obsolete, and which assets are driving spare-parts demand.
Spare-Parts Control Flow
The seven categories in this division follow the spare-parts cycle from demand to disposal:
Related Divisions
- Division 03 — Procurement & Material Approval Forms (purchase requisition, PO, supplier, delivery behind every reorder)
- Division 08 — Maintenance Forms (work order and repair/replacement that generate spare-parts demand)
- Division 09 — Failure Investigation Forms (failed spare, failure mode and RCA behind SP-08 and SP-13)
- Division 10 — QA/QC Forms (incoming inspection, NCR, and supplier quality feeding SP-01 and SP-15)
- Division 11 — Asset Management Forms (asset criticality, lifecycle and replacement planning that drive SP-10 and SP-25)
Frequently Asked Questions
Quick answers about the 25 Division 12 Spare Parts & Inventory forms, how they are grouped, and how they connect to the rest of the library.
Q1What is Division 12 — Spare Parts & Inventory Forms in the AGL Engineering Forms & Templates library?
Division 12 is a set of 25 spare parts & inventory forms (SP-01 to SP-25) in the AGL Engineering Forms & Templates library. It controls the complete AGL spare-parts cycle, from spare identification and stock registration through requisition, issue, consumption, return, reconciliation, critical-spare management, lifecycle and obsolescence. The forms are grouped into 7 categories: Spare Parts Registration & Stock Control, Spare Parts Transaction Control, Critical & Special Inventory, Spare Traceability, Equipment-Specific Spare Registers, Inventory Audit & Reconciliation and Spare Parts Lifecycle.
Q2Which forms are included in Spare Parts Registration & Stock Control and Spare Parts Transaction Control?
Spare Parts Registration & Stock Control (5 forms): SP-01 Spare Parts Register, SP-02 Spare Parts Stock Sheet, SP-03 Minimum Stock Level, SP-04 Maximum Stock Level, SP-05 Reorder Level; Spare Parts Transaction Control (4 forms): SP-06 Spare Parts Requisition, SP-07 Spare Parts Issue Record, SP-08 Spare Parts Return Record, SP-09 Spare Parts Consumption.
Q3Which forms are included in Critical & Special Inventory, Spare Traceability, Equipment-Specific Spare Registers, Inventory Audit & Reconciliation and Spare Parts Lifecycle?
Critical & Special Inventory (5 forms): SP-10 Critical Spare Register, SP-11 Emergency Spare Register, SP-12 Slow-Moving Spare Register, SP-13 Obsolete Spare Register, SP-14 Spare Parts Warranty; Spare Traceability (1 form): SP-15 Spare Parts Traceability; Equipment-Specific Spare Registers (7 forms): SP-16 Fixture Spare Register, SP-17 Transformer Spare Register, SP-18 CCR Spare Register, SP-19 PAPI Spare Register, SP-20 Sign Spare Register, SP-21 Connector Spare Register, SP-22 Cable Spare Register; Inventory Audit & Reconciliation (2 forms): SP-23 Inventory Audit, SP-24 Stock Reconciliation; Spare Parts Lifecycle (1 form): SP-25 Spare Parts Lifecycle Record.
Q4What is the difference between the Minimum Stock Level, Maximum Stock Level and Reorder Level sheets?
The Minimum Stock Level (SP-03) sets the quantity that should normally be maintained, below which inventory needs management attention. The Maximum Stock Level (SP-04) sets the maximum practical quantity, preventing overstocking, capital blockage, expiry and obsolescence. The Reorder Level (SP-05) defines the stock level at which a replenishment order should be initiated.
Q5What is the difference between the Critical, Emergency, Slow-Moving and Obsolete spare registers?
The Critical Spare Register (SP-10) identifies spares whose absence could significantly affect AGL availability or safety. The Emergency Spare Register (SP-11) identifies parts that must be immediately available for emergency restoration. The Slow-Moving Spare Register (SP-12) identifies very low-consumption parts before they become a stranded cost, and the Obsolete Spare Register (SP-13) controls parts that are no longer technically or commercially suitable for use.
Q6Which forms control issuing spares and checking stock?
The Spare Parts Requisition (SP-06) requests parts from the store, the Spare Parts Issue Record (SP-07) records the actual issue, and the Spare Parts Return Record (SP-08) records returns, including failed components returned for investigation. The Spare Parts Consumption tracker (SP-09) tracks usage. The Inventory Audit (SP-23) and Stock Reconciliation (SP-24) verify physical stock against the records and close out discrepancies.
Q7Can the forms in Division 12 be downloaded and filled in?
Yes. Each form has a Download as Word button that produces an uncontrolled sample Word template with letterhead, a document-control block, ruled entry fields and a three-tier approval table, ready to print or fill on-screen. Checklist-format forms such as Inventory Audit (SP-23) download with a checkbox and a verified-by line for each item. The forms can also be searched by keyword or form ID.
Q8How does Division 12 connect to maintenance, asset and procurement records?
The maintenance division generates the demand and the asset-management division supplies the criticality and lifecycle context, and this division turns that demand into stocked, traceable, available spares. Every issue record should trace back to a work order and asset, and every critical spare should trace forward into min/max/reorder planning and procurement.
STOCK THE PART. KNOW WHEN YOU NEED IT.
A spare parts form tracks quantity — but real inventory planning means understanding failure rates, lead times and which components are critical to keep an AGL system operational.
Take your knowledge further with Precision AGL Academy.
Build Complete AGL Project Capability
Learn how technical AGL work connects with:
Develop the knowledge to not only record the work, but understand the engineering and project-management principles behind it.
Plan the project. Understand the engineering. Deliver with confidence.
Follow the Academy
Important Notice, Disclaimer & Limitation of Liability
Please read before relying on any content on this page or on any template downloaded from it.
- Purpose and intended users. This page is an independent educational and informational reference for competent, suitably trained and authorised airfield ground lighting (AGL), aerodrome electrical and project personnel. It is not professional engineering, legal or regulatory advice, and using it does not create any professional or client relationship.
- Sample templates, not controlled documents. Forms, checklists, registers, reports, certificate layouts and Word downloads are generic samples. They are uncontrolled copies and are not approved work instructions, procedures, permits, certificates, test or calibration records, or regulatory records. Letterheads, form numbers, revision labels, dates, document-control blocks and approval tables are layout only. Review and adapt a template under your own document-control system before any use; signatures on it carry no authority unless made under your own approved system. Precision AGL Academy does not issue, approve, certify or take responsibility for any record completed using a template, and does not receive or store such records.
- Safety. Work on series circuits, constant current regulators (CCRs), isolating transformers, cables, connectors and control equipment can be fatal. Always apply the aerodrome’s permit-to-work and isolation/LOTO procedures, prove dead, use correctly rated instruments and PPE, and follow the manufacturer’s instructions. Nothing here authorises work on live equipment or the bypassing of any safety device or interlock.
- Certificates, approvals and compliance. A completed template is not a certificate, approval, acceptance, release, permit or evidence of compliance, and listing a certificate, approval or sign-off field does not make the document valid. Reading this material or completing a template confers no certification, accreditation, competency assessment or authorisation to work on any aerodrome.
- Aviation operations. Nothing here authorises return to service, a change of operating category (CAT I/II/III), a NOTAM, a flight-inspection outcome or any aerodrome certification decision. These rest with the aerodrome operator, the air navigation service provider and the competent regulator.
- Standards, regulations and contracts. References to ICAO, FAA, IEC, IEEE, ISO, BIS, DGCA and other standards are for orientation only. They are summarised, may be incomplete or out of date, and standards are revised from time to time. Consult the current official editions. Following this content does not guarantee compliance with any law, standard, contract or regulatory approval. Contract, specification and official requirements always prevail, and nothing here is a contract document or legal advice.
- Personal and confidential data. Some templates have fields for names, signatures, training or competency records, and incident or injury details. If you record personal or confidential information on a template, you are responsible for handling it lawfully, including under India’s Digital Personal Data Protection Act, 2023 and your contracts. Word files are generated in your browser; the content you enter is not sent to us.
- Generic content; no warranty. Field lists, sequences, categories and example values are generic and indicative; real projects, installations and contracts differ. Content is provided “as is” and “as available”, without warranty of any kind, express or implied, including accuracy, completeness, currency or fitness for a particular purpose.
- Limitation of liability. To the fullest extent permitted by applicable law, Precision AGL Academy and its owners, authors and contributors are not liable for any injury, death, loss, damage, downtime, penalty, contractual dispute or regulatory consequence, whether direct or indirect, arising from the use of, reliance on, or inability to use this content or any template downloaded from it. Nothing in this notice excludes or limits any liability that cannot lawfully be excluded or limited.
- Independence and trademarks. This is an independent publication, not affiliated with or endorsed by ICAO, the FAA, the IEC, BIS, DGCA, any airport, regulator, certification body or equipment manufacturer. Third-party names, standard designations and trademarks, including Microsoft Word and Excel, belong to their respective owners and are used for identification only.
- Copyright and use. © 2026 Precision AGL Academy. All rights reserved. You may view this page and use downloaded templates for personal reference, internal training and, once adapted under your own document-control system, your own internal project records, keeping this notice attached to unadapted copies. You may not present them as approved or controlled documents, or copy, republish, redistribute, scrape or commercially use the library without our prior written permission.
- Corrections. Content is reviewed periodically, with no obligation to update. To report an error, safety concern or rights issue, write to precisionaglsolutions@gmail.com.