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.
BAC27DPA5179MarkerBAC27ECA1607MarkerBAC27EHY-114MarkerBAC27TEX0972MarkerBAC27ECA969MarkerBAC27EPPS11462MarkerBAC27ECA967MarkerBAC27EPPS11460MarkerBAC27ELG-21MarkerBAC27ECA1607MarkerBAC27ECT1149MarkerBAC27ECA958MarkerBAC27EEL26140MarkerBAC27EEL26141MarkerBAC27EFS558MarkerBAC27EPPS7520MarkerBAC27ELG-21MarkerBAC27ECA1219MarkerBAC29PPS17898MarkerBAC27ECA1218MarkerBAC27TPP587MarkerBAC27DEX6075MarkerBAC27EPP669MarkerBAC27EPP667MarkerBAC27EAC759MarkerBAC27EPP671MarkerBAC27EPP666MarkerBAC27ECA1247MarkerBAC29PPS17896MarkerBAC29PPS17897MarkerBAC27EPP670Marker645133JP-2ImpellerBAC27EPP668MarkerBAC27EPP664MarkerBAC27EPP665MarkerBAC27WEL2056MarkerBAC27WEL2053MarkerBAC27WEL2055MarkerBAC27WEL2052MarkerBAC27WEL2054Marker580-294-003GAS SUPPLY TRIGGER CABLE ASSY580-567-001CABLE ASSEMBLY MANUAL HANDLE LOCK UPPER DECK ESCAPE SLIDE580-294-002GAS SUPPLY TRIGGER CABLE ASSY580-570-003CABLE ASSY AUTOMATIC ACTUATION580-561-004CABLE ASSEMBLY UPPER DECK ESCAPE SLIDE580-232-001CONTROL CABLE ASSEBLY - PULL MAIN ENTRY DOORS580-561-002CABLE ASSEMBLY UPPER DECK ESCAPE SLIDE580-561-001CABLE ASSEMBLY UPPER DECK ESCAPE SLIDE580-294-031CABLE ASSY GAS GEN TRIGGER DISARM580-294-051CABLE ASSY SAFETY LOCK
Back to Boeing 747-400D