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.
65B61255-1PANEL ASSY65B57619-42PACKBOARD ASSY69B62325-1CORD ASSY65B53933-87RETAINER ASSY65B58537-11STRAP ASSY69B51509-6PULLEY65B57638-20RETAINER STRAP416U6037-17SIDE COVER ASSY65B52480-5SUPPORT69B48124-1STRAP ASSY65B60553-43DIVIDER ASSY65B57636-7VELCRO PILE65B54025-17PANEL ASSY69B55847-1LANYARD RETAINER65B52501-3PACKBOARD65B58187-4ANGLE65B54556-7RELEASE65B58537-27TOP COVER ASSY416U6031-1STRAP ASSY-65B57391-38SLIDE PACK ASSY69B53273-5STRAP65B52474-7SLIDE PACK ASSY69B55465-7TOP LATCH ASSY69B55467-2HOOK PLATE65B52483-37STRAP65B52414-9TUBE65B53933-58KNITTED NET65B52480-16STRAP65B54219-16SHIM65B57692-4PIVOT BRACKET ASSY65B67366-56NET-OHSTW BIN SUPT416U6037-9STRAP ASSY69B55465-2PLATE, MOUNTING69B41608-1STRAP ASSY69B55896-1MOUNTING PLATE69B54817-3GUARD65B58959-7STRAP65B57619-22CLAMP HOSE65B52726-127COVER65B54568-12SHELF65B57391-4CORD416U6030-11SHELL ASSY65B57391-147SLIDE PACK ASSYAC9060-3BARRIER NET ASSY69B52867-2PLATE65B52726-78COVER69B52070-2SHOCK CORD65B57619-9RUB STRIP65B52483-35COVER69B43329-5HOSE ASSY
Back to Boeing 747-230B