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.
747R2654-1373BLANKET747R2654-3068BLANKET747R2654-2313BLANKET747R2654-2318BLANKET747R2654-3815BLANKET747R2654-1438BLANKET747R2654-2988BLANKET747R2654-2887BLANKET747R2654-3832BLANKET747R2654-3759BLANKET747R2654-3335BLANKET747R2654-2335BLANKET747R2654-3812BLANKET747R2654-1345BLANKET747R2654-2014BLANKET747R2654-1973BLANKET747R2654-3427BLANKET747R2654-2952BLANKET747R2654-2187BLANKET747R2654-3054BLANKET747R2654-3092BLANKET747R2654-1343BLANKET747R2654-1884BLANKET747R2654-3321BLANKET747R2654-3723BLANKET747R2654-2381BLANKET747R2654-2934BLANKET747R2654-3061BLANKET747R2654-3035BLANKET747R2654-3845BLANKET747R2654-3027BLANKET747R2654-3431BLANKET747R2654-2896BLANKET747R2654-3041BLANKET747R2654-3850BLANKET747R2654-3517BLANKET747R2654-3834BLANKET747R2654-1487BLANKET747R2654-2932BLANKET747R2654-2333BLANKET747R2654-2966BLANKET747R2654-2040BLANKET747R2654-2977BLANKET747R2654-3907BLANKET747R2654-3356BLANKET747R2654-1448BLANKET747R2654-2379BLANKET747R2654-3045BLANKET747R2654-3818BLANKET747R2654-3007BLANKET
Back to Boeing 747-400D