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.
28VS200Y-4B-2Power Supply123-30Clamp327-2Clip400-121Switch Guard405-112Switch Guard123-3232-FClamp, Instrument Panel Mount023802-002DUCT ASSEMBLY - AISLE STAND400-112Switch Guard235-5ADuct AssySP3810-00-1045SetscrewAG723000-40Gasket - RAD ALT AntennaAG723000-40Gasket - RAD ALT AntennaAG822000-03Gasket - TCAS AntennaAG822000-03Gasket - TCAS AntennaA1172577SFSPaper, Roll713225-111SFSPaper, Roll8050917-0010SFSPaper, Roll491B1613043-001DECShim69B47961-3FILLER ROD69B14108-9HOOK ASSY69B60598-1COVER ASSY69B02762-16CABLE ASSY310U2041-1RETAINER BASE ASSY287T0031-5SEALING RING69B56683-1PIN AND STREAMER ASY140N2023-1VALVE ASSY140U4006-615WINDOW ASSY69B04631-1SEAL69B00501-1PLATE ASSY118U0010-77WASHER ASSY140W2810-22VALVE ASSY69B15036-4BEARING69B12071-2CHANNEL69B10006-17BOLT69B15227-1BUSHING69-68855-2SPRING69B00095-1SPRING-PIN RETAINER69B90801-2GASKET69B13765-6SEAL RETAINER- OUTBD69B52048-1PIN284U7032-21LENS69B50620-1TRACK CAP69B00500-2RETAINER ASSY69B15228-1WASHER287T0031-4SEALING RING69B41178-3GASKET287T0031-1SEAL RING140U4005-615PANE, OUTER270T0002-42BALL-BEARING310U2042-3BOLT RETAINER
Back to Boeing 747-400D