Boeing 747-221F
PMA parts · 57,567
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-200F 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-200F 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.
65B01314-8PLATE69B70812-4SEAL65B62154-4HOUSING ASSY69B02450-3SHIM65B08464-8TUBE ASSY65B05886U17FWD WEB69B10910-2SHIM69B71380-1SEAL69B90703-2DRAIN TUBE ASSY65B63137-1TOGGLE69B60674-1STRAP69B13786-2SEAL ASSY65B17023-2WASHER ASSY69B53349-2WASHER LAMINATED69B15457-7PIN65B05488-2BOLT69B11418-5COLLAR ASSY65B61264-1LOCKHEAD ASSY65B13640Y1FAIRING65B07462-2SEAL65B15173-6LINK ASSY69B12287-19PIN ASSY65B63296-13SEAL69B53349-2WASHER LAMINATED65B08436-35SHEET RUBBING69B04082-1WASHER69B04154-2NUT69B00756-1MOLDED CORNER69B12011-601SPRING FLAT65B13640Y2FAIRING65B15950-1ROD ASSY69B18243-5BOLT65B12790U30HINGE ASSY65B14184-1TOGGLE ASSY65B02846-2STAY BRACE ASSY69B14108-9HOOK ASSY65B08843-2BOLT65B05885Y69SEAL65B08437-41SEAL ASSY69B10005-2WASHER65B94141U91SEAL COWL69B14903-1WASHER69B18244-2NUT69B63227-5LEVER69B10922-1BOLT65B01366-1STRIKER69B00257-1WAHSER TANG65B11637-111SEAL RETAINER69B13764-5SEAL RETAINER65B63126-501TONGUE
Back to Boeing 747-221F