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.
THA747429A-005TOP KIT COLLECTOREVW74252281-4SB KITEVW74252281-5SB KITBR045190-001LRSTUB WALLTGW740252753-2SB KIT FOR G8 GALLEYCHI04252706-8SB KIT FOR FC1THA747424A-003TOP COLLECTOR KITDAL1615M0-906TOP KIT COLLECTORCAL7474005-113TOP KIT COLLECTORTHA747429A-003TOP KIT COLLECTORTG0R4252810-1SB KIT FOR DC1EVW7411-1GALLEY ASSY G1AEVW74252281-3SB KITCIC7421-1C2 CLOSET ASSYCAL1278M0-901TOP KIT COLLECTORCAL1278M0-906TOP KIT COLLECTORTG0R4252810-3SB KIT FOR DC1JD-24AD00-004TOP KIT COLLECTOREVW7421-1DR 2 CENTER CLOSETCHI04252706-2SB KIT FOR CC2TG0R4252810-2SB KIT for DC2VGT4163000G03RH PARTITION, ZONE CTHA747424A-004TOP COLLECTOR KITDAL1615M0-913TOP KIT COLLECTORCI0R4-11LAVATORY ASSYEVW7401-1GALLEY COMPLETDAL1615M0-902TOP KIT COLLECTORTII04252748-2SB KIT FOR DC2 LAVATORYEVW7530-1STOWAGE ASSY LHCHI04252706-6SB KIT FOR DS1EVA7474002-001TOP KIT COLLECTORJD-24AD00-001TOP KIT COLLECTORTHA747429A-006TOP KIT COLLECTORVGT4162000G02RH PARTITION, ZONE ACAL1278M0-907TOP KIT COLLECTORCI0R4-02LAVATORY ASSYJD-24AD00-002TOP KIT COLLECTORCIC7451-1C2L CLOSET08A040700-502OVERDOOR FAIRING KITCAL1278M0-909TOP KIT COLLECTORCHI04252706-11SB KIT FOR FC4EVW74252776-1SB KITCAL1278M0-903TOP KIT COLLECTORCAL1278M0-902TOP KIT COLLECTORCAL7474005-112TOP KIT COLLECTORTG0R444-01ALAVATORY ASSYDAL1615M0-903TOP KIT COLLECTORDAL1615M0-916TOP KIT COLLECTORCHI04252706-3SB KIT FOR CC3EVA7474002-002TOP KIT COLLECTOR
Back to Boeing 747-400D