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.
2201-1Flasher 85 +/- 10FPM491B0700016-001KTNut-Self AligningPTR1110Track Roller BearingPTR1090Track Roller BearingPTR1190Track Roller Bearing332U2340-22TUBE ASSY413U3165-81TRIM65B01855-63SEAL DEPRESSOR69-30515-4HANDLE ASSY312T2359-11LINK ASSY65B80202-6CLIP65B01855-62SEAL DEPRESSOR65B02051-7SLEEVE654U6625-1566RETAINER401U3500-518DECORATIVE LAMINATEBAC27TEC0024POLYESTER MARKER -60B00179-2BEARING, BALL323U2325-80PLUG69-35343-5RING-CLAMP332U2113-12CLAMP BLOCK65B01856-130SEAL DEPRESSOR65B93108-1ROD66-18544-1GROUNDING TERMINAL314U2109-1TRANSITION DUCT ASSY65B01856-132SEAL DEPRESSOR65B07674-721MIDDLE PANE, HARD CO60B00179-100BEARING, BALL65C16899-6SPRING-TORSION65B08436-57SEAL ASSY69-12359-4FITTING-NUT65B15650-13SHAFT ASSY332U2801-1HOSE SHIELD ASSY - F332U2111-16HYD DRIP SHIELD ASSY413U3165-6TRIM69-63433-12CLAMP66-9236SAFETY GUIDE-65B08437-41SEAL ASSY65B62115-2GUTTER314U2110-1LOCATING PIN CF6-80C312T2359-36LINK ASSY65B51429-3STRAP ASSY65B60995-1HANGER311U2751-5RETAINER KEY, SIDE L418W1055-203ASPACER PANEL ASSY311U2751-1WASHER65B50742-5COVER ASSEMBLY - OUT65B50232-2SHADE413T3038-36DOOR GUIDE14330-235JPPlateSP3810-01-1020Spring
Back to Boeing 747-400D