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.
65B08436-57SEAL ASSY65B08579-2BUSHING69B13002-3BUSHING302T0200-102BUSHING, FLANGED65B10196-3PIN69B12156-1BUSHING69B14928-1WIRE411U8022-1SHADE CHANNEL ASSY69B13325-2BUSHING69B02762-600CABLE ASSY69B00368-1BUSHING65B90659-1INTERCOSTAL69B80006-1VALVE VENT69B15060-2BUSHING65B17023-1WASHER ASSY65B90356-37BUSHING69B00488-22BUSHING-FLANGED65B83251-61PAD, RUBBER69B00750-2BUSHING65B01985-601BUSHING69B12157-1BUSHING65B83752-2GASKET453U1107-1CLAMP ASSY69B13830-6BUSHING FLANGED65B90147-32DUCT ASSY69B04022-1SHIM69B63462-1PAWL113U0001-1BUSHING69B19248-1SPRING416U6004-1CABLE ASSY69B00416-1BUSHING, FLANGED65B60133-23CABLE ASSY65B05393-3BUSHING-BRAKE HSG.69B04124-1SHIM PACK66-9236SAFETY GUIDE-65B70468-7SPACER65B05384-7BUSHING-BRAKE HSG69B00316-1PLUG65B94241-21SEAL314U2109-1TRANSITION DUCT ASSY69B00494-2BUSHING65B02242-1BUSHING, FLANGE66-21426-1SPRING-COMPRESSION65B41100-7GASKET65B82754-3LINK ASSY-65B60133-25CABLE ASSY313T3371-19SEAL69B01693-1BUSHING69B82672-2SPRING69B97423-600FITTING
Back to Boeing 747-230B