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.
SSMDPP4SD633ZNBEARINGSSMDPP10SD668BEARINGSSMDSP3SD668BEARINGSSMB546DDSD668BEARINGSSMB546SD684ZNBEARINGSSMDSP5SD633BEARINGSSMDSP10SD668BEARINGSSMB546DDSD683BEARINGSSMDPP6SD633BEARINGSSMB546SD686BEARINGSSMDSP3SD633ZNBEARINGSSMDPP6SD633ZNBEARINGSSMDPP3SD633ZNBEARINGSSMB546DDSD685BEARINGSSMDPP3SD668BEARINGSSMDSP3SD633BEARINGSSMDPP10SD633BEARINGSSMDPP10SD633ZNBEARINGSSMDPP8SD633ZNBEARINGSSMDSP10SD633ZNBEARINGSSMB546SD684BEARINGSP3810-01-1050Rod, DrainAR138-5-2KTGalley Latch Assy5660-040-000000FSLight -Floor TrayP00569StemA3FS301-D01Master Drawing ListQ4559-LEDQ4559-LED PAR64 LampQ4559-LEDQ4559-LED PAR64 LampDEC59-163-503Rub StripDEC59-163-501Rub StripDEC69-066-503Filter, Air15800-359-8EHO-Ring22DCMX3580DRESS COVER OTTOMAN22LR2800LEGREST CUSHION22BK8400BACKREST CUSHION22MX7400OTTOMAN CUSHION22DCMX3570DRESS COVER OTTOMAN22MX7100OTTOMAN CUSHION22DCMX3490DRESS COVER OTTOMAN22MX8200OTTOMAN CUSHION22DCMX3510DRESS COVER OTTOMAN22DCMX3560DRESS COVER OTTOMAN22DCLR3470DRESS COVER LEGREST22MX7200OTTOMAN CUSHION22DCBM3460DRESS COVER BOTTOM, RH22DCMX3410DRESS COVER TOPPER22DCBK3430DRESS COVER BACK, LH22DCBK3440DRESS COVER BACK, RH22DCBM3450DRESS COVER BOTTOM, LH22MX7800OTTOMAN CUSHION
Back to Boeing 747-400D