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.
69B55794-3BRACKET,SPRING65B58188-4CATCH65B52726-103STRAP416U6013-1BRACKET65B58490-1CABLE ASSY69B55917-1BRACKET GUIDE65B64029-16COVER69B51429-1PLATE65B52480-8STRAP65B25950-3NET ASSY65B52484-1TUBE ASSEMBLY65B54219-27PACK65B67367-23NET-ARTICLE RETAINER65B52726-67COVER65B52483-33FABRIC416U6035-9VELCRO HOOK453U0049-52FIBERGLASS BAG ASSY69B54562-2PULLEY GUARD65B52480-12STRAP65B52416-20CONTAINER ASSY65B47734-1PAD ASSY65B53933-86RETAINER ASSY65B52752-17SLIDE65B52726-122STRAP69B40093-10STRAP ASSY65B60323-14DIVIDER ASSY65B54025-18PANEL ASSY65B57636-51PACKBOARD ASSY69B55905-10CONNECTOR GUIDE69B52818-1TRIGGER69B55936-1FITTING65B60166-31NET ASSY69B55953-2REINFORCEMENT DISK65B57636-77PACKBOARD ASSY69B55478-1ANGLE65B52726-23COVER65B52751-18STRIP65B64029-18COVER65B50861-1CCONTAINER65B50861-1UCONTAINER65B58490-3CABLE ASSY65B58537-26TOP COVER ASSY69B55637-2STIFFENER BRACKET65B54164-2STRAP ASSY65B52726-118COVER65B54580-29NET65B52751-3SHIM69B55905-9CONNECTOR GUIDE65B57633-17RELEASE MECH ASSY69B54562-1PULLEY GUARD
Back to Boeing 747-230B