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-3144BLANKET747R2654-3614BLANKET747R2654-1483BLANKET747R2654-3806BLANKET747R2654-2968BLANKET747R2654-1838BLANKET747R2654-1907BLANKET747R2654-3330BLANKET747R2654-3828BLANKET747R2654-3947BLANKET747R2654-1852BLANKET747R2654-3958BLANKET747R2654-1861BLANKET747R2654-2240BLANKET747R2654-2910BLANKET747R2654-3133BLANKET747R2654-3078BLANKET747R2654-1933BLANKET747R2654-3425BLANKET747R2654-2304BLANKET747R2654-3000BLANKET747R2654-2987BLANKET747R2654-1351BLANKET747R2654-3963BLANKET747R2654-1052BLANKET747R2654-2943BLANKET747R2654-3865BLANKET747R2654-3012BLANKET747R2654-1489BLANKET747R2654-1486BLANKET747R2654-3050BLANKET747R2654-1056BLANKET747R2654-2306BLANKET747R2654-3835BLANKET747R2654-3954BLANKET747R2654-2937BLANKET747R2654-3634BLANKET747R2654-3066BLANKET747R2654-3902BLANKET747R2654-3702BLANKET747R2654-3112BLANKET747R2654-3814BLANKET747R2654-1004BLANKET747R2654-1485BLANKET747R2654-2359BLANKET747R2654-3937BLANKET747R2654-2969BLANKET747R2654-3139BLANKET747R2654-2345BLANKET747R2654-3190BLANKET
Back to Boeing 747-400D