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.
MB68864D090DFGFCLAMP631-700SHCOUPLING .250 T-BOLT CHANNEL BANDNH1008323-89CLAMP- .190 T-BOLT PROTECTIVE CHANNELMB68864E054CBHHCLAMPCF15-250JOINT ASSEMBLY FLEXIBLE HOT AIR24170-350ACLAMP, COUPLING, CHANNEL BAND, GROOVED, FLEXIBLEMJM68237-090COUPLING ASSEMBLYMB68864D050FDCLAMPMB68864E064DFGFCLAMP17351-300CLAMP, COUPLING, CHANNEL BAND, GROOVED, FLEXIBLEMGR68238-090O-RINGCF15-650JOINT ASSEMBLY FLEXIBLE HOT AIRMB68864E064BKJGCLAMP24366-200SLEEVECF15-400JOINT ASSEMBLY FLEXIBLE HOT AIR17351-400CLAMP, COUPLING, CHANNEL BAND, GROOVED, FLEXIBLECF15-550JOINT ASSEMBLY FLEXIBLE HOT AIR24098-400SLEEVE17351-150CLAMP, COUPLING, CHANNEL BAND, GROOVED, FLEXIBLE24170-200ARETAINER ASSEMBLY11684BLOCK LUG24098-550SLEEVE24170-250ACLAMP, COUPLING, CHANNEL BAND, GROOVED, FLEXIBLEMBS68472CLAMP4481-340-SHCOUPLING65790A00JA74CLAMPMB68864D064DDGHCLAMP50203-250CLAMP, COUPLING, CHANNEL BAND, GROOVED, FLEXIBLEMB68864E064CAFECLAMP11684-2BLOCK LUG50880-350COUPLING .2500 T-BOLT QUCIK COUPLER 40 DEGREES V-BAND24170-150ACLAMP, COUPLING, CHANNEL BAND, GROOVED, FLEXIBLE56477-500FLANGE, COUPLING CLAMP- FORMED, 500F, 321 CRES65790A46LA46CLAMPCF15-150JOINT ASSEMBLY FLEXIBLE - HOT AIR (CLAMPS)MFM67370-1000AFLANGECF15-900JOINT ASSEMBLY24366-150SLEEVE50880-550COUPLING .2500 T-BOLT QUCIK COUPLER 40 DEGREES V-BAND23098-10-575CLAMP- SUPPORT HALF17351-350CLAMP, COUPLING, CHANNEL BAND, GROOVED, FLEXIBLEMCF68312-650COUPLING .250 T-BOLT QUICK COUPLER CHANNEL BANDMB68864G093DAHACLAMP65790A90JACLAMP17351-200CLAMP, COUPLING, CHANNEL BAND, GROOVED, FLEXIBLEMBS67915-4GSUPPORT CLAMP 10-32 T-BOLT65790A22JA90CLAMP420-125-1100SHCLAMP .2500-28 T-BOLTMB68864G090DFGFCLAMP24170-400ACLAMP, COUPLING, CHANNEL BAND, GROOVED, FLEXIBLE
Back to Boeing 747-400D