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.
B546DD-PBearing, Ball, Airframe, Single Row, Torque Tube, Non-Self-AligningB540DD-PBearing, Ball, Airframe, Single Row, Torque Tube, Non-Self-AligningP5K-PBearing, Ball, Pulley TypeKP5-PBearing, Ball, Airframe, Single Row, Heavy DutyKP3AL-PBearing, Ball, Pulley TypeGDW4K2-PBearing, Ball, Airframe, Extra Wide, Double Row, Non Self-Aligning, Intermediate DutyGDW5-PBearing, Ball, Airframe, Extra Wide, Double Row, Non Self-Aligning, Intermediate DutyKP3AK2-PBearing, Ball, Pulley TypeP10K-PBearing, Ball, Pulley TypeGDW4K-PBearing, Ball, Airframe, Extra Wide, Double Row, Non Self-Aligning, Intermediate DutyB545DD-PBearing, Ball, Airframe, Single Row, Torque Tube, Non-Self-AligningP4K-PBearing, Ball, Pulley TypeKP3L-PBearing, Ball, Airframe, Single Row, Heavy DutyPD5K-PBearing, Ball, Pulley TypeB543DD-PBearing, Ball, Airframe, Single Row, Torque Tube, Non-Self-AligningKP8-PBearing, Ball, Airframe, Single Row, Heavy DutyB542DD-PBearing, Ball, Airframe, Single Row, Torque Tube, Non-Self-AligningB538DD-PBearing, Ball, Airframe, Single Row, Torque Tube, Non-Self-AligningKP10-PBearing, Ball, Airframe, Single Row, Heavy Duty8050917-0003BWEPaper, Roll713225-111WEPaper Roll65B50100-75Shell Assy65B50254-1202PSU69B54364-1Light Assy65B54017-8Door65B50253-94Oxygen Box Assy69B51248-1Hinge672U0017-2Floodlight Assy65B50255-1220Psu65B50253-100Oxygen Box Assy60B50059-61Hose69B55043-4Cord672U0017-4Floodlight Assy65B50255-1417Psu65B50254-1312PSU65B50255-1307PSU65B50150-1Door65B50254-7Tape65B50100-46Shell Assy65B50255-11Plug69B55043-3Streamer Assy110U6022-2Dripstick Door Assy65B50255-1201Psu110U6022-1Door Assy65B54031-1Stiffener69B50649-1Hinge69B51289-9Strap65B50101-37Shell Assy63-10155-1Coil Retainer65B50104-3Plenum Assembly
Back to Boeing 747-230B