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.

S010280AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S07056-005-P2AerTrim LWSchneller 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, 2013S50531-002-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S013378AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S012392AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S05078-015-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S08931-001-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S2828AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S5859AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S7170AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S50972-001-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S012240AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S04037-022-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S02658-001-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S011732AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S011022AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S1281AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S3561AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S6044AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S07478-001-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S8674AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S6669AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S015549AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S06063-001-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S1046AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S14236-001-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S04992-004-P2AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S08267-015-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S013492AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S013813AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S015974AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S04952-001-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S8169AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S51934-001-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S2672AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S009896AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S1685AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S8603AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S011191AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S013501AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S04907-001-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S1587AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S1155AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S8155AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013S012044AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S08267-017-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S04909-013-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S05078-014-P2AerFilm LHRSchneller LLC · PMA PQ2722CE-D · Replaces JAMCO Lavatory Panel Assemblies D… · Jul 15, 2013S5582AerTrim LWSchneller LLC · PMA PQ2722CE-D · Replaces Flight Structures Crewrest D corative… · Jul 15, 2013
Back to Boeing 747-400D