Every flight-leg record carries an equipment
field: a short code for the aircraft type operating the flight. It looks trivial — three
characters — but it hides a genuine source of confusion, because the industry maintains
two different type-coding systems, and they don’t look alike.
Two codes for the same aircraft
- IATA aircraft type code — three characters, used in schedules, reservations, and
most commercial systems. This is what appears in an SSIM equipment field.
- ICAO aircraft type designator — up to four characters, used in flight plans, air
traffic control, and operational/safety contexts.
Same aircraft, two codes:
| Aircraft |
IATA (3-char) |
ICAO (4-char) |
| Boeing 737-800 |
738 |
B738 |
| Airbus A320 |
320 |
A320 |
| Boeing 787-9 |
789 |
B789 |
| Boeing 777-300ER |
77W |
B77W |
Because the SSIM schedule speaks IATA, a system that
expects ICAO (or vice-versa) will mismatch on every row unless you map between them. That
mapping is one-to-… careful: it isn’t always clean, because the two systems slice
variants differently.
Why it’s not just cosmetic
The equipment code is a key you join on, and a proxy for real properties:
- Capacity and configuration. Type drives the seat count and cabin layout the
schedule implies — get the code wrong and your capacity analysis is wrong.
- Sub-fleet nuance. A single IATA code can cover aircraft an airline treats as
distinct sub-fleets (different configs, ranges, or performance). The schedule’s code may
be coarser than the operational reality.
- Cross-system joins. Pulling maintenance, performance, or ATC data alongside the
schedule means reconciling IATA↔ICAO. A silent mismatch drops rows or double-counts.
- New variants. As new types and re-engined variants enter service, code assignments
evolve; a hard-coded lookup rots.
The equipment field is three characters that stand in for an entire aircraft. Treat it
as a code to be mapped carefully, not a label to be trusted blindly.
Doing it right
Reading equipment well means recognising the schedule’s IATA codes for what they are,
mapping to ICAO (and to your own fleet taxonomy) deliberately, and being honest about
where one code covers sub-fleets you actually care about. It’s a small discipline that
prevents a whole class of quiet capacity and join errors downstream.
Parsing the equipment field faithfully — and keeping it attached to the right
leg — is part of reading a schedule correctly, which
is what SSIM Toolkit is built to do so you don’t re-solve it per pipeline.