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.

S4270AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S009541AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S03379-004-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S08231-001-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S8800AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S010512AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S2250AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S04037-019-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S4270AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S8922AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S3114AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S011302AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S7164AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S2894AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S8717AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S4848AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S009429AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S011182AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S7798AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S010094AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S7085AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S8971AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S03935-001-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S8316AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S014539AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S7852AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S09203-001-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S1782AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S04900-008-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S07293-006-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S015877AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S013082AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S009532AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S010079AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S5560AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S07077-001-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S4901AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S51045-001-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S012688AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S06465-005-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S3580AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S05446-001-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S2147AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S05434-002-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S03090-002-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S009549AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S009454AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S3386AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S04037-033-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S2618AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013
Back to Boeing 747-400D