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.
3320550Power Control Package Outboard Flight Spoiler34620-23 Position Ground Spoiler Power Control Package3320690Ground Spoiler Power Control Packages544800-2Rotary2021814-1Rotary Actuator544800-2Rotary Actuator3320722Plug3170130-2Power Control Outboard Aileron3170130-4Power Control Outboard Aileron3170130-1Power Control Outboard Aileron33206003 Position Ground Spoiler Power Control PackageADP28005-110Pressure Switch580-1020-01LAInspection WindowN1495XLED LIGHT BULB57749-6WESeal - ChannelL1309XL1309 LED LIGHT BULBAG843000-17Gasket - UHF/VHF Antenna8050917-0010ANIPaperBAC27TCT0012MarkerBAC27TCT0014MarkerBAC27TCT0015MarkerBAC27EEL-6915MarkerBAC29PPS22336MarkerBAC27EEL-6916MarkerBAC27TCT0034MarkerBAC27TCT0010MarkerBAC27TCT0032MarkerBAC27TCT0017MarkerBAC27EEL-6913MarkerBAC27TCT0016MarkerBAC29PPS22338MarkerBAC27TCT0033MarkerBAC29PPS22328MarkerBAC27TCT0013MarkerBAC29PPS22335MarkerBAC27EEL-6914MarkerBAC29PPS22337MarkerBAC27TCT0031MarkerBAC27TFDE0330MarkerBAC29PPS3067MarkerBAC27TPP0467MarkerBAC27TPP0468MarkerBAC29PPS46021MarkerBAC29PPS15265MarkerBAC29PPS15257MarkerBAC29PPS15423MarkerBAC29PPS15279MarkerBAC29PPS15422MarkerBAC29PPS15318MarkerBAC29PPS15320Marker
Back to Boeing 747-400D