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.
BAC1522-1045Plastic Extruded10-60754-803SealBAC1522-606Miscellaneous, Plastic, Extruded10-60754-119SealBAC1522-542Miscellaneous, Plastic, ExtrudedBAC1522-981Plastic Extruded10-60754-459SealBAC1522-104Plastic ExtrudedBAC1522-552Miscellaneous, Plastic, ExtrudedBAC1522-1206Plastic ExtrudedBAC1522-1012Plastic ExtrudedBAC1522-990Plastic ExtrudedBAC1521-763Seal ExtrusionBAC1522-230Plastic ExtrudedBAC1522-346Plastic, ExtrudedBAC1522-424Miscellaneous, Plastic, ExtrudedBAC1522-924Miscellaneous, Plastic, Extruded10-60754-804SealBAC1522-1213Plastic ExtrudedBAC1522-512Miscellaneous, Plastic, ExtrudedBAC1522-563Miscellaneous, Plastic, ExtrudedBAC1522-620Miscellaneous, Plastic, ExtrudedBAC1522-1144Plastic Extruded10-60754-27SealBAC1522-167Plastic ExtrudedBAC1522-1030Plastic ExtrudedBAC1521-671Seal ExtrusionBAC1522-596Miscellaneous, Plastic, ExtrudedBAC1522-827Miscellaneous, Plastic, ExtrudedBAC1522-442Miscellaneous, Plastic, ExtrudedBAC1521-520Seal ExtrusionBAC1521-550Seal ExtrusionBAC1522-567Miscellaneous, Plastic, ExtrudedBAC1522-674Miscellaneous, Plastic, ExtrudedBAC1521-400Seal Extrusion10-60754-221SealBAC1522-861Miscellaneous, Plastic, Extruded10-60754-313SealBAC1522-1178Plastic ExtrudedBAC1522-1120Plastic ExtrudedBAC1522-921Miscellaneous, Plastic, ExtrudedBAC1522-756Miscellaneous, Plastic, ExtrudedBAC1522-268Plastic ExtrudedBAC1522-493Miscellaneous, Plastic, ExtrudedBAC1521-719Seal ExtrusionBAC1522-1170Plastic ExtrudedBAC1522-1236Plastic ExtrudedBAC1522-158Plastic ExtrusionBAC1522-378Trim ExtrusionBAC1522-925Miscellaneous, Plastic, Extruded
Back to Boeing 747-400D