First article inspection report template (Excel)
A blank Excel workbook laid out in the style of AS9102 Forms 1, 2 and 3, plus a PPAP-style dimensional results sheet. Free, no sign-up.
See it work in about a minute
The sample drawing ballooned, checked, measured and exported, filmed in the real tool. It is narrated, with captions on the video.
Read what the video says
Here's how BallooningTool turns an engineering drawing into a ballooned drawing and a first article inspection report, right in your browser. Open a PDF or an image of your drawing. It's processed on your own computer, so the drawing is never uploaded. The tool reads the drawing and suggests a balloon for every dimension, tolerance, thread and note. Accept the suggestions, then add, move or edit any balloon. Every new row stays marked until you've checked it. Type your measured results, or import them from your CMM. Pass and fail show up right away, against the limits. When you export, a final check shows the ballooned sheet and anything that's still open. You get a ballooned PDF, an Excel report laid out in the style of AS9102 Forms 1 to 3, and a CSV. Balloon and preview for free, and pay only when you export. Try it with your own drawing at this site.
Download a finished sample report
A made-up part with every value checked and measured: exactly the files the tool exports from one credit.
Ballooned drawing (PDF, 50 KB) Inspection report (Excel, 10 KB) Characteristics (CSV, 2 KB)Sample data only. The Excel report is laid out in the style of AS9102 Forms 1, 2 and 3; BallooningTool is not certified by SAE International, IAQG or AIAG.
What is in the workbook
| Sheet | What it records |
|---|---|
| Form 1 style: part number accountability | Part number and name, serial number, FAIR identifier, drawing number and revision, organization and supplier details, full or partial FAI, and sign-off. |
| Form 2 style: product accountability | Materials, special processes and functional tests, with specification numbers, supplier, certificate of conformance and acceptance. |
| Form 3 style: characteristic accountability | One row per characteristic: number, reference location, designator, requirement, results, tooling and non-conformance number. |
| Dimensional results (PPAP style) | Item, specification with limits, measured result and OK / not OK for each characteristic. |
How to fill it in
- Balloon the drawing. Give every dimension, tolerance, GD&T frame and note a number.
- List the characteristics on the Form 3 style sheet: number, location on the drawing, requirement and tolerance.
- Measure the first part and record each result. Anything out of tolerance gets a non-conformance number.
- Complete the part and product sheets (Forms 1 and 2 style) with the part details, materials and special processes.
Faster: fill it from the drawing
BallooningTool does the first three steps for you in the browser: it numbers the drawing, lists every characteristic with its limits, marks each result pass or fail and writes this same workbook, with the ballooned drawing as a PDF. Opening and ballooning are free; exporting costs one credit per drawing ($99), or a plan.
The template follows the layout commonly used for first article inspection reports. It is not an official SAE International or AIAG document and BallooningTool is not affiliated with either. Check your customer's requirements for the forms they accept.