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.
BAC1521-365Seal ExtrusionBAC1522-842Miscellaneous, Plastic, ExtrudedBAC1521-735Seal ExtrusionBAC1522-267Plastic ExtrudedBAC1522-707Miscellaneous, Plastic, Extruded10-60754-846Seal10-60754-1162SealBAC1522-151Plastic ExtrusionBAC1522-271Plastic ExtrudedBAC1522-1052Plastic ExtrudedBAC1522-582Miscellaneous, Plastic, ExtrudedBAC1522-728Miscellaneous, Plastic, ExtrudedBAC1522-747Miscellaneous, Plastic, ExtrudedBAC1522-94Plastic Extruded10-60754-213SealBAC1522-503Miscellaneous, Plastic, Extruded10-60754-31SealBAC1522-1243Plastic ExtrudedBAC1522-1234Plastic ExtrudedBAC1521-851Seal ExtrusionBAC1522-839Miscellaneous, Plastic, ExtrudedBAC1521-153Seal ExtrusionBAC1522-586Miscellaneous, Plastic, ExtrudedBAC1522-1255Plastic ExtrudedBAC1522-127Plastic ExtrudedBAC1522-273Plastic ExtrudedBAC1522-888Miscellaneous, Plastic, ExtrudedBAC1522-362Miscellaneous, Plastic, ExtrudedBAC1522-496Miscellaneous, Plastic, ExtrudedBAC1522-164Plastic ExtrudedBAC1522-793Miscellaneous, Plastic, ExtrudedBAC1522-72Plastic ExtrudedBAC1521-634Seal Extrusion10-60754-661SealBAC1521-633Seal ExtrusionBAC1522-1246Plastic ExtrudedBAC1522-884Miscellaneous, Plastic, ExtrudedBAC1522-598Miscellaneous, Plastic, ExtrudedBAC1522-576Miscellaneous, Plastic, Extruded10-60754-874SealBAC1522-848Miscellaneous, Plastic, ExtrudedBAC1522-145Plastic Extruded10-60754-870SealBAC1522-745Miscellaneous, Plastic, ExtrudedBAC1522-170Plastic ExtrudedBAC1521-150Seal ExtrusionBAC1522-1264Plastic ExtrudedBAC1522-499Miscellaneous, Plastic, ExtrudedBAC1522-645Miscellaneous, Plastic, ExtrudedBAC1522-854Miscellaneous, Plastic, Extruded
Back to Boeing 747-400D