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.
B539DD-PBEARING18303902-3Pressure GaugeB542DD-PBEARING36200027Pneumatic Break35207900M-13Fire Extinguisher Bottle Assembly9105M-1B1-01BEARINGB545DD-PBEARINGB540DD-PBEARINGKP72B-PBEARING9107M-1B1-01BEARINGKP16B-PBEARING35207900M-11Fire Extinguisher Bottle Assembly34505501MFire ExtinguisherB546DD-PBEARING1913-1B1-01BEARING34600001P-38Fire Extinguisher Bottle Assembly33600021-25Fire Extinguisher 224 Cu. In. CylindricalKP56B-PBEARING34505503P-24Fire Extinguisher 630 Cu. In.GDW8-PBEARING1902LLT-1C1-01BEARING1905LLT-1C1-01BEARING1908LT-1B1-01BEARING30100022-3Lavex Bottle Extinguisher Assembly34504901P-35Fire Extinguisher Bottle AssemblyKP23B-PBEARING33600021-36Fire Extinguisher Bottle Assembly3497900M-7Fire Extinguisher Hermetic Seal 1400 Cu. In.KP25B-PBEARINGB543DD-PBEARING35705500MFire Extinguisher33600022-26Fire Extinguisher 224 Cu. In.35207900M-6Fire Extinguisher Hermetic Seal 2500 Cu. In.34600001PFire Extinguisher6905-779Pressure GaugeKP21B-PBEARING34907900M-12Fire Extinguisher Bottle Assembly33603903PFire Extinguisher34505502Fire ExtinguisherKP49B-PBEARING1910-1B1-01BEARING34600001P-29Fire Extinguisher Dual Outlet Hermetic Sealed 630 Cu. In.34600001P-31Fire Extinguisher Dual Outlet Hermetic Sealed 630 Cu. In.34907900M-14Fire Extinguisher Bottle Assembly34504901MFire ExtinguisherDSP6-PBEARING34907900M-9Fire Extinguisher Hermetic Seal 1400 Cu. In.33600022-27Fire Extinguisher Cylindrical Hermetic Seal 224 Cu. In.33607504M-1Fire ExtinguisherKP29B-PBEARING
Back to Boeing 747-400D