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.
CP44346Oxley PAR 64 LED Landing LightCP44346-ACOxley PAR 64 LED Landing LightCP45324Oxley PAR 64 LED Landing LightDEC59-126-501Raceway-Narrow2307335-1LED Taxi Light/ Runway Turnoff LightTA1720SS2TWEClamp-Loop Cushioned330894WEWasher, Wave27648WERoller, Bearing3163540-2WEValve Housing3415-84PWERing, Retaining3168987-4WEFilter, Air2401-1Seal Assembly27114-2WEClamp-Loop Cushioned24730WESeal, NoseTA1720SS6TWEClamp-Loop Cushioned3415-102PWERing, Retaining231-700055-00-3704WEScrivet3163268-7WERing-Piston2793873-101WEDiaphragm Assembly27114-7WEClamp-Loop Cushioned3231188-1WESeal, Plain Encased3173837-2WELever and Retainer Assembly329282WEGrommet, Seal24728WEHeat Shield3235574-3WESwitch Assy Retract27114-4WEClamp-Loop Cushioned2793864-101WEDiaphragm3015234WENutTA1720SS3TWEClamp-Loop Cushioned252-146-1WEBar, Torque27114-6WEClamp-Loop Cushioned3235574-4WESwitch Assy- Extend330893WESpring-Garter3169407-1WEBearing, Ball-Annular24729WESeal-Mating27114-3WEClamp-Loop Cushioned3231392-1WESeal, Assembly32-0257-10WESealTA1720SS7TWEClamp-Loop Cushioned3169407-3WEBearing, Ball, AnnularTA1720SS4TWEClamp-Loop CushionedBAC29PPS8585MarkerJA24728Heat ShieldMDL4100390-003Vacuum Toilet Assembly Retrofit KitM5535-101Platen Assy, Sidewall290153-1KMHousingBAC27EFS604MarkerBAC27EFS602MarkerBAC27EEL25660MarkerBAC27EEL25659Marker
Back to Boeing 747-400D