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.
NSL890RC A2SealantNSL890RC B2SealantNSL1422RC A1/2SealantNSL1776M B1/2Sealant69B14855-1SDLeaf SpringNSL1422RC A2SealantNSL890RC B1/2SealantNSL870 B1/2SealantNSL1422RC B2SealantNSL1422RC B1/2Sealant417T4205-96RINGNSL870 B2SealantNSL1440RC B2SealantNSL1440RC A2Sealant1-530-717Stationary Fuel Seal1-530-716Stationary Fuel SealB21507-06CylinderKT2607193Washer, RecessedKT329272Ring, MatingKT1291M24P03Facesheet-Blocker Dr65B94352-5BOLT69B97216-1BOLTP2-07-0015-(xxx) Series1E LED Flahslight System (Outline)65B94352-7BOLT69B97227-600BOLT69B94317-1BOLT65B15956-1PIN65B94352-6BOLT69B17927-1PIN65B05245-3BOLT69B02811-8PIN65B03295-1BOLT65B05454-4BOLT69B13452-1BOLT69B93202-1BOLT69B82988-2BOLT69B94134-1PIN65B05481-3BOLT69B12593-1PIN65B05221-2BOLT65B08843-2BOLT69B81040-2PIN65B05450-2PIN69B13876-5BOLT416T2164-19PIN69B90904-2PIN65B05438-2BOLT69B90904-1PIN416T2164-37PIN69B90907-7FUSE PIN
Back to Boeing 747-230B