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.
731476JAGasket5909950KTBearing, Ball350000-00-010000Aerocom 3000, Cabin Telephone UnitAerFusion fit PDT-0544Non-Textile Flooring400-0181-001WEBALL BEARINGCHI04252706-7SB KIT FOR DS2DAL1615M0-912TOP KIT COLLECTORCI0R4-12LAVATORY ASSYCAL7474005-111TOP KIT COLLECTOR08A040700-501OVERDOOR FAIRING KITBR045-13001LRMODULE ASSYCHI04252706-9SB KIT FOR FC2TGW740252753-1SB KIT FOR G7 GALLEYVGT4163000G01LH PARTITION, ZONE CDAL1615M0-904TOP KIT COLLECTOREVW7422-1VCC & CLOSETEVW74252281-2SB KITDAL1615M0-915TOP KIT COLLECTORTGW740252829-1SB KIT FOR G7 GALLEYDAL1615M0-911TOP KIT COLLECTORTHA747429A-001TOP KIT COLLECTOREVW7412-1GALLEY ASSY G1BTHA747424A-001TOP COLLECTOR KITCAL1278M0-904TOP KIT COLLECTORDAL1615M0-905TOP KIT COLLECTORDAL1615M0-914TOP KIT COLLECTORCAL1278M0-908TOP KIT COLLECTORCAL1278M0-905TOP KIT COLLECTORBR045-13011LRMODULE ASSYTII04252748-1SB KIT FOR DC1 LAVATORYVGT4162000G01LH PARTITION, ZONE ATG0R444-02ALAVATORY ASSYDAL1615M0-908TOP KIT COLLECTORDAL1615M0-910TOP KIT COLLECTORTHA747429A-002TOP KIT COLLECTORCI0R4-01LAVATORY ASSYCIW7401-11GALLEY COMPLEX - DOOR 1EVW7531-1STOWAGE ASSY RHCAL7474005-110TOP KIT COLLECTORTHA747429A-004TOP KIT COLLECTORVGT4161000G01NOSE CLOSEOUTEVW7410-1GALLEY ASSY BAR UNITDAL1615M0-909TOP KIT COLLECTORTG0R4252810-4SB KIT FOR DC 2CHI04252706-1SB KIT FOR CC1THA747424A-002TOP COLLECTOR KITDAW747408A-001TOP KIT COLLECTORCHI04252706-4SB KIT FOR CC4CHI04252706-10SB KIT FOR FC3DAL1615M0-901TOP KIT COLLECTOR
Back to Boeing 747-400D