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.
BAC29PPS17105MarkerBAC29PPS17187MarkerBAC29PPS17011MarkerBAC29PPS17096MarkerBAC29PPS17093MarkerBAC29PPS17185MarkerBAC29PPS17101MarkerBAC29PPS17010MarkerBAC29PPS17189MarkerBAC29PPS17188MarkerBAC29PPS1719MarkerBAC29PPS1720MarkerBAC29PPS17020MarkerBAC29PPS17032MarkerBAC29PPS17202MarkerBAC29PPS17102MarkerBAC29PPS17199MarkerBAC29PPS17186MarkerBAC29PPS17055MarkerBAC29PPS16426MarkerBAC29PPS16431MarkerBAC29PPS14585MarkerBAC29PPS14590MarkerBAC29PPS16430MarkerBAC29PPS1644MarkerBAC29PPS16433MarkerBAC29PPS14591MarkerBAC29PPS16437MarkerBAC29PPS14589MarkerBAC29PPS16432MarkerBAC29PPS14553MarkerBAC29PPS14517MarkerBAC29PPS16428MarkerBAC29PPS16439MarkerBAC29PPS14551MarkerBAC29PPS16429MarkerBAC29PPS14584MarkerBAC29PPS14592MarkerBAC29PPS14588MarkerBAC29PPS14587MarkerBAC29PPS14494MarkerBAC29PPS16440MarkerBAC29PPS14582MarkerBAC29PPS14580MarkerBAC29PPS14583MarkerBAC29PPS16427MarkerBAC29PPS16438MarkerBAC29PPS14586MarkerBAC29PPS14552Marker41SG265-1MTSensor
Back to Boeing 747-400D