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-1856BLANKET747R2654-2390BLANKET747R2654-1433BLANKET747R2654-1894BLANKET747R2654-1059BLANKET747R2654-3890BLANKET747R2654-1393BLANKET747R2654-2154BLANKET747R2654-3002BLANKET747R2654-3945BLANKET747R2654-3117BLANKET747R2654-3011BLANKET747R2654-3444BLANKET747R2654-3906BLANKET747R2654-2931BLANKET747R2654-3842BLANKET747R2654-1879BLANKET747R2654-3826BLANKET747R2654-3895BLANKET747R2654-3023BLANKET747R2654-3940BLANKET747R2654-2344BLANKET747R2654-1994BLANKET747R2654-3059BLANKET747R2654-3844BLANKET747R2654-2903BLANKET747R2654-3931BLANKET747R2654-3154BLANKET747R2654-1371BLANKET747R2654-2337BLANKET747R2654-1439BLANKET747R2654-1837BLANKET747R2654-3949BLANKET747R2654-1355BLANKET747R2654-3048BLANKET747R2654-3421BLANKET747R2654-2380BLANKET747R2654-3553BLANKET747R2654-3062BLANKET747R2654-3022BLANKET747R2654-2174BLANKET747R2654-3820BLANKET747R2654-3870BLANKET747R2654-3839BLANKET747R2654-2893BLANKET747R2654-1846BLANKET747R2654-3001BLANKET747R2654-2900BLANKET747R2654-3538BLANKET747R2654-3122BLANKET
Back to Boeing 747-400D