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.
2C5240Check Valve2C9710Check Valve2C6980Check Valve9R3258Restrictor Valve1C1964Check Valve2C9024Check Valve6F2602-2Check Valve6F2488Restrictor Valve1C2428Check Valve2C9110Check Valve2C9246Check Valve2S6258Check Valve2S2114Check Valve6F2482-1Restrictor Valve2C9080Check Valve2C9984Check ValveBAC27EPP0476DECALBAC27NEL1122MARKERBAC27TTR0036MARKERBAC27TTR-0046MARKERBAC27TTR69MARKERBAC27TTR-0016MARKERBAC27TTR0003MARKERBAC27TTR-0025MARKERBAC27TTR0004MARKERBAC27TTR0001MARKERBAC27TTR0035MARKERBAC27TTR61MARKER654U6075-750FITTING, KIT0A021-0103-01Potable Water Tank0A021-0224-11Potable Water Tank1C1106Check Valve2S7010Swing Check ValveLA00600X100A50D6O-Ring Dia6X11C3510ACheck Valve9R3322Valve1C4152Check Valve2S6930Check Drain Valve1C4150Check ValveLA01000X200A20B6O-Ring Dia10X21C3594Check Valve2C9482Check Valve9R3324Check Valve2S6298Check Valve2S6258-2Check Valve2C9344Check Valve1C3596Check Valve2S2110Swing Check Valve1C3510Check Valve6F4016-12Valve, Restrictor, Two Way
Back to Boeing 747-400D