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.
20-625972-003Instl. Kit, 10.4 INCH LCD BLKHD Monitor1167854-13Cable Assembly1167006-144Local Area Controller (LAC)704-3287-014Cable Assy, SVD-Disc, Double, Seatback601611-0000VSCU Mtg Plate1167893-53Cable Assembly1306248-002Cable Assembly, Crew rest, Disc/Sidewall980-9800-823SERIES 800 AUDIO REPRODUCER51-625653-801System CID Disk1167009-140Seat Electronic Unir1167001-141Cabin Test Module1168703Handset Adapter Connector40-620636-102UEB (2T) I with 8 MM Tape Player Power Supply1308935-003Cable Assy, AVU/Disc/RGB1167004-141Passenger Adrs Control617-6081-0658.6 inch LCD MONITOR INSTL601729-0003Instl. Kit, Roll Screen DWG. NO. 601729-00031156520-150SEB Terminator (ADB/TU-Video Ouput)980-9903-025Pre-Record. Announce Machine20-625926-001VCC Supplemental Cable Kit1167892-52Cable Assembly749-0600-001Harness Assy, SEU-JAU1/JAU3/ Disc, Triple704-3296-013Cable Assy, Feeder, PAT/Pwr910040-01-5095-1Airshow 210 Digital Interface Unit40-620540-103Projector, Single Lens1308935-002Cable Assy, AVU/Disc/RGB910040-01-5180-2Airshow 210 Digital Interface Unit1306350-003Cable Assy, Galley Disc/Bulkhead Phone704-3355-003Cable Assembly, SVD-Disc (RCPT)493420-0001Adapter, Projector1167974-218Cable Assembly60B40125-209Column Time Decoder1167016-140Cabin Interphone Set655-5148-006Stiffener1150020-101Chime Light Sensor Unit1167879-47Cable Assembly 1167879-471308284-004Cable Assy, AVU/Disc/ UPCU/Audio1307875-010Cable Assy, Disconnect/ RGB Video980-9800-831Programmed Announce Reproducer914088-1DIU Tray1167015-141Audio Control Panel1308007-10510.4 Video Monitor704-3295-009Cable Assy, Seat-Seat, 1394617-4752-004MK VI Video Projector921900-01-9999-7Airshow Delivery CD1300007-140IOEU1308007-106MONITOR, LCD, 10.4, SLATE GRAY700-1516-002SVDU TERMINATION PLUG0016J001612C62Cap Assembly749-0471-007Harness Assy, SEU-PCU, Double
Back to Boeing 747-400D