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.
9550-09Panel-inner arm shroudME95659-3Panel Center Arm163U6004-4Base Plate AssyME80159-39Panel - Inner162U1525-1Pin-Lower CamMEI 98810-23HPanel-Handicap Lower Arm91672-39Panel-center arm Shroud284T0278-3Shim9281-4RPanel-upper arm251A2183-1Gear274T4621-4Valve AssyME95473-58Panel Center ArmME95474-53Panel Inner251U4500-2Tube Assy114U7401-2Link AssyME95479-3Escutcheon - Lower251N3258-1Washer274T4626-1Plug66-13873-8Bearing Plate112U4721-1Fitting Assy9676-01Panel-inner arm shroud112N4508-1WasherME97592-1Escutcheon - RearME95471-8Panel - Aisle119U0013-3WasherME94714-4Panel Assy Lower8388-28Panel-lower arm shroudME98152-1Tray Table Insert69B82321-3ForkCM56484Ball Bearing69494J13WEPacking, Preformed8730G1-1EFB-Interface UnitHA736-1KTLatch Assy, Push Button101031-5KTTrigger100931-9-188KTButton, Bolt100929-11KTGasket, Trigger109730-1KTSpacerHSP169-1-093-1250KTPin109693-3KTPin100932P-7-213KTButton, Trigger, Top101535-5KTButton, Trigger, Bottom109682-3KTBracket1133427-1KTBolt100786-5KTSpring, Trigger107690-11KTPin109692-1KTSpring, Bolt8247MBS-0349Marker- Defueling8247MBS-0357Marker- Fueling706300-112Printer1310125-100In System Loader
Back to Boeing 747-400D