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.

SQW9425-1LAV MKITJamco America Inc · PMA PQ0137NM · Replaces SQW9425-1 · Dec 10, 2018SQW9406-1CONSOLE ASSY-LOC.6Jamco America Inc · PMA PQ0137NM · Replaces SQW9406-1 · Dec 10, 2018ANA04252518-1SB KITJamco America Inc · PMA PQ0137NM · Replaces ANA04252518-1 · Dec 10, 2018SQW9428-1RACE WAY COVER-SIDE WALLJamco America Inc · PMA PQ0137NM · Replaces SQW9428-1 · Dec 10, 2018SQW9411-1CONSOLE ASSY-LOC.11Jamco America Inc · PMA PQ0137NM · Replaces SQW9411-1 · Dec 10, 2018SQW9408-21CONSOLE ASSY-LOC.8Jamco America Inc · PMA PQ0137NM · Replaces SQW9408-21 · Dec 10, 2018SQW9407-21CONSOLE ASSY-LOC.7Jamco America Inc · PMA PQ0137NM · Replaces SQW9407-21 · Dec 10, 2018SQW9408-11CONSOLE ASSY-LOC.8Jamco America Inc · PMA PQ0137NM · Replaces SQW9408-11 · Dec 10, 2018SQW9426-1FLOOR COVER BOXJamco America Inc · PMA PQ0137NM · Replaces SQW9426-1 · Dec 10, 2018SQW9430-5BIN STRIPJamco America Inc · PMA PQ0137NM · Replaces SQW9430-5 · Dec 10, 2018SQW9412-21CONSOLE ASSY-LOC.12Jamco America Inc · PMA PQ0137NM · Replaces SQW9412-21 · Dec 10, 2018SQW9409-1CONSOLE ASSY-LOC.9Jamco America Inc · PMA PQ0137NM · Replaces SQW9409-1 · Dec 10, 2018SQW9408-31CONSOLE ASSY-LOC.8Jamco America Inc · PMA PQ0137NM · Replaces SQW9408-31 · Dec 10, 2018SQW9430-7BIN STRIPJamco America Inc · PMA PQ0137NM · Replaces SQW9430-7 · Dec 10, 2018SQW9403-1CONSOLE ASSY-LOC.3Jamco America Inc · PMA PQ0137NM · Replaces SQW9403-1 · Dec 10, 2018JAG7474002-002TOP KIT COLLECTORJamco America Inc · PMA PQ0137NM · Replaces JAG7474002-002 · Dec 10, 2018SQW9410-21CONSOLE ASSY-LOC.10Jamco America Inc · PMA PQ0137NM · Replaces SQW9410-21 · Dec 10, 2018SQW9402-31CONSOLE ASSY-LOC.2Jamco America Inc · PMA PQ0137NM · Replaces SQW9402-31 · Dec 10, 2018SQW9421-1FWD CLSTJamco America Inc · PMA PQ0137NM · Replaces SQW9421-1 · Dec 10, 2018SQW9426-11FLOOR COVER BOXJamco America Inc · PMA PQ0137NM · Replaces SQW9426-11 · Dec 10, 2018SQW9412-1CONSOLE ASSY-LOC.12Jamco America Inc · PMA PQ0137NM · Replaces SQW9412-1 · Dec 10, 2018SQW9401-21CONSOLE ASSY-LOC.1Jamco America Inc · PMA PQ0137NM · Replaces SQW9401-21 · Dec 10, 2018SQW9407-1CONSOLE ASSY-LOC.7Jamco America Inc · PMA PQ0137NM · Replaces SQW9407-1 · Dec 10, 2018SQW9408-1CONSOLE ASSY-LOC.8Jamco America Inc · PMA PQ0137NM · Replaces SQW9408-1 · Dec 10, 2018SQW9410-11CONSOLE ASSY-LOC.10Jamco America Inc · PMA PQ0137NM · Replaces SQW9410-11 · Dec 10, 2018SQW9412-11CONSOLE ASSY-LOC.12Jamco America Inc · PMA PQ0137NM · Replaces SQW9412-11 · Dec 10, 2018SQW9407-11CONSOLE ASSY-LOC.7Jamco America Inc · PMA PQ0137NM · Replaces SQW9407-11 · Dec 10, 2018SQW9401-31CONSOLE ASSY-LOC.1Jamco America Inc · PMA PQ0137NM · Replaces SQW9401-31 · Dec 10, 2018SQW9411-11CONSOLE ASSY-LOC.11Jamco America Inc · PMA PQ0137NM · Replaces SQW9411-11 · Dec 10, 2018SQW9424-1INSTL FNL PARTS STOWAGE-02Jamco America Inc · PMA PQ0137NM · Replaces SQW9424-1 · Dec 10, 2018SQW9403-11CONSOLE ASSY-LOC.3Jamco America Inc · PMA PQ0137NM · Replaces SQW9403-11 · Dec 10, 2018SQW9403-21CONSOLE ASSY-LOC.3Jamco America Inc · PMA PQ0137NM · Replaces SQW9403-21 · Dec 10, 2018SQW9409-31CONSOLE ASSY-LOC.9Jamco America Inc · PMA PQ0137NM · Replaces SQW9409-31 · Dec 10, 2018SQW9401-11CONSOLE ASSY-LOC.1Jamco America Inc · PMA PQ0137NM · Replaces SQW9401-11 · Dec 10, 2018SQW9428-11RACE WAY COVER-SIDE WALLJamco America Inc · PMA PQ0137NM · Replaces SQW9428-11 · Dec 10, 2018SQW9430-3BIN STRIPJamco America Inc · PMA PQ0137NM · Replaces SQW9430-3 · Dec 10, 2018SQW9406-11CONSOLE ASSY-LOC.6Jamco America Inc · PMA PQ0137NM · Replaces SQW9406-11 · Dec 10, 2018SQW9404-11CONSOLE ASSY-LOC.4Jamco America Inc · PMA PQ0137NM · Replaces SQW9404-11 · Dec 10, 2018SQW9410-31CONSOLE ASSY-LOC.10Jamco America Inc · PMA PQ0137NM · Replaces SQW9410-31 · Dec 10, 2018SQW9404-1CONSOLE ASSY-LOC.4Jamco America Inc · PMA PQ0137NM · Replaces SQW9404-1 · Dec 10, 2018SQW9402-11CONSOLE ASSY-LOC.2Jamco America Inc · PMA PQ0137NM · Replaces SQW9402-11 · Dec 10, 2018SQW9402-1CONSOLE ASSY-LOC.2Jamco America Inc · PMA PQ0137NM · Replaces SQW9402-1 · Dec 10, 2018SQW9419-1CENTRAL DIVIDERJamco America Inc · PMA PQ0137NM · Replaces SQW9419-1 · Dec 10, 2018SQW9427-1ARTWORK FRAMEJamco America Inc · PMA PQ0137NM · Replaces SQW9427-1 · Dec 10, 2018SQW9406-21CONSOLE ASSY-LOC.6Jamco America Inc · PMA PQ0137NM · Replaces SQW9406-21 · Dec 10, 2018SQW9411-31CONSOLE ASSY-LOC.11Jamco America Inc · PMA PQ0137NM · Replaces SQW9411-31 · Dec 10, 2018SQC747404A-001TOP KIT COLLECTORJamco America Inc · PMA PQ0137NM · Replaces SQC747404A-001 · Dec 10, 2018SQW9403-31CONSOLE ASSY-LOC.3Jamco America Inc · PMA PQ0137NM · Replaces SQW9403-31 · Dec 10, 20188055515-4502PrinterAstroNova Inc. · PMA PQ4176NE · Replaces 8055515-4502 · Dec 2, 20188055515-4506PrinterAstroNova Inc. · PMA PQ4176NE · Replaces 8055515-4506 · Dec 2, 2018
Back to Boeing 747-400D