Boeing 747-230B
PMA parts · 62,097
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-200B 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-200B 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.
2233000-815-1DFDAU2222601-8Flight Data Acquisition Unit2222601-5Flight Data Acquisition Unit2222601-18Flight Data Acquisition Unit2222894Flight Data Entry Panel2231515-2Indicator Panel2223512Special Data Acquisition Unit788521-10-001CDU2222548Flight Data Entry Panel2227000-805Digital Flight Data Management Unit (DFDMU)2222604Linear Accelerometer2243800-362Wireless GroundLink- Quick Access Recorder (WQAR)2227000-835Digital Flight Data Management Unit (DFDMU)2222601-2Flight Data Acquisition Unit710906, Version ADigital Flight Data Acquisition Processor (DAP) Software788523-10-002DMU2224686Flight Data Entry Panel (FDEP)2230666-02-CAirborne Data Loader2248000-61OQAR, Optical Quick Access Recorder35004-003-552XCentral Instrument Panel-7472230335-1Quick Access Recorder2248000-41OQAR, Optical Quick Access Recorder2223974-130-hr. Tape Cassette2232587-1Airplane Personality Module2222601-1Flight Data Acquisition Unit2248000-40OQAR, Optical Quick Access Recorder2223579Data Management Unit2231500-51Management UnitED742951-7FDAU2243800-360Wireless GroundLink- Quick Access Recorder (WQAR)35004-003-549XCentral Instrument Panel-747ED741907-1Data Management Unit788523-10-005DMU35004-003-549XXCentral Instrument Panel-7472222601Flight Data Acquisition Unit2231900-1ACARS/CMUAACREP4M64BEARING, 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)
Back to Boeing 747-230B