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.
65B08819-3BOLT ASSY65B05452-3BOLT ASSY65B18247-2BULKHEAD65B01443-1SPACER ASSY65B05296-3PLUG ASSY69B14945-1LOCK TAB65B08806-1WASHER65B19937-2CARRIER HALF69B04024-1NUT65B05261-3RETAINER ASSY65B05138-2ROLLER SUPPORT ASSEMBLY UPLOCK, BODY LANDING GEAR65B05222-3SLEEVE LUB ASSY69B04023-1WASHER-KEY65B05114-29STEERING COLLAR ASSY65B05383-2SHAFT- EMERGENCY69B04007-1SPACER69B04030-3ROLLER ASSY69B04022-1SHIM65B05327-5METERING ROD65B05456-3BOLT65B05322-1CENTER SECT. TUBE65B05336-3STRUT ASSY65B05192-2TORSION LINK - UPPER, NOSE LANDING GEAR69B04108-3NUT, SPECIAL65B05215-1BALL-SPHER.BRG.65B05114-24COLLAR ASSY65B05243-4PIN65B08845-2PIN65B01487-7OUTER RACE ASSY69B00277-1WASHER-TANG, SPECIAL65B05327-5METERING ROD65B05472-1WASHER SPLINED65B05497-8SPINDLE65B05111-3STEERING COLLAR, FWD65B08870-3BOLT ASSY69B04059-1BOLT, DOOR ROLLER65B05193-4SLEEVE - AXLE, BODY & WING LANDING GEAR.65B01476-3RETAINER ASSY65B05102-4TORSION LINK65B08833-4CAP - BUNGEE, JURY STRUT65B05370-3UPPER STRUT ASSY69B00317-1WASHER - TANG65B05138-1ROLLER SUPPORT ASSEMBLY UPLOCK, BODY LANDING GEAR65B05420-1BUNGEE BRKT ASSY65B01476-3RETAINER ASSY65B18271-1ADAPTER69B04124-1SHIM PACK69B04172-1PIN65B05400-1LINK ASSY65B19993-3SUPPORT ASSY
Back to Boeing 747-230B