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.
9624-03Panel-upper Inner shroudME80159-40Panel - Inner8388-27Panel-lower arm shroud140T2810-28Retainer284U1262-9ShimME94714-3Panel Assy LowerME95471-54Panel - AisleME95471-3Panel - Aisle9282-4LPanel-upper armME89494-31Panel Assy - Aisle Arm9823-06Panel-inner arm shroudME95474-3Panel InnerME81235-33Tray Table Insert161U1520-1Bushing66-18544-1Grounding Terminal69B82316-3Knob119U0013-2Washer69B80187-8Valve Assy161U1520-1Bushing9283-4CPanel-upper arm161T1209-1Nut-RetainerMEI 1441-1FTray Insert Model 940 Seat274T4628-1Piston162U1525-1Pin-Lower Cam66-13873-11Bearing Plate252U3211-3Bolt119U0012-1Shoulder Bolt112U4721-7Retainer, Seal274N1051-3Valve AssyMEI 74125Window Shade140U4001-3Spring Clip9823-03Panel-inner arm shroud66-13873-6Bearing PlateME85034-3Stop Assy - Table65B01570-9Actuator161U1005-4Sleeve142U1006-1Pin118U0010-77Washer Assy9162-38Panel-center arm Shroud161U0002-1Pin-Lower BearingMEI 690747-2Shroud274N1051-3Valve Assy65B82749-6Compensator AssyME97955-3Panel Assy LowerMEI 98810-24HPanel-Handicap Lower Arm163U0053-1Carrier Assy65B82585-4Actuator162U1521-1Retainer Bolt69B81791-1Bushing161T1222-1Washer
Back to Boeing 747-400D