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.
315-1Number Reminder024806-001Rudder Trim Switch Assy024804-002Rudder Trim Switch Assy1103P1349Switch, PressureP01091ShaftP01092Rotor5905730WDWasher, KeyS750461-12WDBushing732018-29WDHeaded Straight Pin799380-3WDLever, ControlB42365-1Quick disconnect fitting224-1340-19SDWeld Assy43445007KTAsh ReceiverAssy8247MBS-35Marker- FuelingP152537Cam, ClutchP100138-26Switch3031419JP-001Element, Sealing411U1232-12REVEAL, OUTER401-67828-01WDLockwasher, Cup421W1281-4ACOUPON-OUTBD65B42530-11FILTER COVER69B81154-2ROLLER STOP214T2471-1NOZZLE65B50095-12ASSY-SHADE311U4536-3FAIRING PANEL NO. 3413U1525-8SHROUD SUPPORT413U1525-7SHROUD SUPPORT411U1232-14REVEAL, OUTER411A4902-6RETAINER CLIP ASSY411A4902-7RETAINER CLIP ASSY422W1181-11ACOUPON417U6006-104CUP ASSY411W1602-5ASHADE ASSY65B12341-18FITTING-HINGE HALF311U4536-4FAIRING PANEL NO. 3411W1602-6ASHADE214U2105-1INLET ASSY65B67345-5BRACKET ASSY310U2308-1FUSE PIN65B12344-43HINGE FLAP ASSY65B01836-611DOUBLER310U2020-18MOUNT ASSY411W1602-5ASHADE ASSY65B05471-4PIVOT PIN65B93099-19HINGE FTG ASSY65B23287-1BUSHING ASSY332U2110-18CASE DRAIN332U2322-35MANIFOLD ASSY411U1234-5SHADE ASSY314U2106-7WEAR PAD
Back to Boeing 747-400D