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.
SP3822-15-1235Gasket, Rinse Nozzle224-2301-71DECWear Strip310T1036-24WEBolt- Shoulder43-1335WEBolt7066M26P02DECLimiter Deflection774636-3DECBellows, Evacuated1314M14P01DECDisk-Deflection Limiter1117119-01Restraint System1117032-01Restraint System1117119-03Restraint System1117032-05Restraint System0108901-01Restraint System1117032-03Restraint System251U4500-2Tube Assy161U1001-1Bushing284U1262-9Shim274T4628-1Piston274T4627-1Cap65B82585-4Actuator284A7700-39Tray Assy163U0053-1Carrier Assy161U1520-1Bushing118U0010-77Washer Assy66-13873-8Bearing Plate112U4721-1Fitting Assy161T1209-1Nut-Retainer69B82316-3Knob119U0013-1Washer69B70231-1Nut-Jam161T1222-1Washer162U1520-1Bolt65B82749-6Compensator Assy162U1521-1Retainer Bolt69B47882-1Jack119U0012-1Shoulder Bolt119U0013-4Washer274U0003-2Valve Assy119U0013-3Washer69B82321-3Fork112N4508-1Washer140T2810-28Retainer140U4001-3Spring Clip163U6009-1Spacer163U6001-5Hub Cap252U3211-3Bolt274T4626-1Plug270T0002-42Ball-Bearing65B01570-9Actuator274T4629-4Plug315A1802-4Tee Assy
Back to Boeing 747-400D