# Aerospace Key Characteristics Worksheet

> Source: https://netray.co/tools/aerospace-key-characteristics-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

List key characteristics, their risk, control method and capability so variation is managed where it matters most.

## Category

aerospace-defense

## Industry

Aerospace

## Audience

- Quality engineer
- Manufacturing engineer
- Supplier quality

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### KC ID

**Key:** kc

**Type:** text

#### Part number

**Key:** part

**Type:** text

#### Feature and requirement

**Key:** feature

**Type:** text

#### Designated by

**Key:** source

**Type:** select

**Options:**

- Customer
- Design engineering
- Supplier risk analysis
- Safety

#### Severity (1-10)

**Key:** severity

**Type:** number

#### Occurrence (1-10)

**Key:** occurrence

**Type:** number

#### Detection (1-10)

**Key:** detection

**Type:** number

#### Risk priority number

**Key:** rpn

**Type:** number

**Expr:** severity * occurrence * detection

#### Control method

**Key:** control

**Type:** select

**Options:**

- SPC chart
- 100% inspection
- Automated gaging
- Process lock and setup verification
- Sample plan

#### Cpk target

**Key:** cpk_target

**Type:** number

**Format:** decimal

#### Cpk actual

**Key:** cpk_actual

**Type:** number

**Format:** decimal

#### Cpk gap to target

**Key:** gap

**Type:** number

**Format:** decimal

**Expr:** cpk_actual - cpk_target

#### Owner

**Key:** owner

**Type:** text

**Rows:**

**Kc:** KC-01

**Part:** A2214-0087

**Feature:** Bore diameter 12.000 +0.018/-0

**Source:** Customer

**Severity:** 8

**Occurrence:** 3

**Detection:** 3

**Control:** SPC chart

**Cpk target:** 1.67

**Cpk actual:** 1.82

**Owner:** Quality eng.

**Kc:** KC-02

**Part:** A2214-0087

**Feature:** Bore position to datum A, 0.10 dia

**Source:** Design engineering

**Severity:** 8

**Occurrence:** 4

**Detection:** 4

**Control:** Automated gaging

**Cpk target:** 1.33

**Cpk actual:** 1.21

**Owner:** Mfg. eng.

**Kc:** KC-03

**Part:** A2214-0102

**Feature:** Wall thickness min 1.50

**Source:** Safety

**Severity:** 10

**Occurrence:** 2

**Detection:** 3

**Control:** 100% inspection

**Cpk target:** 1.33

**Cpk actual:** 1.45

**Owner:** Inspection lead

**Kc:** KC-04

**Part:** A3320-0011

**Feature:** Shot peen intensity per spec

**Source:** Customer

**Severity:** 9

**Occurrence:** 3

**Detection:** 5

**Control:** Process lock and setup verification

**Cpk target:** 1.33

**Cpk actual:** 1.5

**Owner:** Special process lead

**Kc:** KC-05

**Part:** A3320-0011

**Feature:** Thread pitch diameter 1/4-28 UNJF

**Source:** Supplier risk analysis

**Severity:** 7

**Occurrence:** 4

**Detection:** 3

**Control:** Sample plan

**Cpk target:** 1.33

**Cpk actual:** 1.38

**Owner:** Quality eng.

**Totals:**

#### Key characteristics listed

**Key:** kc

**Agg:** count

#### Highest RPN

**Key:** rpn

**Agg:** max

**Format:** integer

#### Lowest Cpk gap

**Key:** gap

**Agg:** min

**Format:** decimal

**Notes:** A negative Cpk gap means the process does not yet meet the target and needs improvement or 100% inspection until it does. Capability targets here (1.33 and 1.67) are common examples; use the value your customer or AS9103-based procedure specifies. RPN is a prioritization aid, not a replacement for judgment.

## Content

**Intro:** Key characteristics are the features whose variation most affects fit, form, function, performance or service life. AS9103 asks suppliers to manage that variation deliberately. This worksheet keeps the list, the risk rating, the control method and the capability gap in one place.

**Sections:**

#### How to use the worksheet

**Body:** Start from the characteristics the customer or design authority designates. Add features your own risk analysis identifies, then rate severity, occurrence and detection. Choose a control method for each and record the Cpk target and the latest actual value. The gap column shows where capability falls short. Export to Excel for your control plan or for customer review.

**Bullets:**

- Link each KC to the drawing characteristic number used in the FAI
- Update Cpk actual from real SPC data, not an estimate
- Review the list when drawings or processes change
- Assign an owner for every row

#### What AS9103 requires

**Body:** AS9103 covers variation management of key characteristics. The flow is to identify the KCs, determine the process and its sources of variation, collect data, assess capability, and improve or control the process where capability is insufficient. Customers specify their own thresholds, and the standard gives guidance on sampling and on actions when capability is not demonstrated, such as interim 100% inspection.

#### Reading the table

**Body:** Sort by RPN to see where risk concentrates, then look at the capability gap. A high-severity feature with a negative gap needs immediate containment. A high Cpk with a poor detection score may justify reducing inspection effort. In the example, KC-02 has a gap of minus 0.12, so the position tolerance needs setup improvement or full inspection until capability reaches the target.

#### Common mistakes

**Body:** Teams often designate too many characteristics, which dilutes attention, or compute Cpk from too few parts or from a non-normal distribution. Record how Cpk was calculated and over what period. In SAP QM, SyteLine or Epicor, flag KC characteristics in the inspection plan so results feed the same SPC history every time.

**Cta:** If you need key characteristic results pulled from your ERP inspection data into capability reports, we can help build that on your own servers.

**Faq:**

#### What is a key characteristic?

**Answer:** A key characteristic is a feature of a material, process or part whose variation has a significant influence on product fit, performance, service life or manufacturability. It is designated by the customer or design authority, or identified by the supplier's own risk analysis, and managed with extra controls.

#### What Cpk is required for key characteristics?

**Answer:** It depends on your customer. Values such as 1.33 and 1.67 are widely used as targets, but the contract or customer procedure sets the actual requirement. When capability is not shown, many customers require 100% inspection as a temporary measure until it is.

#### How do key characteristics relate to the FAI?

**Answer:** Key characteristics appear on the first article Form 3 with a designator, and later in production they are controlled through SPC or other methods. Keeping a single ID across FAI, control plan and inspection plan avoids mismatches during audits.

#### Is RPN required by AS9103?

**Answer:** No. RPN is a common FMEA scoring method used here for prioritization. AS9103 does not mandate it. If your FMEA uses action priority instead, replace the columns to match your procedure.

## Search terms

key characteristics worksheet, AS9103 key characteristics, key characteristic list template, variation management aerospace, key characteristics excel, KC control plan aerospace, special characteristics list, AS9103 variation management of key characteristics

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json