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.
2235300-01Enhanced Airborne Data Loader (eADL)2243800-81Wireless Ground Link - Quick Access Recorder (WQAR)2243800-63Wireless Ground Link - Quick Access Recorder (WQAR)2235300-01-1Enhanced Airborne Data Loader (eADL)2234552-001Installation kit2243800-71Wireless Ground Link - Quick Access Recorder (WQAR)2230666-01-CAirborne Data Loader (ADL)2243800-62Wireless Ground Link - Quick Access Recorder (WQAR)AACREP4M64BEARING, BALL, ROD END, MALE THREAD, KNURLED SHANK AND SOLID SHANK, BMS3-11 FLUID RESISTANT, CORROSION RESISTANTAACREP4S102BEARING, BALL, ROD END, MALE THREAD, KNURLED SHANK AND SOLID SHANK, BMS3-11 FLUID RESISTANT, CORROSION RESISTANTFB28AV04A018ZBUSHING, OVERSIZE FLANGE, LINED (FOR UNCLAMPED INSTALLATION)FB28AV09A050ZBUSHING, OVERSIZE FLANGE, LINED (FOR UNCLAMPED INSTALLATION)FB28AV08A019ZBUSHING, OVERSIZE FLANGE, LINED (FOR UNCLAMPED INSTALLATION)FB28AV05A022ZBUSHING, OVERSIZE FLANGE, LINED (FOR UNCLAMPED INSTALLATION)FB28AV04A022ZBUSHING, OVERSIZE FLANGE, LINED (FOR UNCLAMPED INSTALLATION)FB28AV04A023ZBUSHING, OVERSIZE FLANGE, LINED (FOR UNCLAMPED INSTALLATION)FB28AV06A013BBUSHING, OVERSIZE FLANGE, LINED (FOR UNCLAMPED INSTALLATION)AACREP4ML64BEARING, BALL, ROD END, MALE THREAD, KNURLED SHANK AND SOLID SHANK, BMS3-11 FLUID RESISTANT, CORROSION RESISTANTFB28AV04A026BBUSHING, OVERSIZE FLANGE, LINED (FOR UNCLAMPED INSTALLATION)AACREP4MS65BEARING, BALL, ROD END, MALE THREAD, KNURLED SHANK AND SOLID SHANK, BMS3-11 FLUID RESISTANT, CORROSION RESISTANTFB28AV06A015BBUSHING, OVERSIZE FLANGE, LINED (FOR UNCLAMPED INSTALLATION)FB28AV06A031CBUSHING, OVERSIZE FLANGE, LINED (FOR UNCLAMPED INSTALLATION)FB28AV06A019ZBUSHING, OVERSIZE FLANGE, LINED (FOR UNCLAMPED INSTALLATION)FB28AV12A055BBUSHING, OVERSIZE FLANGE, LINED (FOR UNCLAMPED INSTALLATION)FB28AV18A045ZBUSHING, OVERSIZE FLANGE, LINED (FOR UNCLAMPED INSTALLATION)FB28AV04A013ZBUSHING, OVERSIZE FLANGE, LINED (FOR UNCLAMPED INSTALLATION)AACREP4M6BEARING, BALL, ROD END, MALE THREAD, KNURLED SHANK AND SOLID SHANK, BMS3-11 FLUID RESISTANT, CORROSION RESISTANTFB28AV04A029ZBUSHING, OVERSIZE FLANGE, LINED (FOR UNCLAMPED INSTALLATION)FB28AV06B024ABUSHING, OVERSIZE FLANGE, LINED (FOR UNCLAMPED INSTALLATION)FB28AV12A049ZBUSHING, OVERSIZE FLANGE, LINED (FOR UNCLAMPED INSTALLATION)FB28AV08A056CBUSHING, OVERSIZE FLANGE, LINED (FOR UNCLAMPED INSTALLATION)FB28AV08A033CBUSHING, OVERSIZE FLANGE, LINED (FOR UNCLAMPED INSTALLATION)AACREP3ML62NBEARING, BALL, ROD END, MALE THREAD, KNURLED SHANK AND SOLID SHANK, BMS3-11 FLUID RESISTANT, CORROSION RESISTANTFB28AV04A015ZBUSHING, OVERSIZE FLANGE, LINED (FOR UNCLAMPED INSTALLATION)FB28AV05A024ZBUSHING, OVERSIZE FLANGE, LINED (FOR UNCLAMPED INSTALLATION)FB28AV12A042BBUSHING, OVERSIZE FLANGE, LINED (FOR UNCLAMPED INSTALLATION)AACREP5M62BEARING, BALL, ROD END, MALE THREAD, KNURLED SHANK AND SOLID SHANK, BMS3-11 FLUID RESISTANT, CORROSION RESISTANTFB28AV04A017ZBUSHING, OVERSIZE FLANGE, LINED (FOR UNCLAMPED INSTALLATION)FB28AV06A032ZBUSHING, OVERSIZE FLANGE, LINED (FOR UNCLAMPED INSTALLATION)FB28AV05A027ZBUSHING, OVERSIZE FLANGE, LINED (FOR UNCLAMPED INSTALLATION)FB28AV06A031ZBUSHING, OVERSIZE FLANGE, LINED (FOR UNCLAMPED INSTALLATION)FB28AV08B025ABUSHING, OVERSIZE FLANGE, LINED (FOR UNCLAMPED INSTALLATION)AAREP4S102BEARING, BALL, ROD END, MALE THREAD, KNURLED SHANK AND SOLID SHANK, BMS3-11 FLUID RESISTANT, CORROSION RESISTANTFB28AV08A014ZBUSHING, OVERSIZE FLANGE, LINED (FOR UNCLAMPED INSTALLATION)AACREP4ML6BEARING, BALL, ROD END, MALE THREAD, KNURLED SHANK AND SOLID SHANK, BMS3-11 FLUID RESISTANT, CORROSION RESISTANTFB28AV10A040CGBUSHING, OVERSIZE FLANGE, LINED (FOR UNCLAMPED INSTALLATION)FB28AV08A018ZBUSHING, OVERSIZE FLANGE, LINED (FOR UNCLAMPED INSTALLATION)AACREP4S72BEARING, BALL, ROD END, MALE THREAD, KNURLED SHANK AND SOLID SHANK, BMS3-11 FLUID RESISTANT, CORROSION RESISTANTFB28AV10A022CBUSHING, OVERSIZE FLANGE, LINED (FOR UNCLAMPED INSTALLATION)AACREP4S7BEARING, BALL, ROD END, MALE THREAD, KNURLED SHANK AND SOLID SHANK, BMS3-11 FLUID RESISTANT, CORROSION RESISTANT
Back to Boeing 747-400D