← The Aegis Quality Resource Library
Repeat 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 to use, change and copy inside your own organization. Editable Excel, plus a fillable PDF you can complete on screen.
The problem it solves
The same problem comes back under a new number. An audit finding about traveler stamps, closed with retraining, returns at the next year's audit as a new finding; a customer complaint follows an in-house NCR that was only corrected. Each lives in a different log, so nobody connects them, and the corrective action that did not work is never reopened. This register puts every event on one list, suggests the earlier events each one may repeat, and shows, for every confirmed repeat, whether the earlier corrective action failed, was too slow, or was never raised.
Who uses it, and when
Quality managers and engineers who own corrective action and internal audit, and whoever chairs the CAPA review. Add each event when it is logged, review the matches weekly, and take the Summary and Action check to the CAPA review and to management review.
Part of
CAPA Command Kit.
Clause references: 10.2, 10.2.1 (with 9.1.3). 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
workbook · Excel · fillable PDFRoot Cause Analysis Worksheet
A structured investigation in one place: problem statement, is / is-not, every candidate cause tested against the data, a 5 Whys chain with evidence, the six root cause tests, the escape cause, and a conclusion that reads Not yet until the work is done.
Free download →
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 →
template · Word · fillable PDFQuality Escape Investigation Template
For product that reached a customer: the timeline, every suspect part by location, what the customer was told and when, the detection point that failed and why, and actions at both the cause and the escape point.
Free download →
workbook · Excel · fillable PDFNonconformance 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 with your email →
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.