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.
ASASY0115-2FSKeypad Assembly, Lower1403-012Stretcher BridgeASASY0114-2FSKeypad Assembly, Upper300145Infusion Pump Mount2800-603Ambulance Module300370ProPaq Mount5500-002Ambulance Module300369Accuvac Rescue Mount2800-002Ambulance Module58163-7WERing-Piston364436-1WEGear SetSP3832-02-5047O-RingB43404-908HO-RingB43404-005HO- RingB43404-012HO-RingH4A3530Cylinder287U0029-10CLIP ASSY411U1233-1DUST COVER411U1251-1SHADE TRACK411U1236-1SPRING CLIP413U1741-5CCHASSIS ASSY411U1231-3REVEAL ASSY INNER417U6006-19CUP ASSY411W1602-4ASEAL-BULB411U5514AGRILLE ASSY411U1251-4SHADE TRACK413U1741-6CCHASSIS ASSYPT528AV08S045BBUSHING, FLANGED OVERSIZEPT528AV06A022ABUSHING, FLANGED O/SPT528BB14S054CP20BUSHING, FLANGEDPT528AV08A022ABUSHING, FLANGED O/SPT528AV06S013BBUSHING, FLANGED O/SPT528AY09A020AGBUSHING, FLANGEDPT528BB05S028CBUSHING, FLANGEDPT528AZ06S018CGBUSHING, FLANGEDPT528AY06A040AGBUSHING, FLANGEDPT528AV05S028CBUSHING, FLANGED O/SPT528AZ12A054AP30BUSHING, FLANGEDPT528AY08S020CBUSHING, FLANGEDPT528AY06S018CGBUSHING, FLANGEDPT528AV16S110CBUSHING, FLANGEDPT528AY28S084CBUSHINGPT528AV06S025CBUSHINGSP3810-09-1005ADrain RodSP3810-09-1010Knob, Drain RodSP3810-09-1010AKnob, Drain RodSP3810-09-1005BDrain RodSP3810-09-1015Bracket, MountingWF329910Filter Element, OilWF326035Filter Element, Oil
Back to Boeing 747-400D