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-462Trim ExtrusionBAC1522-1225Plastic ExtrudedBAC1522-410Miscellaneous, Plastic, Extruded10-60754-1181SealBAC1522-142Plastic ExtrudedBAC1522-375Miscellaneous, Plastic, ExtrudedBAC1522-828Miscellaneous, Plastic, ExtrudedBAC1522-836Miscellaneous, Plastic, ExtrudedBAC1522-154Plastic ExtrusionBAC1521-389Seal ExtrusionBAC1522-937Miscellaneous, Plastic, ExtrudedBAC1522-1251Plastic ExtrudedBAC1522-1086Plastic ExtrudedBAC1522-785Miscellaneous, Plastic, ExtrudedBAC1522-1204Plastic ExtrudedBAC1522-17Plastic ExtrudedBAC1521-738Seal ExtrusionBAC1522-1217Plastic ExtrudedBAC1522-1034Plastic ExtrudedBAC1522-1061Plastic ExtrudedBAC1522-917Miscellaneous, Plastic, ExtrudedBAC1522-1216Plastic ExtrudedBAC1522-1048Plastic ExtrudedBAC1521-889Seal ExtrusionBAC1522-942Miscellaneous, Plastic, ExtrudedBAC1521-162Seal ExtrusionBAC1522-1175Plastic ExtrudedBAC1521-602Seal ExtrusionBAC1522-1142Plastic ExtrudedBAC1522-1227Plastic ExtrudedBAC1521-762Seal ExtrusionBAC1521-569Seal ExtrusionBAC1521-638Seal ExtrusionBAC1522-843Miscellaneous, Plastic, ExtrudedBAC1522-134Plastic ExtrudedBAC1522-106Plastic ExtrudedBAC1522-549Miscellaneous, Plastic, ExtrudedBAC1522-111Plastic ExtrudedBAC1522-622Miscellaneous, Plastic, ExtrudedBAC1522-853Miscellaneous, Plastic, Extruded10-60754-131SealBAC1522-251Plastic ExtrudedBAC1522-572Miscellaneous, Plastic, ExtrudedBAC1521-631Seal ExtrusionBAC1521-775Seal ExtrusionBAC1522-688Miscellaneous, Plastic, ExtrudedBAC1522-891Miscellaneous, Plastic, Extruded10-60754-881SealBAC1521-758Seal ExtrusionBAC1522-165Plastic Extruded
Back to Boeing 747-400D