Boeing 747-400D
PMA parts · 105,720
Current parts manufacturer approvals (PMA): parts the FAA has approved companies to make as replacements or modifications. Each record lists its models as free text; OpenAirDocs matched them to this model on its data sheet, so check the FAA record before relying on it. Newest first.
Query with SQL
duckdb -csv -c "SELECT drs_guid, part_number, part_name, holder, pma_number, replaces_part, supplement_date, tcds_models
FROM 'https://openairdocs.org/data/latest/faa_type_certificate_pma.parquet'
WHERE tcds_number IN ('A20WE')
AND len(list_intersect(tcds_models, ['747-400D Series'])) > 0
ORDER BY supplement_date DESC, drs_guid DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT drs_guid, part_number, part_name, holder, pma_number, replaces_part, supplement_date, tcds_models
FROM 'https://openairdocs.org/data/latest/faa_type_certificate_pma.parquet'
WHERE tcds_number IN ('A20WE')
AND len(list_intersect(tcds_models, ['747-400D Series'])) > 0
ORDER BY supplement_date DESC, drs_guid DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
3237450-63STARBall-Bearing, Kit3234-1275STARBall Bearing, Kit3238329-215STARBall-Bearing, Kit8244VRW-189Marker- Pull2234552-110Installation Kit241594-02FSSwitch, Membrane, DBL Tail241596-01FSSwitch, Membrane, Double241603-01FSSwitch, Membrane, SGL Tail2235300-02Enhanced Airborne Data Loader (eADL)2235300-01-1Enhanced Airborne Data Loader (eADL)2235300-01Enhanced Airborne Data Loader (eADL)2235300-22Enhanced Airborne Data Loader (eADL)2235300-21Enhanced Airborne Data Loader (eADL)1176813-600CABLE ASSEMBLY AMCU J5 TO ISPS, UNIVERSAL (W CLOCKING)132588-13131313CABLE ASSY, USB PS TO USB W/O IUL (QUAD USB LEG)1068881-300CABLE ASSY, SEAT TO SWD/FD W/ GROUND WIRES (J1 CONN LOOSE)1191811-36CABLE ASSEMBLY, DISCONNECT TO ISPS1327-1-12USB OUTLET UNIT, SINGLE1325-1USB POWER SUPPLY1068861-138CABLE ASSEMBLY, SEAT TO SWD/FD (WITH GROUND WIRES)411637WERing-Sealing4004C5-5-10WERoller Set, Bearing3900248WEFilter Element, P3 Air3910817-01WEBushing, Sleeve, Flanged44490lWEKit - Lens Clear4004C8-8-10WERoller Bearing4004-6-6-20WERoller, Bearing Element4004-6-6-28WERoller, Bearing Element4004C6-6-20WERoller, Bearing Element4286-201BWEBearing, Liner4004C8-8-8WERoller, Bearing Element4004C8-8-22WERoller, Bearing4004C8-12-16WERoller, Bearing Element4004C6-7.5-16WERoller, Bearing Element505342WEScreen Assembly, Air Filter517980WERing- Sealing4004C9-9-12WERoller, Bearing Element4004C7-7-20WERoller, Bearing40695WEPin, Spring, Spiral4004-5-5-6WERoller, Bearing Element4004C7-7-12WERoller, Bearing Element4004-6-6-16WERoller, Bearing Element4004C6-10-32WERoller, Bearing4004C6-10D20WERoller Bearing4004-6-6-25WERoller, Bearing4004C8-8-20WERoller, Bearing411636WERing-Sealing3900432WESeal, Carbon4004C7.5-9-16WERoller Bearing4004-6-6D20WERoller, Bearing Element
Back to Boeing 747-400D