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-2321BLANKET747R2654-3174BLANKET747R2654-1871BLANKET747R2654-1484BLANKET747R2654-3057BLANKET747R2654-2897BLANKET747R2654-1855BLANKET747R2654-3765BLANKET747R2654-3102BLANKET747R2654-2309BLANKET747R2654-2947BLANKET747R2654-3179BLANKET747R2654-2999BLANKET747R2654-3248BLANKET747R2654-3346BLANKET747R2654-3506BLANKET747R2654-2981BLANKET747R2654-1853BLANKET747R2654-2367BLANKET747R2654-2940BLANKET747R2654-3858BLANKET747R2654-3058BLANKET747R2654-3880BLANKET747R2654-3474BLANKET747R2654-3952BLANKET747R2654-2962BLANKET747R2654-2341BLANKET747R2654-1940BLANKET747R2654-1847BLANKET747R2654-2905BLANKET747R2654-2889BLANKET747R2654-1374BLANKET747R2654-2953BLANKET747R2654-1960BLANKET747R2654-3325BLANKET747R2654-3912BLANKET747R2654-3402BLANKET747R2654-3274BLANKET747R2654-2120BLANKET747R2654-3951BLANKET747R2654-2307BLANKET747R2654-1341BLANKET747R2654-3637BLANKET747R2654-3921BLANKET747R2654-3073BLANKET747R2654-2992BLANKET747R2654-3860BLANKET747R2654-3043BLANKET747R2654-3036BLANKET747R2654-3021BLANKET
Back to Boeing 747-400D