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.
417U3026-2068Shell417U5051-74Bezel417U3025-7331BReading Light -Outboard417U3081-5417Oxy Box Assy417U3081-3303Oxy Box Assy417U3081-5411Oxy Box Assy417U3072-2Rubber Boot Assy417U3060-2421Oxy Box Assy417U3065-3442Oxy Box Assy417U3025-2181Reading Light Assy417U3081-3231Oxy Box Assy418W1052-2Latch Spring417U3063-7008Stiffening Doubler417U3081-2053Oxy Box Door Assy417U3060-7361BOXYGEN BOX ASSY - 6-MASK M/D WITH IN-LINE, THERAPEUTIC417U3065-4831Oxy Box Assy417U3081-9Tape417U3062-3007Door Assy417U3060-13624Oxy Box Assy417U3030-2004Sign Pnl Assy417U3021-1061Shell417U3065-14331Oxy Box Assy65C33161-1Gasket417U3060-5622Oxy Box Assy417U3030-2002Sign Pnl Assy417U3065-7332BOXYGEN BOX ASSY - 3-MASK U/D W/IN-LINE, THERAPEUTIC417U5051-3Bezel417U3055-103Closure Pnl Assy418W1057-11AGap Seal417U3060-14620Oxy Box Assy417U3065-14634Oxy Box Assy417U3025-2144Panel Assy417U3060-12421Oxy Box Assy417U3060-8161BOXYGEN BOX ASSY - 6 MASK, M/D417U3063-16Hinge417U3030-7211BINFO SIGN LAV-OCCUPIED ASSY, CENTER, DUAL SIDED417U5051-98Bezel417U3081-4321Oxy Box Assy417U3065-2441Oxy Box Assy417U3062-8Sign Assy417U3065-6434Oxy Box Assy417U3060-3421Oxy Box Assy417U3025-3381Reading Light Assy417U3050-2100Closure Pnl Assy417U3031-2031Shell417U3025-7232BReading Light -Outboard417U3060-2Velcro Tape417U3060-8151BOXYGEN BOX ASSY - 5 MASK, M/D417U3081-7121BOXYGEN BOX ASSY - ATTENDANT417U3060-3424Oxy Box Assy
Back to Boeing 747-400D