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.

SQW746-41UNIT ASSY - GALLEY G6Jamco America Inc · PMA PQ0137NM · Replaces SQW746-41 · Aug 22, 2019CAW7431-1GALLEY ASSY - NO. 4AJamco America Inc · PMA PQ0137NM · Replaces CAW7431-1 · Aug 22, 2019SQW740-530-41ZZINSTALLATION KIT - DOOR 1Jamco America Inc · PMA PQ0137NM · Replaces SQW740-530-41ZZ · Aug 22, 2019CAW7403-1GALLEY ASSY - G1CJamco America Inc · PMA PQ0137NM · Replaces CAW7403-1 · Aug 22, 2019KLW749-1GALLEY ASSY - G9Jamco America Inc · PMA PQ0137NM · Replaces KLW749-1 · Aug 22, 2019KLW749-11GALLEY ASSY - G9Jamco America Inc · PMA PQ0137NM · Replaces KLW749-11 · Aug 22, 2019MHU744-11GALLEY ASSY - G4Jamco America Inc · PMA PQ0137NM · Replaces MHU744-11 · Aug 22, 2019AIW7423-1GALLEY UNIT - NO. 5Jamco America Inc · PMA PQ0137NM · Replaces AIW7423-1 · Aug 22, 2019SQW742-21/-31UNIT ASSY - GALLEY G2Jamco America Inc · PMA PQ0137NM · Replaces SQW742-21/-31 · Aug 22, 2019MHW745-1GALLEY ASSY - G5Jamco America Inc · PMA PQ0137NM · Replaces MHW745-1 · Aug 22, 2019SQW738-1UNIT ASSY - G3BJamco America Inc · PMA PQ0137NM · Replaces SQW738-1 · Aug 22, 2019KEC746-31UNIT ASSY - 4AJamco America Inc · PMA PQ0137NM · Replaces KEC746-31 · Aug 22, 2019CIW7434-1GALLEY ASSY - G8Jamco America Inc · PMA PQ0137NM · Replaces CIW7434-1 · Aug 22, 2019KEC739-2UNIT ASSY - BARJamco America Inc · PMA PQ0137NM · Replaces KEC739-2 · Aug 22, 2019CAW739-21UNIT ASSY ZONE A BARJamco America Inc · PMA PQ0137NM · Replaces CAW739-21 · Aug 22, 2019KEC745-31UNIT ASSY - 2CJamco America Inc · PMA PQ0137NM · Replaces KEC745-31 · Aug 22, 2019AGW748-11UNIT ASSY - G4CJamco America Inc · PMA PQ0137NM · Replaces AGW748-11 · Aug 22, 2019AIW7504-1UNDERSTAIR UNITJamco America Inc · PMA PQ0137NM · Replaces AIW7504-1 · Aug 22, 2019KEC740-1694-71GALLEY COMPLEX - DOOR 4Jamco America Inc · PMA PQ0137NM · Replaces KEC740-1694-71 · Aug 22, 2019SQW756-11COAT CLOSET - 1AJamco America Inc · PMA PQ0137NM · Replaces SQW756-11 · Aug 22, 2019SQW740-530-1ZZINSTALLATION KIT - DOOR 1Jamco America Inc · PMA PQ0137NM · Replaces SQW740-530-1ZZ · Aug 22, 2019SQW758-11UNIT ASSY - GALLEY G3AJamco America Inc · PMA PQ0137NM · Replaces SQW758-11 · Aug 22, 2019KEC741-31UNIT ASSY - 1AJamco America Inc · PMA PQ0137NM · Replaces KEC741-31 · Aug 22, 2019SQW749-31UNIT ASSY - UPPER DECKJamco America Inc · PMA PQ0137NM · Replaces SQW749-31 · Aug 22, 2019CAW746-11UNIT ASSY GALLEY - G4AJamco America Inc · PMA PQ0137NM · Replaces CAW746-11 · Aug 22, 2019JAG740-830-1ZZINSTALLATION KIT - DOOR 2Jamco America Inc · PMA PQ0137NM · Replaces JAG740-830-1ZZ · Aug 22, 2019CIW7402-1ZZINSTALLATION KIT - DOOR 2Jamco America Inc · PMA PQ0137NM · Replaces CIW7402-1ZZ · Aug 22, 2019CAW7401-11ZZINSTALLATION KIT - DOOR 1Jamco America Inc · PMA PQ0137NM · Replaces CAW7401-11ZZ · Aug 22, 2019CAW7459-1GALLEY ASSY - NO. 4EJamco America Inc · PMA PQ0137NM · Replaces CAW7459-1 · Aug 22, 2019MHW742-11GALLEY ASSY - G6Jamco America Inc · PMA PQ0137NM · Replaces MHW742-11 · Aug 22, 2019MHW751-1GALLEY ASSY - G1RJamco America Inc · PMA PQ0137NM · Replaces MHW751-1 · Aug 22, 2019AIW7423-11GALLEY UNIT - NO. 5Jamco America Inc · PMA PQ0137NM · Replaces AIW7423-11 · Aug 22, 2019TGU740520-11PANEL ASSY - CEILINGJamco America Inc · PMA PQ0137NM · Replaces TGU740520-11 · Aug 22, 2019MHW740510-1PANEL ASSY - CEILINGJamco America Inc · PMA PQ0137NM · Replaces MHW740510-1 · Aug 22, 2019MHU749-21GALLEY ASSY - UPPER DECKJamco America Inc · PMA PQ0137NM · Replaces MHU749-21 · Aug 22, 2019KLW752-11STOWAGE ASSY - LOW BOYJamco America Inc · PMA PQ0137NM · Replaces KLW752-11 · Aug 22, 2019AGW740-1694-11ZZINSTALLATION KIT - DOOR 4Jamco America Inc · PMA PQ0137NM · Replaces AGW740-1694-11ZZ · Aug 22, 2019AIW7401-1ZZINSTALLATION KIT - DOOR 1Jamco America Inc · PMA PQ0137NM · Replaces AIW7401-1ZZ · Aug 22, 2019CAW7474-1GALLEY ASSY - UPPER DECKJamco America Inc · PMA PQ0137NM · Replaces CAW7474-1 · Aug 22, 2019SQW749-21UNIT ASSY - UPPER DECKJamco America Inc · PMA PQ0137NM · Replaces SQW749-21 · Aug 22, 2019MHB7401-1ZZINSTALLATION KIT - DOOR 1Jamco America Inc · PMA PQ0137NM · Replaces MHB7401-1ZZ · Aug 22, 2019MHW741-21GALLEY ASSY - G1Jamco America Inc · PMA PQ0137NM · Replaces MHW741-21 · Aug 22, 2019CAW7402-1GALLEY ASSY - G1BJamco America Inc · PMA PQ0137NM · Replaces CAW7402-1 · Aug 22, 2019CAW739-11UNIT ASSY - BAR STOWAGEJamco America Inc · PMA PQ0137NM · Replaces CAW739-11 · Aug 22, 2019KLW740-DR4-31ZZINSTALLATION KIT - DOOR 4Jamco America Inc · PMA PQ0137NM · Replaces KLW740-DR4-31ZZ · Aug 22, 2019MHW741-11GALLEY ASSY - G1Jamco America Inc · PMA PQ0137NM · Replaces MHW741-11 · Aug 22, 2019SQW740-1694-21ZZINSTALLATION KIT - DOOR 4Jamco America Inc · PMA PQ0137NM · Replaces SQW740-1694-21ZZ · Aug 22, 2019AGW741-1UNIT ASSY - G1AJamco America Inc · PMA PQ0137NM · Replaces AGW741-1 · Aug 22, 2019KEW748-21UNIT ASSY - 4CJamco America Inc · PMA PQ0137NM · Replaces KEW748-21 · Aug 22, 2019CAW7401-1GALLEY ASSY - G1AJamco America Inc · PMA PQ0137NM · Replaces CAW7401-1 · Aug 22, 2019
Back to Boeing 747-400D