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.

161U1005-4SleeveAviation Materials Management, Inc · PMA PQ5273NM · Replaces 161U1005-4 · Feb 12, 201569B81791-1BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69B81791-1 · Feb 12, 2015112U4721-13Retainer, DuctAviation Materials Management, Inc · PMA PQ5273NM · Replaces 112U4721-13 · Feb 12, 2015161U0002-1Pin-Lower BearingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 161U0002-1 · Feb 12, 2015272T6124-3SleeveAviation Materials Management, Inc · PMA PQ5273NM · Replaces 272T6124-3 · Feb 12, 201569B80187-8Valve AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69B80187-8 · Feb 12, 201569B81791-3BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69B81791-3 · Feb 12, 201569B70231-6Box ConnectorAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69B70231-6 · Feb 12, 2015114U7401-2Link AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 114U7401-2 · Feb 12, 2015274N1051-3Valve AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 274N1051-3 · Feb 12, 2015119U0011-1Shoulder BoltAviation Materials Management, Inc · PMA PQ5273NM · Replaces 119U0011-1 · Feb 12, 2015161U1520-1BushingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 161U1520-1 · Feb 12, 2015114U7401-1Link AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 114U7401-1 · Feb 12, 2015162U1525-1Pin-Lower CamAviation Materials Management, Inc · PMA PQ5273NM · Replaces 162U1525-1 · Feb 12, 2015284T0279-4TargetAviation Materials Management, Inc · PMA PQ5273NM · Replaces 284T0279-4 · Feb 12, 2015251A2183-1GearAviation Materials Management, Inc · PMA PQ5273NM · Replaces 251A2183-1 · Feb 12, 2015140U4001-6Spring ClipAviation Materials Management, Inc · PMA PQ5273NM · Replaces 140U4001-6 · Feb 12, 2015161U0002-2Pin-Lower BearingAviation Materials Management, Inc · PMA PQ5273NM · Replaces 161U0002-2 · Feb 12, 2015163U6004-4Base Plate AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 163U6004-1 · Feb 12, 2015274T4625-2BodyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 274T4625-2 · Feb 12, 2015142U1006-1PinAviation Materials Management, Inc · PMA PQ5273NM · Replaces 142U1006-1 · Feb 12, 201566-13873-6Bearing PlateAviation Materials Management, Inc · PMA PQ5273NM · Replaces 66-13873-6 · Feb 12, 2015284T0278-3ShimAviation Materials Management, Inc · PMA PQ5273NM · Replaces 284T0278-3 · Feb 12, 2015252U3211-1Bolt AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 252U3211-1 · Feb 12, 2015162U1520-1BoltAviation Materials Management, Inc · PMA PQ5273NM · Replaces 162U1520-1 · Feb 12, 2015252U3211-2Bolt AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 252U3211-2 · Feb 12, 201565B01552-21ActuatorAviation Materials Management, Inc · PMA PQ5273NM · Replaces 65B01552-21 · Feb 12, 2015112U4721-2Fitting AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 112U4721-2 · Feb 12, 2015119U0011-1Shoulder BoltAviation Materials Management, Inc · PMA PQ5273NM · Replaces 119U0011-1 · Feb 12, 2015119U0013-2WasherAviation Materials Management, Inc · PMA PQ5273NM · Replaces 119U0013-2 · Feb 12, 2015112U4721-5Sleeve, ElipticalAviation Materials Management, Inc · PMA PQ5273NM · Replaces 112U4721-5 · Feb 12, 201566-18544-1Grounding TerminalAviation Materials Management, Inc · PMA PQ5273NM · Replaces 66-18544-1 · Feb 12, 201569B70231-3Nut-JamAviation Materials Management, Inc · PMA PQ5273NM · Replaces 69B70231-3 · Feb 12, 2015274T4621-4Valve AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 274T4621-4 · Feb 12, 201566-13873-11Bearing PlateAviation Materials Management, Inc · PMA PQ5273NM · Replaces 66-13873-11 · Feb 12, 2015140N2022-1Valve AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 140N2022-1 · Feb 12, 2015251N3258-1WasherAviation Materials Management, Inc · PMA PQ5273NM · Replaces 251N3258-1 · Feb 12, 2015274N1051-3Valve AssyAviation Materials Management, Inc · PMA PQ5273NM · Replaces 274N1051-3 · Feb 12, 2015119U0013-1WasherAviation Materials Management, Inc · PMA PQ5273NM · Replaces 119U0013-1 · Feb 12, 2015112U4721-7Retainer, SealAviation Materials Management, Inc · PMA PQ5273NM · Replaces 112U4721-7 · Feb 12, 2015162U1525-1Pin-Lower CamAviation Materials Management, Inc · PMA PQ5273NM · Replaces 162U1525-1 · Feb 12, 2015119U0013-4WasherAviation Materials Management, Inc · PMA PQ5273NM · Replaces 119U0013-4 · Feb 12, 2015161T1223-1WasherAviation Materials Management, Inc · PMA PQ5273NM · Replaces 161T1223-1 · Feb 12, 2015LA555022DiaphragmLanAir Research and Development Inc · PMA PQ1031NE · Replaces 555022 · Feb 11, 2015AC9117LLT-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GU85PPJ · Feb 10, 2015SS1904-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT20C · Feb 10, 2015AC9110LT-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GU50P · Feb 10, 2015SS1910-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT50C · Feb 10, 2015SS1913-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT65C · Feb 10, 2015AC1913-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10GT65 · Feb 10, 2015
Back to Boeing 747-400D