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.
BAC27EFS603MarkerBAC27EFS0491MarkerBAC27EFS597MarkerBAC29PPS36257MarkerBAC29PPS25751MarkerBAC27EFS598MarkerBAC27EHY0189MarkerBAC27EFS601MarkerBAC27EFS600MarkerBAC27EFS599MarkerBAC29PPS38934MarkerBAC29PPS45752Marker3179383-1KTBearing59403821901Amplifier Unit5980012100400Valve and Thermostat5980042100100Water Faucet and Sensor5980042100000IR Faucet887986-4JAClip, Retaining887986-2JAClip, RetainingAPM100931-9-188Button, Bolt887986-6JAClip, Retaining887986-5JAClip, RetainingBAC27EFS0529MarkerBAC27EFS0427MarkerBAC27EFS0477MarkerBAC27EFS0449MarkerBAC27EFS0543MarkerBAC27EFS0490MarkerBAC27EFS608MarkerBAC27EFS612MarkerBAC27EFS0488MarkerBAC27EFS0485MarkerBAC27EFS0480MarkerBAC27EFS0424MarkerBAC27EFS0434MarkerBAC27EFS0440MarkerBAC27EFS0451MarkerBAC27EFS0503MarkerBAC27EFS0532MarkerBAC27EFS0436MarkerBAC27EFS0421MarkerBAC27EFS0502MarkerBAC27EFS0481MarkerBAC27EFS609MarkerBAC27EFS0432MarkerBAC27EFS0448MarkerBAC27EFS0431MarkerBAC27EFS0442MarkerBAC27EFS0486MarkerBAC27EFS0423Marker
Back to Boeing 747-400D