MIL-PRF Component Qualification Tracking Worksheet
Defense builds often require parts that meet a MIL-PRF specification and appear on a Qualified Products List (QPL) or Qualified Manufacturers List (QML). This worksheet keeps the evidence for each part in one table.
| Part number | Governing spec | Quality level | Source type | On QPL / QML | Date code | C of C received | Qty | Unit cost | Extended cost | |
|---|---|---|---|---|---|---|---|---|---|---|
$960 | ||||||||||
$675 | ||||||||||
$885 | ||||||||||
$4,720 |
Sample part numbers are illustrative only. Verify QPL or QML listing against the current DLA list for the exact part and manufacturer before use. Any row with Listed = No, an independent broker source or a missing C of C should be dispositioned by quality before it reaches the line.
Flag unqualified lots at receiving
An optional review of how your ERP can hold lots that lack QPL status or a C of C.
Optional. The tool and every export work without this. No spam.
How to use the worksheet
List every qualified part on the bill of materials. Select the governing specification and the quality level, record the source type, and mark whether the part and manufacturer appear on the current QPL or QML. Add the date code and whether a certificate of conformance came with the lot. Export to Excel for the first article package or a customer audit.
What the columns mean
The MIL-PRF number identifies the performance specification, for example 19500 for semiconductors or 38535 for integrated circuits. Quality level shows the screening grade, such as JAN, JANTX, JANTXV and JANS for semiconductors, with JANS at the highest level. Source type matters because supply chain risk rises as you move from the manufacturer toward independent brokers.
- Qualification belongs to a specific manufacturer and part, not the family
- Date code supports traceability and age checks
- A C of C does not replace verification of the listing
Reading the sheet
Sort by Listed and Source type. Items not on the list, or bought from independent brokers, are the ones to inspect first. Those lines often need additional testing, a customer waiver or replacement. The cost column helps weigh the price of replacing a questionable lot against the cost of testing it.
Common mistakes
Frequent errors include assuming a commercial equivalent is acceptable, using a listing that has since been removed, and skipping source checks on obsolete parts. Remember too that lists change, so confirm status at the time of purchase and again at receiving, not just during design.
Frequently Asked Questions
What is the difference between QPL and QML?
A QPL lists products qualified to a specification. A QML lists manufacturers whose process is qualified, and is used for microcircuits and hybrids under MIL-PRF-38535 and 38534. Both are maintained by DLA, and you should check the current list.
What do JAN, JANTX, JANTXV and JANS mean?
They are quality levels for semiconductors under MIL-PRF-19500. Each step adds screening, with JANS the highest level, typically used in space applications. The detailed screening requirements are in the specification.
Can I use a commercial part in place of a MIL-PRF part?
Only if the drawing, contract or an approved deviation allows it. Substitution without approval is a nonconformance on defense work, so ask engineering and the customer before changing anything.
Why track source type?
Counterfeit and nonconforming parts risk is much higher from independent brokers. Many defense contracts require buying from the manufacturer or authorized sources, with specific controls if open market purchase is unavoidable.
Netray can attach QPL status, source type and C of C flags to purchase orders and receipts in your ERP, so questionable lots are held before they reach the line.
Related Tools
Counterfeit Parts Risk Assessment (AS5553)
A 10-question assessment of your counterfeit electronic parts exposure, aligned to AS5553 and DFARS counterfeit prevention requirements, with a risk band and mitigation plan.
Aerospace & DefenseDMSMS Obsolescence Management Worksheet
A part-by-part obsolescence tracker that computes months of stock cover and a likelihood-by-impact risk score so you can see which parts need a last-time buy or redesign first.
Aerospace & DefenseDefense Electronics First Article Inspection Template
A fill-in first article report for a PCB or box-level assembly with sections for configuration, parts, process, test and approvals. Exports to PDF or Word.
Industry TemplatesIPC-A-610 Acceptability Class Reference Table
A searchable reference of how IPC-A-610 Class 1, 2 and 3 differ in intent, service expectation and how conditions are labeled, for contract reviews and inspector briefings.
More Aerospace & Defense tools
See all- MIL-STD-810H Test Methods Reference Table
- MIL-STD-461 EMI/EMC Test Method Reference Table
- CMMC 2.0 Level 2 Readiness Assessment
- ITAR Compliance Checklist for Manufacturers
- DFARS 252.204-7012 Compliance Self-Assessment
- AS9100 Audit Readiness Checklist
- Export Control Screening Checklist
- Defense Contractor AI Readiness Assessment
- Aerospace Supplier Scorecard
Keep exploring
Free tools
- Electronics Lot and Date Code Traceability Log WorksheetAn editable log that records manufacturer, lot, date code and quantities per component line, with on-hand balance calculated per row.
- Electronic Component Lot Traceability SQL GeneratorFill in your table and column names to get forward trace, backward trace and quarantine-scope SQL for a component lot or date code.
- SAP Subcontracting Component Tracking WorksheetTrack components sent to a subcontractor, expected consumption and what should still be on their premises.
ERP fixes and how-tos
- Date Code and Lot Traceability in Cetec ERPHow to keep date code and lot traceability in Cetec ERP for electronics: capture at receiving, preserve through builds, and answer a recall trace quickly.
- Infor LN 10.4 Lot Tracking: Setup and TraceabilityHow to set up lot and serial tracking in Infor LN 10.4: item flags, lot handling in inventory and receipts, and how to run forward and backward traceability.
- Dynamics 365 Supply Chain Traceability: Lot and Serial Tracking for RecallsSet up lot (batch) and serial traceability in Dynamics 365 Supply Chain Management: tracking dimension groups, item tracing and how to run a recall trace.
Guides
- Welder Qualification and Continuity Tracking Under AWS D1.1How fabricators track welder qualification, continuity, and expiry under AWS D1.1 and ASME IX, avoid lapses, and prove who welded what on every job.
- How to Configure Vendor Qualification in SyteLineLearn how to set up vendor qualification and approved supplier management in Infor SyteLine. Configure vendor assessments, quality scorecards, approval workflows, and ongoing performance monitoring.
- Lot Traceability in Electronics Manufacturing: From Reel to Finished SerialLot traceability in electronics manufacturing explained: component-level genealogy, ERP lot control setup, IPC-1782 levels, recall readiness, and AI-driven trace.
AI on your ERP
- AI on SAP Business One for Electronics Manufacturers: BOMs, Shortages and TraceabilityPrivate AI on SAP Business One for electronics makers: multi-level BOM questions, component shortages, lot and serial traceability, RoHS and obsolescence checks.
- AI for EMS and PCBA Manufacturers Running SyteLine, Epicor, or NetSuiteAI for EMS and PCBA manufacturers on SyteLine, Epicor, or NetSuite: automate BOM scrubbing, AVL checks, and obsolescence alerts, grounded in your own ERP data on-prem.