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.
40191-10Fitting Base40191-15Fitting Base40191-22Fitting Base40814-11Panel Fitting40361-21Stud Panel40000-11Anchor Plate40191-24Fitting Base580-773-015CABLE ASSEMBLY SEAT ADJUSTMENT170-098-001CABLE ASSY SEAT ADJUSTMENT (WEBER)170-093-004CABLE ASSY - SEAT ADJUSTMENTHT3935-7FR-*XXX-A *(WIDTH IN INCHES X 100 (EX. 150 = 1.5)HI-TAK TUFSEAL FLAME-RETARDANTHT3000FR-*XXX-A *(WIDTH IN INCHES X 100 (EX. 150 = 1.5)HI-TAK TUFSEAL FLAME-RETARDANT18-5613WESealRD-NB2504-01BROADBAND CONTROLLER, 3RD GENERATION NETWORKRD-NB2504-01BROADBAND CONTROLLER, 3RD GENERATION NETWORK103675-1MITStud131901-1MITSpring139255-1MITSpring130447-1MITWedge130469-1MITStudMHW740-630-1ZZINSTALLATION KIT - DOOR 1CAW7404-11ZZINSTALLATION KIT - DOOR 4MHB7404-1ZZINSTALLATION KIT - DOOR 4KEC742-31UNIT ASSY - 1BKLW740-DR4-21ZZINSTALLATION KIT - DOOR 4CAW7405-12GALLEY ASSY - G2DBA7404-1ZZINSTALLATION KIT - DOOR 4AIW7502-1STOWAGE UNIT - NO. 2AIW7410-1FWD BAR UNITAIW7474-1UPPER DECK GALLEYAIW7424-11GALLEY UNIT - NO. 6CIW7432-1GALLEY ASSY - G6CAW7408-12GALLEY ASSY - G4ESQW745-41UNIT ASSY - GALLEY G5KEC744-31UNIT ASSY - 2BMHW740530-1PANEL ASSY - CEILINGKLW753-11GALLEY ASSY - C/ASQW741-21UNIT ASSY - GALLEY G1TGW740-1694-11ZZINSTALLATION KIT - DOOR 4CAW7406-1GALLEY ASSY - G4AKEC740-530-31GALLEY COMPLEX - DOOR 1BAW740-530-21ZZDOOR 1 INSTALLATION KITKLW740-DR4-1ZZINSTALLATION KIT - DOOR 4CIW7411-1GALLEY ASSY - G1CAW7460-1GALLEY ASSY - NO. 4DAGW751-1UNIT ASSY - G4DKEC751-51UNIT ASSY - 4DJAG740-2261-1ZZINSTALLATION KIT - DOOR 5CAW7433-1GALLEY ASSY - NO. 4CCAW74D1-1ZZINSTALLATION KIT - DOOR 1
Back to Boeing 747-400D