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.
BAC1522-697Miscellaneous Shapes Plastic, ExtrudedBAC1522-180Miscellaneous, Plastic, ExtrudedBAC1522-739Miscellaneous, Plastic, ExtrudedBAC1522-339Miscellaneous, Plastic, ExtrudedBAC1522-753Miscellaneous, Plastic, ExtrudedBAC1522-601Miscellaneous Shape Plastic, ExtrudedBAC1522-960Miscellaneous, Plastic, ExtrudedBAC1522-706Miscellaneous, Plastic, ExtrudedBAC1522-745Miscellaneous, Plastic, ExtrudedBAC1522-296Section Plastic - ExtrudedBAC1522-1008Miscellaneous, Plastic, ExtrudedBAC1522-453Miscellaneous, Plastic, ExtrudedBAC1522-702Miscellaneous, Plastic, ExtrudedBAC1522-1003Miscellaneous, Plastic, ExtrudedBAC1522-689Miscellaneous Shape Plastic, ExtrudedBAC1522-654Miscellaneous, Plastic, ExtrudedBAC1522-547Vertical Rubstrip InsertBAC1522-41Section Plastic - ExtrudedBAC1522-700Miscellaneous, Plastic, ExtrudedBAC1522-687Miscellaneous Shape Plastic, ExtrudedBAC1522-395Miscellaneous SectionBAC1522-738Miscellaneous, Plastic, ExtrudedBAC1522-467Miscellaneous, Plastic, Extruded65B15085U1091Chord-Lwk Fairing65B08214-25Anchor Plate Assy65B16631U64Clip65B08215-1Sleeve - Telescopic65B15265-27Rub Strip65B14063U3Channel69B12101-5Hinge Flaos69B14751-1Hinge , Half-up66-13873-6Bearing Plate69B11673U1CLIP69B11198Y6Tie Fitting Assy69B11630Y6Fitting Assy65B10056-1Sprocket Shaft65B83563U22PAN ASSY69B11630U6Fitting Assy69B11519-21Fitting65B10056-2Sprocket Shaft69B12100-3Fitting65B15629Y29Web69B11630-6Fitting Assy69B11994Y1Fitting Assy65B83563Y22Pan Assy65B15247U5Splice Ftg , LH69B11673Y1Clip65B11751-12Reveal144U8300Y2Threshold65B14063Y2Channel
Back to Boeing 747-400D