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.
GP17B07SO-RING524S0010PISTON10GP05-011PULL CABLE (8 inch )524S0013-1BOTTLE FITTING524GPS-2Ball Valve and RegulatorGP19B907O-RING504S0028PIN504S0015PIPE DETAIL515S0028SHELL GAGE PROTECTOR14GP01-004PRESSURE GAUGE524S0013BOTTLE FITTINGGP17B905O-RING524S0010-1PISTON504S0009GUIDE, DETAIL BALLGP18E009O-RING524S0016SHIM524S0034STR. TH'D ELBOW524S0019PLATE TOP DETAIL504S0025RETAINER RINGGP17B009O-RING524GPS-5Ball Valve and Regulator524GPS-4Ball Valve and Regulator504S0010DETENT, STOP PIN504S0006-2SHAFT503M0202-3BALL-3000 PSIGP19B908O-RING524S0002-1BBODY14GP04-006BODYGP1BT006SINGLE TURN BACK-UP RING524GPS-6Ball Valve and RegulatorGP18E011O-RINGGP1BT011Back-Up Ring743S0055-1Name Plate743S0020Piston743GPS-9Aspirator743GPS-8Aspirator743S0027Set Screw743S0013-2Duct Tube743S0023Spacer743S0074Spring Washer743S0013-1Duct Tube743S0061Molded Flapper Assy.743S0055-3Name PlateGP17B011O-RingGP1BT012Back-Up Ring743S0022Inlet Fitting743S0072Inlet Seal743S0056-1Nozzle Tube Assy.743S0024Inlet Fitting Screw743S0045Flapper Washer
Back to Boeing 747-230B