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.
SF15-103-235SEALSF15-103-279AERODYNAMIC SEAL6565-23SEAL9562SEALS-13117-7Seal5673-1088SEAL5673-874SEALS-14644-22SEALS-16954SEALSF15-103-234SEALS-13117-212Seal-PlugS-13117-523SEAL8425-66Seal, Aerodynamic - FireproofS-17475-2GASKET800-206SealSF15-103-869SEAL AERODYNAMIC8425-209SEALBACG20AF6B1GROMMETSF15-103-872SEAL AERODYNAMIC8425-180SEALS-13117-832BULB SEAL5673-1097AERODYNAMIC SEAL6565-24Seal800-236SEAL, AERODYNAMIC8425-181SEALS-13117-121SealS-14644-26SEALB-5132-8RUBBER BOOT ASSYS-14644-1SEAL5673-7SealS-13117-279AERODYNAMIC SEALS-15936-1SEALE-ENGINE BREATHER DUCTBACG20AF4B2GROMMETS-14644-11SEALS-17381-2SEAL ASSYS-13117-213Seal-Plug5673-265SEAL6565-21SEAL5673-279SEAL8453-67Fire Seal800-120Seal8425-183SEALS-13117-1088SEALS-13117-94SEALSF15-103-419SEALBACG20AF3C1GROMMET8425-182SEALSF15-103-871SEAL AERODYNAMIC800-121SealBACG20AF3C2JGROMMET
Back to Boeing 747-400D