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.

65B12790U29HINGE ASSYSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 65B12790U29 · Jul 22, 201565B12790U30HINGE ASSYSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 65B12790U30 · Jul 22, 201569B12645Y17FLAP DEFLECTORSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 69B12645Y17 · Jul 22, 201565B08351U8STOP FITTINGSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 65B08351U8 · Jul 22, 201565B12239U3CHORDSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 65B12239U3 · Jul 22, 201565B15256U80Splice FtgSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 65B15256U80 · Jul 22, 2015015U0579-74TOP KIT-FITTINGSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 015U0579-74 · Jul 22, 201569B13954Y7HINGE HALF ASSYSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 69B13954Y7 · Jul 22, 201565B11743U4FITTINGSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 65B11743U4 · Jul 22, 2015015U0579-77FittingSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 015U0579-77 · Jul 22, 201569B12645U18FLAP DEFLECTORSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 69B12645U18 · Jul 22, 201565B11744U3FITTINGSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 65B11744U3 · Jul 22, 201565B14056U1BEAMSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 65B14056U1 · Jul 21, 201565B15629Y6WEBSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 65B15629Y6 · Jul 21, 201565B08351Y7STOP FITTINGSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 65B08351Y7 · Jul 21, 201565B08175U18CHORDSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 65B08175U18 · Jul 21, 201569B13823Y3FITTING ASSYSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 69B13823Y3 · Jul 21, 201565B22858U5SUPPORTSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 65B22858U5 · Jul 21, 201565B11744U4FITTINGSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 65B11744U4 · Jul 21, 201569B10155Y5HINGE HALF ASSYSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 69B10155Y5 · Jul 21, 2015654U6624-197Support Fitting AssemblySpirit AeroSystems Inc · PMA PQ3944CE · Replaces 654U6624-197 · Jul 21, 201565B08208-612Stop PlateSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 65B08208-612 · Jul 21, 201569B13823Y4FITTING ASSYSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 69B13823Y4 · Jul 21, 201569B15392Y3RETAINERSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 69B15392Y3 · Jul 21, 201565B16631Y63CLIPSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 65B16631Y63 · Jul 21, 201569B10566Y9HINGE ASSYSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 69B10566Y9 · Jul 21, 2015251U1019Y1BRACKETSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 251U1019Y1 · Jul 21, 201565B08351Y8STOP FITTINGSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 65B08351Y8 · Jul 21, 201569B13650-600Retainer - Hinge PinSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 69B13650-600 · Jul 21, 201565B12091Y10FITTING ASSYSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 65B12091Y10 · Jul 21, 201565B15629Y5WEBSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 65B15629Y5 · Jul 21, 201565B83563Y17PAN ASSYSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 65B83563Y17 · Jul 21, 201569B15392Y2RETAINERSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 69B15392Y2 · Jul 21, 201569B15392Y1RETAINERSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 69B15392Y1 · Jul 21, 201565B16631Y64CLIPSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 65B16631Y64 · Jul 21, 201565B15085Y1104CHORD-LWR FAIRINGSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 65B15085Y1104 · Jul 21, 201569B15392Y4RETAINERSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 69B15392Y4 · Jul 21, 201565C25180-22Frame - LWR FWDSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 65C25180-22 · Jul 21, 201565B08130Y84HINGE ASSYSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 65B08130Y84 · Jul 21, 201569B11630Y5FITTING ASSYSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 69B11630Y5 · Jul 21, 201565B08175U17CHORDSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 65B08175U17 · Jul 21, 201565C25180-24Frame - LWR AFTSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 65C25180-24 · Jul 21, 201565B15265U28RUB STRIPSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 65B15265U28 · Jul 21, 201565B12091Y9FITTING ASSYSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 65B12091Y9 · Jul 21, 2015654U6624-227Splice FittingSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 654U6624-227 · Jul 21, 201569B15392Y5RETAINERSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 69B15392Y5 · Jul 21, 201565B39222Y12RETAINERSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 65B39222Y12 · Jul 21, 201565B15450-45Attach FittingSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 65B15450-45 · Jul 16, 201569B14547-7Striker PlateSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 69B14547-7 · Jul 16, 201565B22858-8SupportSpirit AeroSystems Inc · PMA PQ3944CE · Replaces 65B22858-8 · Jul 16, 2015
Back to Boeing 747-400D