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.

S07067-001-P2AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S8025AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S04909-009-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S7725AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S4374AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S50537-002-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S4401AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S2681AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S3458AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S009284AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S013543AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S3884AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S04992-002-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S13228-005-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S6374AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S014024AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S7171AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S3600AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S009594AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S03935-003-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S8751AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S5559AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S011931AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S012381AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S4390AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S05060-001-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S7641AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S012994AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S009453AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S012116AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S7068AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S5641AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S6660AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S010389AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S50537-002-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S4215AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S3387AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S07000-001-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S2968AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S04927-016-P2AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S2439AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S2898AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S7557AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S011952AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S011341AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S3499AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S1188AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S012101AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S1869AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S8239AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013
Back to Boeing 747-400D