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.
302T0200-11GBushing - Nacelle Strut302T0200-37GBushing - Nacelle Strut302T0200-165GBushing - Nacelle Strut302T0200-82GBushing - Nacelle Strut302T0200-126GBushing - Nacelle Strut302T0200-110GBushing - Nacelle Strut302T0200-19GBushing - Nacelle Strut302T0200-16GBushing - Nacelle Strut302T0200-146GBushing - Nacelle Strut302T0200-130GBushing - Nacelle Strut302T0200-5GBushing - Nacelle Strut302T0200-41GBushing - Nacelle Strut302T0200-169GBushing - Nacelle Strut302T0200-85GBushing - Nacelle Strut302T0200-33GBushing - Nacelle Strut302T0200-32GBushing - Nacelle Strut302T0200-25GBushing - Nacelle Strut302T0200-128GBushing - Nacelle Strut302T0200-92GBushing - Nacelle Strut302T0200-147GBushing - Nacelle Strut302T0200-97GBushing - Nacelle Strut302T0200-21GBushing - Nacelle Strut302T0200-140GBushing - Nacelle Strut302T0200-159GBushing - Nacelle Strut302T0200-2GBushing - Nacelle Strut302T0200-145GBushing - Nacelle Strut302T0200-156GBushing - Nacelle Strut302T0200-115GBushing - Nacelle Strut302T0200-86GBushing - Nacelle Strut302T0200-80GBushing - Nacelle Strut302T0200-27GBushing - Nacelle Strut302T0200-13GBushing - Nacelle Strut69B52215-1GBearing - Support Cover Retainer, Off-Wing Escape302T0200-106GBushing - Nacelle Strut302T0200-68GBushing - Nacelle Strut302T0200-157GBushing - Nacelle Strut302T0200-64GBushing - Nacelle Strut302T0200-103GBushing - Nacelle Strut302T0200-45GBushing - Nacelle Strut302T0200-142GBushing - Nacelle Strut302T0200-158GBushing - Nacelle Strut302T0200-22GBushing - Nacelle Strut302T0200-87GBushing - Nacelle Strut302T0200-127GBushing - Nacelle Strut302T0200-124GBushing - Nacelle Strut302T0200-62GBushing - Nacelle Strut302T0200-131GBushing - Nacelle Strut302T0200-47GBushing - Nacelle Strut302T0200-24GBushing - Nacelle Strut302T0200-177GBushing - Nacelle Strut
Back to Boeing 747-230B