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.
65B05481-3BOLT ASSY411U1280-2SHOE SPRING65B28074-1PIN65B01314-8PLATE69B70812-4SEAL65B62154-4HOUSING ASSY69B02450-3SHIM65B08464-8TUBE ASSY65B05886U17FWD WEB69B10910-2SHIM65B01842-624ROD311U2570U30RUB STRIP69B71380-1SEAL69B90703-2DRAIN TUBE ASSY65B60875-29SEAL65B63137-1TOGGLE69B60674-1STRAP69B13786-2SEAL ASSY65B17023-2WASHER ASSY69B53349-2WASHER LAMINATED69B15457-7PIN65B52286-19SEAL65B05488-2BOLT69B54807-2BRACKET ASSY69B11418-5COLLAR ASSY65B61264-1LOCKHEAD ASSY65B13640Y1FAIRING65B07462-2SEAL65B15173-6LINK ASSY69B12287-19PIN ASSY69B53349-2WASHER LAMINATED65B08436-35SHEET RUBBING69B04082-1WASHER311T2570-96SEAL STRIP69B04154-2NUT69B00756-1MOLDED CORNER69B12011-601SPRING FLAT65B13640Y2FAIRING65B15950-1ROD ASSY65B14184-1TOGGLE ASSY65B02846-2STAY BRACE ASSY69B14108-9HOOK ASSY65B08843-2BOLT65B05885Y69SEAL65B08437-41SEAL ASSY69B10005-2WASHER65B56140-20COVER ASSY65B94141U91SEAL COWL69B14903-1WASHER69B18244-2NUT
Back to Boeing 747-230B