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.
65B15181-1Brace015U0817-602Bracket65B15181-2Brace65B12246-609Former65B22858-6Support65B15629-30Web69B11342-8Angle65B11743-3Fitting65B08130-84Hinge Assembly65B10920-190Seal65B14962-6Panel Assembly69B13709-2Tee69B10566-8Hinge Assembly65B14063-5Channel65B15016-6Rib Assembly65B08347-48Latch Track65B12727-11Stiffener Channel65B12724-3Zee65B11365-4Zee69B13823-4Fitting Assembly65B14963-45Panel Assembly65B13171-66Seal Support65B15089-10Filler65B15181-13Brace65B15963-91Panel Assembly69B12003-1Tee69B40017-5Duct Support69B12645-18Flap Deflector69B42542-1Bracket65B08347-35Latch Track Assy.65B22858-9Support65B80259-96Bracket Assembly65B12915-1Retainer65B14061-13Channel65B15256-80Chord69B11629-8Fitting Assembly65B15080-1Fitting65B10882-92Access Door Assy. - Right Wing (Refueling Nozzles)65B08319-15Stop Fitting65B08347-30Latch Track65B12790-29Hinge Assembly66B10007-1Washer65B12790-35Hinge Assembly69B11350-10Link Assembly65B14963-37Panel Assembly - Upper, INBD Nacelle, Wing Leading Edge65B14061-1Channel65B10881-1Panel Assembly69B14751-2Hinge, Half - Up65B22858-20Support65B12091-9Fitting Assembly
Back to Boeing 747-400D