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.
ELA044-15051EQMODULE ASSY -C/L LAVELA042-10031EQMODULE ASSY- AFT LAVELA044-10031EQMODULE ASSY -C/L LAVELA043-10031EQMODULE ASSY- AFT LAVELA043-10021EQMODULE ASSY- AFT LAVELA044-15071ERMODULE ASSY -C/L LAVELA045-13011EQMODULE ASSY -S/W LAVELA044-10041ESMODULE ASSY -C/L LAVELA044-10051ESMODULE ASSY -C/L LAVELA049-10011EQMODULE ASSY -U/D LAV.ELA044-15041EQMODULE ASSY -C/L LAVELA044-15061ERMODULE ASSY -C/L LAVELA048-10011EQMODULE ASSY -U/D LAV.90FS030-D01Master Drawing ListGP1BT011Back-Up Ring743S0055-1Name Plate743S0020Piston743GPS-9Aspirator743GPS-8Aspirator743S0027Set Screw743S0013-2Duct Tube743S0023Spacer743S0074Spring Washer743S0013-1Duct Tube743S0061Molded Flapper Assy.743S0055-3Name PlateGP17B011O-RingGP1BT012Back-Up Ring743S0022Inlet Fitting743S0072Inlet Seal743S0056-1Nozzle Tube Assy.743S0024Inlet Fitting Screw743S0045Flapper Washer743S0040Spring743S0066Body743S0026Brace Screw743S0054Drive PinGP17B038Inlet Seal O-Ring743S0021Cylinder8195-35Hydraulic Press. Snubber65B05319-1Valve Assembly87290-1Valve, Shut Off71205Valve Assembly- Press68640-2Valve, Press. OP. Check67530-2Valve, Check, Press. OP.70507-2Valve Assembly45080-1Valve Assembly-Solenoid Hydr70599Pressure Operated Brake37540-1Solenoid -Cargo Door71404-1Val Assy, Brake Metering
Back to Boeing 747-400D