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.

S50689-001-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S05421-002-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S3491AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S012947AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S4390AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S08013-001-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S011780AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S05434-001-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S1572AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S1191AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S6270AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S010863AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S51431-015-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S3561AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S6345AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S013711AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S012123AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S016223AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S011177AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S5229AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S08289-001-p2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S5191AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S009276AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S7360AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S2508AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S3690AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S7661AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S5805AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S010618AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S1191AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S03992-002-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S09233-002-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S012117AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S016297AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 201384887AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S7198AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S009623AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S012158AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S011894AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S4020AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S8134AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S6317AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S00000-053-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S51014-002-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S5641AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S3731AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S1885AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S5873AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S5531AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S2508AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013
Back to Boeing 747-400D