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.
1307210-001Cable Assembly, FJB/Disc749-0472-006Harness Assy, SEU-PCU, Triple, Seatback1167890-103Cable Assembly615020Connector704-3293-009Cable Assembly, Seat-Seat1307181-001Installation Kit, VCC704-3295-010Cable Assy, Seat-Seat, 1394921000DIU0016-0028-1Cap Assembly Water Fill1167860-24Cable AssemblyS220U004-411Seat Electronic Unit (SEU)749-0478-004Harness Assy, SEU-PCU, Triple, W/SW Prov914088-1Mounting Tray617-6486-0068.8 inch SVD/ Shroud Assy1167857-17Cable Assembly1167890-107Cable Assembly1301343-063Cable Assy, AVU/UPCU/ Audio Jack, Trpl700-1500-004SVDU1140-0160-120Fuel Stick Assembly704-3352-008Cable Assy, ZBU-Disc. PAT1309198-006Cable Assy, Video Arm1167861-26Cable Assembly600-5294-027Pallet607295-0001Head End Modulator1140-0160-118Fuel Stick AssemblySystem Drawing List 1309056-004Enhanced Total Entertainment System749-0472-005Harness Assy, SEU-PCU, Triple, Seatback60B40125-219Column Time Decoder700-3087-001CABLE ASSY704-3288-008Cable Assy, SVD-Disc, Triple, Seatback1150030-100Pilot Control Unit 1150030-100Per Index List 1304631Enhanced Total Entertainment System, Parts as listed per Index List 062-0131-000, Video Entertainment System617-6433-001Stationary Screen Installation1140-0160-116Fuel Stick Assembly1140-0160-113Fuel Stick Assembly704-3315-012Cable Assy, SEU-SVD Disc (RCPT), Double, Seat4663-8Nipple Check Valve1307187-001Cable Assembly, SWD/AVU704-3372-007Cable Assy, ZBU-Disc., 1394700-2200-001SVDU1167867-236Cable Assembly1167890-112Cable Assembly1140-0160-117Fuel Stick Assembly980-9903-006PRAM1150200-100-50Galley, Pilot and Attendants Handsets749-0471-006Harness Assy, SEU-PCU, Double704-3293-009Cable Assy, Seat-Seat1307565-001Provision Kit, Remote Pat G4B1309027-001Cable Assy, Video/ Seatback/ Disc, Trpl
Back to Boeing 747-400D