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.
69B12042-4BUSHING65B09326-2SPRING GUIDE65B94512-2BUSHING-FLANGED69B15659-1PULLEY ASSY65B17175-2SPRING ASSY65B08872-2BOLT-TRUNNION PIN65B17158-23GASKET-SEAL69B12208-1BUSHING65B02242-4BUSHING, STRAIGHT69B00352-2BUSHING69B00229-3BUSHING65B15172-1LINK ASSY65B10196-1PIN69B14977-4BUSHING69B14977-3BUSHING65B50095-25SHADE ASSEMBLY69B10924-1WASHER ASSY69B63149-1SHACKLE65B08578-2BUSHING65B02242-2BUSHING, CLAMP UP69B40995-1GASKETEV943000S1B with U-FilEV949012150GY Cartridge255455-412150BP CartridgeEV949212150GP CartridgeEV939000XS1 with U-FilEV940000S1E with U-FilEV949000150G CartridgeEV037700Mounting Bracket Assy.EV941000XS1B with U-FilEV949812150B CartridgeWF337813Filter Element, AirWF337423Filter Element, AirWF336827Filter Element, OilWF337572Filter Element, AirWF337424Filter Element, AirWF336859Filter Element, OilWF337259Filter Element, OilWF336991Filter Element, OilWF337260Filter Element, FuelWF336110Filter Element, HydraulicWF336113Filter Element, HydraulicWF336109Filter Element, HydraulicWF335105Filter Element, LubeWF336014Filter Element, HydraulicWF336127Filter Element, HydraulicWF336113Filter Element, HydraulicWF336112Filter Element, HydraulicWF336111Filter Element, HydraulicWF336017Filter Element, Hydraulic
Back to Boeing 747-230B