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.
69B14945-1LOCK TAB65B05114-25COLLAR FWD HALF65B19937-1CARRIER ASSY69B04045-3BOLT ASSY65B05434-3CYLINDER ASSY69B00230-2NUT65B01476-4RETAINER65B05477-2PIN65B08831-3PISTON ASSY69B04079-1WASHER161U0002-2PIN-LOWER BEARING65B08871-3BOLT ASSY65B05358-2SIDE BRACE ASSY - NOSE LANDING GEAR65B08819-4BOLT69B04046-3SPRING65B18244-1UNIVERSAL65B05292-2BOLT65B05452-4BOLT69B04094-2NUT65B23287-3STRAP - BUSHING ASSY, STEERING COLLAR65B05292-2BOLT65B05454-4BOLT- LOWER TRIPOD65B05396-2LINK65B05142-1VALVE, SNUBBER65B05441-3BOLT ASSY65B05112-2STEERING COLLAR, AFT65B05434-3CYLINDER ASSY65B05203-2BEARING RACE, HALF65B19989-3SUPPORT ASSY65B08882-3RETAINER ASSY69B00316-1PLUG69B00338-3BOLT ASSY65B05436-3ROD END ASSY65B18242-1UPPER DRAG STRUT69B04045-3BOLT ASSY65B05440-3BOLT ASSY65B08893-1COLLAR, SPLINED65B05452-4BOLT65B05400-2LINK161U0002-2PIN-LOWER BEARING65B08806-1WASHER65B08895-6PLUG LUBRICATION65B08857-3BOLT ASSY65B18248-1TUBE SUPPORT - RESTRICTOR, BODY LANDING GEAR65B05302-4PLUG,LUBRICATION65B01435-6TRUNNION FORK ASSY69B04134-1LOCK - TAB69B00376-2NUT - LOWER TRIPOD65B18271-1ADAPTER69B13303-1LOCK - TAB
Back to Boeing 747-230B