Resource Library/Product Integrity and Aerospace Requirements/Material Traceability Register
Material Traceability Register
Every material receipt with its heat checked against its certificate, every issue to a work order with the marking carried, the balance left on the rack, and a lookup that answers 'this heat is suspect: where did it go?' in minutes.
- Excel
- fillable PDF
- Worked example
- Your logo on it
- Aegis Insights
Page 1 of the PDF. Every resource includes a fully worked example.
The problem it solves
Traceability usually fails in two places nobody watches: at receiving, where a certificate is filed because it matches the purchase order rather than the bar, and at the saw, where a bar is cut, the marked end is scrapped and the remnant goes back on the rack with no heat on it. Then a heat turns suspect, or an auditor picks a finished part, and the answer takes an afternoon of digging through travelers. This register records every receipt with the heat checked against the certificate, every issue with the marking carried onto the traveler and the remnant, the balance left, and a lookup that goes from a heat to every work order it fed.
Who uses it
Receiving inspectors and stores, who keep it; quality engineers and supplier quality, who use it for containment and audits.
When
Add a receipt line at receiving and an issue line at every issue; use the lookup whenever a heat or a supplier is in question; read the Summary weekly.
Free to use, change and copy, in your own organization or with your clients; add your own logo, keep the Aegis credit. Clause references: 8.5.2 (with 8.4.2, 8.1.4, 8.7.1) (numbers only; use your own licensed copy of the standard).
A management aid, not certification or a registrar audit. Using it does not by itself show conformity to AS9100D or any other standard.
How to put it to work
Chapters of our free guides that use this tool.
- The kitThe MRB and Nonconformance Kit Handbook, chapter 2
- Suspect counterfeit parts and suspect materialThe MRB and Nonconformance Kit Handbook, chapter 12
- Worked example: October at Meridian AerostructuresThe MRB and Nonconformance Kit Handbook, chapter 21
- Where the kit touches AS9100DThe MRB and Nonconformance Kit Handbook, chapter 26
Related resources
-
Exercise
Product Traceability Challenge
An exercise with an answer key: walk a finished aerospace fitting back through its records to the mill heat, find where the chain breaks, then time the same walk on a part from your own shop.
Excel · PDFFree by email -
Template
Counterfeit Parts Prevention Plan
A written plan you adopt and edit: which parts and materials are at risk, where you may buy them, what your purchase orders flow down, what receiving checks by risk, how traceability is kept, and exactly what happens to a suspect part, from the shelf it goes on to who is told.
Word · PDFFree download -
Worksheet
IA9100 Counterfeit-Parts Risk and Obsolescence Tracker
Where every part comes from, which receipts get extra checks, what is about to go end of life, and what happens to a suspect lot.
Excel · PDFFree by email -
Workbook
MRB Disposition Record and Log
One record per material review board case, from the evaluation to the signatures to the product action, and one log that ages every open case, tracks every customer authorization and flags any use-as-is or repair released without the approvals it needs.
Excel · PDFFree by email -
Workbook
Product Safety Risk Assessment
List the parts that carry product safety, assess what in your own processes could defeat each safety-relevant characteristic with a plain severity and likelihood rating you control, and record the controls, the actions and who accepted any risk that remains High.
Excel · PDFFree download -
Workbook
Special Process Supplier Control Matrix
Show that whoever performs each special process on your parts, including your suppliers' own sources, is qualified for that exact process: scope, specifications, customer approvals, expiry dates, certificates, performance and oversight on one line.
Excel · PDFFree by email
Need more than one resource, or not sure where to start? Book a complimentary 30-minute Aegis Quality Guidance Call. We'll find the tools that fit your situation and a sensible place to start. No sales pressure, no obligation.
These tools help you run the work by hand. When you want the whole picture of your quality system from the records you already keep, that's what the AeroAssure Audit Defense Pack and the IA9100 Transition Gap Analysis do.