← The Aegis Quality Resource Library
Nonconformance Management Log
One line per NCR, from the moment it is found to the moment it is closed: the part, the requirement, where it was found, the disposition and who authorized it, customer approval, cost, the corrective action link and how long it has been open.
Free to use, change and copy inside your own organization. Editable Excel, plus a fillable PDF you can complete on screen.
The problem it solves
NCRs get written. What gets lost is everything after: which ones are still waiting for a disposition, which use-as-is is still waiting for the customer, who signed off the rework, what the scrap cost, and whether anyone opened the corrective action. The answers sit in a stack of forms or a quarantine cage, and they come out only when an auditor or a customer asks. This log keeps every NCR on one line, ages the open ones, flags the missing approval or authorization, and counts where nonconformances are found, how they are dispositioned and what they cost.
Who uses it, and when
Quality engineers who run nonconformance and MRB, the supervisors and inspectors who raise NCRs, and the managers who review them. Add a line when the NCR is written, update it at each MRB, and take the Summary and Breakdown to the weekly MRB and to management review.
Part of
MRB and Nonconformance Kit, CAPA Command Kit.
Clause references: 8.7, 8.7.1, 8.7.2 (with 10.2). Clause numbers only; the standards text is not reproduced, use your own licensed copy.
A management aid, not certification or a registrar audit. Using it does not by itself show conformity to AS9100D or any other standard.
Page 1 of the PDF. Every resource includes a worked example.
Related resources
worksheet · Excel · fillable PDFCAPA Effectiveness Verification Worksheet
Prove a corrective action worked, not just that it was done: separate containment, correction and corrective action, set a measurable criterion before the action goes in, and hold the record open until the evidence is in.
Free with your email →
workbook · Excel · fillable PDFCorrective Action Aging and Program Health Dashboard
See at a glance how many corrective actions are open, how old they are, which are late, where they are stuck and how many of the closed ones were shown to work, from one plain CAPA log.
Free with your email →
workbook · Excel · fillable PDFRepeat Finding Analysis Register
Link nonconformances, audit findings and complaints that share a failure mode, part family or process, flag the repeats inside a window you set, and see which corrective actions failed to prevent them.
Free with your email →
checklist · Word · fillable PDFContainment and Corrective Action Verification Checklist
Two checklists: one to confirm containment reached every suspect part, wherever it is, and one to confirm a corrective action is in place where the work is done and has worked, before anyone signs it closed.
Free download →
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.