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.
4004C6-6-20WERoller, Bearing Element505342WEScreen Assembly, Air Filter766108G3WEPiston and Slipper Assembly517980WERing- Sealing8050917-0006WEPaper, Roll661036WEPin69494J906WEPacking, Preformed887583WEShaft-Coupling69259-10WERing, Seal, Outer358385-1WEBearing, Ball, Annular10-60754-1WESeal583-522-9103WESeal, Thread358545-1WEBearing, Ball69494K32WEPacking, Preformed4004C8-8-10WERoller Bearing695636WEGear, Spur60-72119WEBearing856504-2WEFilter769147-2WEGear, Cluster624912WEPacking-Preformed766108G1WEPiston and Slipper Assembly696011WESpring, Helical, Compression3500412-12WEPawl, Drive Shaft60-703119WEBearing2047168-8WESwitch6144-2WECap - End690775-4WEInsert, Screw Thread4004C9-9-12WERoller, Bearing Element583-522-9003WESeal, Thread623423WERetainer, Shaft Seal4004C8-12-12WERoller, Bearing Element3501649-1WEGear Set - Spur Matched697903WESwitch Mounting Adapter Assembly60-72118WEImpeller, Inlet887582WEAdapter4004C6-6-14WERoller, Bearing0642C624-20WEScrew, Cap, Socket Head Flat69494K11WEPacking, Preformed386022WEShaft and Insert Subassembly20755WEThermostat Assy808492-1WEFilter-Air856504-5WEFilter69494J10WEPacking, Preformed69494J8WEPacking, Preformed3883529-2WEBearing10-60754-221WESealSP2510-00-2082Brew Head BushingSP2510-00-2077Brew Handle BushingSP3810-01-4035Cartridge Valve Assy.NSL1776M B2Sealant
Back to Boeing 747-230B