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.
BAC29PPS11055MarkerBAC29PPS11023MarkerBAC1522-201Channel ExtrusionBAC29PPS10937MarkerBAC29PPS11014MarkerBAC29PPS11009MarkerBAC29PPS11061MarkerBAC29PPS11004MarkerBAC29PPS11034MarkerBAC29PPS10956MarkerBAC29PPS11031MarkerBAC29PPS11005MarkerBAC1521-707-1Seal ExtrusionBAC1522-594Lens ExtrusionBAC29PPS11041MarkerBAC29PPS11021MarkerBAC1521-780Seal ExtrusionBAC29PPS11040MarkerBAC29PPS11010MarkerBAC29PPS11043MarkerBAC29PPS11016MarkerBAC29PPS11062MarkerBAC1521-750Seal ExtrusionBAC1521-740Seal ExtrusionBAC1521-734Seal ExtrusionBAC29PPS11006MarkerBAC29PPS11019MarkerBAC29PPS11000MarkerBAC27TTR0042MarkerBAC27TCH586MarkerBAC27TTR79MarkerBAC29PPS36205MarkerBAC27TCH622MarkerBAC29PPS24534MarkerBAC29PPS24531MarkerBAC29PPS24532MarkerBAC27WPPS215MarkerBAC27TFDE0276MarkerBAC29PPS56572MarkerBAC29PPS15941MarkerBAC29PPS15994MarkerBAC27TFDE0279MarkerBAC27TFDE0309MarkerBAC29PPS15993MarkerBAC29PPS15999MarkerBAC27TFDE0300MarkerBAC29PPS15952MarkerBAC29PPS15995MarkerBAC27TFDE0278MarkerBAC29PPS15998Marker
Back to Boeing 747-400D