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.
22DCLR3480DRESS COVER LEGREST EXT.22MX7700OTTOMAN CUSHION22DCMX3590DRESS COVER OTTOMAN22DCMX3600DRESS COVER OTTOMAN22MX7600OTTOMAN CUSHION22DCMX3550DRESS COVER OTTOMAN22DCMX3610DRESS COVER OTTOMAN22BM6200BOTTOM CUSHION22DCMX3540DRESS COVER OTTOMAN22MX8000OTTOMAN CUSHION22DCHR3420DRESS COVER HEADREST22DCMX3530DRESS COVER OTTOMAN22DCMX3520DRESS COVER OTTOMAN22HR4400HEADREST CUSHION22MX8100OTTOMAN CUSHION22DCMX3500DRESS COVER OTTOMAN22MX7900OTTOMAN CUSHION22MX7000OTTOMAN CUSHION22MX7300OTTOMAN CUSHION22MX7500OTTOMAN CUSHION2165-5Voltage, Averaging Module2165-4Voltage, Averaging ModuleYR44WPP2FTA2686BearingAG477000-16Gasket - GPS/Satcom AntennaAG282000-08Gasket - DME/TCAS/ Transponder AntennaSSMB545SD684ZNBEARINGSSMB545DDSD633BEARING22DCBK3390-219ABACK INSERT DRESS COVER22DCBM3400-225ABOTTOM DRESS COVERSSMB545SD634BEARING22DCBK3380-207BBACK COLLAR DRESS COVER22DCBK3380-207ABACK COLLAR DRESS COVERSSMB545SD669BEARINGDEC59-141-548Slider PlateSSMB545DDSD668BEARING22DCBK3380-215BBACK COLLAR DRESS COVER NO VID22DCBK3380-211ABACK COLLAR DRESS COVERSSMB545SD634ZNBEARING22DCHR3370-201AHEADREST DRESS COVERSP3810-00-3035Fitting, End22DCHR3370-203AHEADREST DRESS COVERSSMB544SD669BEARINGSSMB544DDSD683BEARING22DCBK3390-217ABACK INSERT DRESS COVER22DCBM3400-223ABOTTOM DRESS COVER22BK8300BACKREST CUSHION22DCBM3400-225BBOTTOM DRESS COVERDEC59-141-547Slider PlateSSMB543SD686BEARINGSSMB544DDSD685BEARING
Back to Boeing 747-400D