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.
65B05338-2JURY STRUT, UPPER65B08882-5RETAINER ASSY65B05299-2UNIVERSAL69B04065-2BOLT-CROSS69B04003-1END CAP69B04136-3SLEEVE65B08849-3BOLT ASSY65B08819-4BOLT65B05295-4PLUG LUBRICATOR65B23287-4STRAP - BUSHING ASSY, STEERING COLLAR65B05138-3ROLLER SUPPORT UPLOCK, BODY LANDING GEAR65B19937-2CARRIER HALF69B04127-3NAME PLATE - SHOCK STRUT, BODY, NOSE AND WING GEAR.69B04136-3SLEEVE65B05406-4FITTING - DOWNLOCK CRANK, NOSE LANDING GEAR69B04025-1BEARING69B04027-1NUT65B19923-7AXLE ASSY - NOSE LANDING GEAR69B00311-1SLEEVE65B05114-25COLLAR FWD HALF69B14953-1PLATE LOCK69B80168-12WASHER69B13310-1SLEEVE65B01477-1ROD - METERING69B04030-2ROLLER65B05203-1BEARING RACE ASSY65B01447-1RETAINER - RESTRICTOR PLATE, NOSE LANDING GEAR65B05214-3BEARING RACE - HALF69B04172-1PIN69B04041-1VALVE - SNUBBER65B05190-1WASHER65B01225-2TRIPOD BRACE - UPPER, NOSE LANDING GEAR69B04124-1SHIM PACK65B05114-24COLLAR ASSY69B00316-1PLUG65B05301-1FITTING ASSY - UNIVERSAL, WING LANDING GEAR65B05280-6BRACE65B01487-7OUTER RACE ASSY65B01470-1NUT65B05383-2SHAFT- EMERGENCY65B05303-6SPINDLE - DRAG STRUT, BODY LANDING GEAR69B04143-1WASHER, TANG WING POSITION ATTACH. WING LANDING GEAR69B00304-6SPACER-SPRING RET65B05404-3FITTING ASSY65B08830-2CYLINDER65B05479-5PIN69B04102-1WASHER-TANG65B01476-4RETAINER65B05406-3FITTING ASSY65B08855-1PISTON ROD ASSY
Back to Boeing 747-230B