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.
8050917-0003WEPaper, Roll8050917-0006WEPaper, RollR6HP10ZAWERoll, PaperST3030-09WENut Option (IC), SLFLKG, DBL Hex100138-26WESwitchR44-1403 Item 5.2 - Manufacturing Data Item 6.1 - Line Replacement Unit (LRU)LHT CWAP Exchange107STC-231EVAS(r)107STC-232EVAS(r)0203173-001JALens-Clear350000-00-010000Cabin Telecommunications Unit (CTU-3000)SP3810-09-1A130Body Assy, FaucetSP3810-09-1A130Body Assy, Faucet751-1004-001Hoffman Performance Lighting Paradigm(tm) PAR64 LED Landing Light751-1003-001Hoffman Performance Lighting Paradigm(tm) PAR64 LED Landing LightAble-0512-42Washer69AA83376-1Lockwasher - CupAble-0512-20WasherAble-0539-100FFiller69AA10024-1PinAble-0512-16Washer69AA83376-1Lockwasher - Cup126175-01AAHinge Assembly-Endbay69AA10024-1PinAble-0532-4Pin-SupportAble-0512-11Washer69AA15056-1WasherAble-0532-4Pin-SupportAble-0533-3Pin-SupportAble-0512-3Washer302AA0200-130Bushing- Inner65AA08104-217Bushing- FlangedAble-0512-21Washer69AA15056-1WasherAble-0539-100FFillerAble-0512-31Washer302AA0200-132Bushing- InnerB101001-503Coffee MakerB101001-503Coffee MakerB101001-503Coffee MakerB101001-503Coffee MakerB101001-503Coffee MakerB101001-503Coffee MakerB101001-503Coffee Maker7090-250300KTPin-Hinge7090-253200KTInsertSP3810-09-1050Knob, Faucet, Machined815-8762-001CNS Core Software (CMU-900)BAC1522-1156MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1141MISCELLANEOUS, PLASTIC, EXTRUDEDBAC1522-1204MISCELLANEOUS, PLASTIC, EXTRUDED
Back to Boeing 747-400D