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.
65B14054-2Fitting69B12011-1Spring - Flat65B54152-5Bracket Assembly65B13507-5Former65B11365-3Zee65B12246-227Stiffener65B11654-9Lens Assembly69B11925-10Pad69B11997-6Tie Rod Assembly65B11791-6Skin65B15000-24Seal65B15000-25Seal69B14781-2Bolt Shoulder65B83563-21Pan Assembly65B12239-4Chord65B10925-115Angle65B10920-189Seal65B10882-91Access Door Assy. - Left Wing (Refueling Nozzles)65B12586-5Bracket65B15454-15Stiffener65B13224-3Close out Web65B13935-7Rib Assembly65B39222-12Retainer65B11655-3Lens65B15085-238Channel, Seal, Support69B12260-1Tie Rod Assembly65B15256-611Shim65B14963-38Panel Assembly - Upper, INBD Nacelle, Wing Leading Edge65B14058-1Beam65B10920-164Seal69B13198-1Pivot Plate Assembly66-17207-5Retainer Strap69B11704-7Rod Assembly69B11643-6Tension Tie Tube65B11513-42Seal65B15629-6Web65B15000-23Seal65B12727-9Stiffener Channel251U1019-1Bracket66-17207-6Retainer Strap65B15696-126Stiffener015U0817-601Bracket69B15700-2Fitting65B14063-6Channel65B11752-9Reveal Assembly69B13974-2Bracket65B15000-30Seal65B11655-9Lens65B15085-1104Chord - LWR Fairing65B15629-29Web
Back to Boeing 747-400D