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.
417U3083-7001PADDLE - ATTENDANT OXYGEN BOX417U3081-5416OXY BX ASSY NON FREE FLOW 35IN STREAMERS 4IN DROP 75IN LONG HALFIN CEILING PANEL417U3081-4268Oxy Box Assy417U3060-3401Oxy Box Assy417U3075-7102BPANEL ASSY - TEMPERATURE SENSOR, OUTBD417U3067-3007Door Assy417U3081-1052Door Assy418W1057-13AGap Seal Outboard1378M16P01DECLink11-6562-1ATSBEZEL ASSEMBLY1378M17G01DECLink Assy-ArmAD-244149-A01Housing Assembly, DPCUSP3810-16-1025Ring, RetainingSP3810-01-1045Plate, ClampSP3810-09-1005HNNut, HexSP3810-01-1030Clamp AssySP3810-01-1040Clamp BracketSSMKP25BS-PBEARINGSSMB545DDR-PBEARINGANZMB544DDR-PBEARINGANZMKSP10-PBEARINGANZMKP16B-PBEARINGANZMKSP6A-PBEARINGANZMKP21BS-PBEARINGSSMB546DD-PBEARINGANZMB543DDR-PBEARINGSSMB545DD-PBEARINGANZMKP25B-PBEARINGSSMKP23B-PBEARINGANZMKSP4A-PBEARINGSSMKP23BSR-PBEARINGANZMKSP5-PBEARINGANZMB542DD-PBEARINGANZMKSP5A-PBEARINGSSMKP23BR-PBEARINGANZMKP6AR-PBEARINGANZMKSP4-PBEARINGANZMKP37BSR-PBEARINGSSMKP29B-PBEARINGSSMB541DDR-PBEARINGANZMKP16BSR-PBEARINGANZMB543-EBEARINGSSMB539DD-PBEARINGSSMKP37BSR-PBEARINGSSMKP33BSR-PBEARINGSSMKSP6A-PBEARINGSSMKSP10-PBEARINGANZMKP56B-PBEARINGANZMKP8AR-PBEARINGSSMKP25BR-PBEARING
Back to Boeing 747-400D