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.

S08271-001-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S3730AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S04037-033-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S14200-005-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S010622AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S016037AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S5093AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S013385AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S011853AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S015827AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S016157AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S011631AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S015586AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S5955AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S2298AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S013984AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S009318AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S013458AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S5635AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S14200-001-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S011767AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S08208-002-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S011730AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S009318AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S010270AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S013483AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S1239AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S8669AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S6566AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S2439AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S3690AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S2922AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S07400-001-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S2051AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S6249AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S2341AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S6157AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S5953AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S04128-024-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S7452AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S015539AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S012540AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S51934-001-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S7745AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S016075AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S1245AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S7426AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S2863AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S4401AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S1393AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013
Back to Boeing 747-400D