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-174Plastic ExtrudedBAC1522-321Plastic, ExtrudedBAC1522-86Window Seal ExtrusionBAC1522-776Miscellaneous, Plastic, Extruded10-60754-805SealBAC1522-1166Plastic ExtrudedBAC1522-779Miscellaneous, Plastic, ExtrudedBAC1522-940Miscellaneous, Plastic, ExtrudedBAC1522-308Plastic, ExtrudedBAC1522-461Trim ExtrusionBAC1522-561Miscellaneous, Plastic, ExtrudedBAC1521-730Seal ExtrusionBAC1522-543Miscellaneous, Plastic, ExtrudedBAC1522-342Plastic, ExtrudedBAC1522-736Miscellaneous, Plastic, ExtrudedBAC1522-825Miscellaneous, Plastic, ExtrudedBAC1522-1188Plastic ExtrudedBAC1522-623Miscellaneous, Plastic, ExtrudedBAC1522-1254Plastic ExtrudedBAC1522-70Plastic Extruded10-60754-1088SealBAC1522-260Plastic ExtrudedBAC1522-566Miscellaneous, Plastic, Extruded10-60754-850SealBAC1522-173Plastic ExtrudedBAC1522-696Air Nozzle ExtrusionBAC1522-62Plastic ExtrudedBAC1522-166Plastic ExtrudedBAC1522-279Plastic, ExtrudedBAC1522-1218Plastic ExtrudedBAC1522-941Miscellaneous, Plastic, ExtrudedBAC1522-428Miscellaneous, Plastic, ExtrudedBAC1522-907Miscellaneous, Plastic, ExtrudedBAC1521-670Seal ExtrusionBAC1522-319Plastic, ExtrudedBAC1522-1092Plastic ExtrudedBAC1522-991Plastic ExtrudedBAC1522-797Miscellaneous, Plastic, ExtrudedBAC1522-471Miscellaneous, Plastic, ExtrudedBAC1522-939Miscellaneous, Plastic, Extruded10-60754-194SealBAC1522-558Miscellaneous, Plastic, ExtrudedBAC1521-941-870Seal ExtrusionBAC1522-812Miscellaneous, Plastic, ExtrudedBAC1522-23Plastic ExtrudedBAC1522-970Plastic ExtrudedBAC1522-994Plastic ExtrudedBAC1522-135Plastic Extruded10-60754-43Seal10-60754-189Seal
Back to Boeing 747-400D