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.
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 DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
65B12790U29HINGE ASSY65B12790U30HINGE ASSY69B12645Y17FLAP DEFLECTOR65B08351U8STOP FITTING65B12239U3CHORD65B15256U80Splice Ftg015U0579-74TOP KIT-FITTING69B13954Y7HINGE HALF ASSY65B11743U4FITTING015U0579-77Fitting69B12645U18FLAP DEFLECTOR65B11744U3FITTING65B14056U1BEAM65B15629Y6WEB65B08351Y7STOP FITTING65B08175U18CHORD69B13823Y3FITTING ASSY65B22858U5SUPPORT65B11744U4FITTING69B10155Y5HINGE HALF ASSY654U6624-197Support Fitting Assembly65B08208-612Stop Plate69B13823Y4FITTING ASSY69B15392Y3RETAINER65B16631Y63CLIP69B10566Y9HINGE ASSY251U1019Y1BRACKET65B08351Y8STOP FITTING69B13650-600Retainer - Hinge Pin65B12091Y10FITTING ASSY65B15629Y5WEB65B83563Y17PAN ASSY69B15392Y2RETAINER69B15392Y1RETAINER65B16631Y64CLIP65B15085Y1104CHORD-LWR FAIRING69B15392Y4RETAINER65C25180-22Frame - LWR FWD65B08130Y84HINGE ASSY69B11630Y5FITTING ASSY65B08175U17CHORD65C25180-24Frame - LWR AFT65B15265U28RUB STRIP65B12091Y9FITTING ASSY654U6624-227Splice Fitting69B15392Y5RETAINER65B39222Y12RETAINER65B15450-45Attach Fitting69B14547-7Striker Plate65B22858-8Support
Back to Boeing 747-400D