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.
65B52898-3Panel Assy-Center65B50100-23Shell Assy65B67129-3Shell65B50255-1338PSU65B50176-2Shell Assy65B50253-54Oxygen Box Assy65B50150-1Door65B52242-17Wiring Assy65B50145-1Dust Cover65B50254-1312PSU65B50101-4Shell Assy65B50176-14Shell Assy65B53998-25Shell-PSU65B50101-37Shell Assy65B50255-1417Psu65B54017-8Door1378M16P01DECLink1378M17G01DECLink Assy-ArmSP2510-00-2097HBlock, SupportSP3810-09-1005HNNut, HexSP2510-00-2095Sensor Assembly1101273-07Strap0108161-17Dual Harness Reel0108160-7Dual Harness Reel33603903M-2Fire Extinguisher 224-10108161-9Dual Harness Reel0108160-1Dual Harness Reel1101273-01Strap0108161-7Dual Harness Reel1101273-11Strap0108161-11Dual Harness Reel33600021-36Fire Extinguisher36500019-3Temp. Comp. Press. Regulator0501150-3Rudder, Cable Tension Regulator0501151-3Elevator, Cable Tension Regulator0108136-1Harness Reel0108136-5Harness Reel0108136-21Harness Reel0108160-3Dual Harness Reel30100022-3Fire Extinguisher0108136-13Harness Reel36500019-3Regulator0501016-03Control Cable Tension Regulator0108161-15Dual Harness Reel0108136-17Harness Reel18303902-5Gauge0108160-5Dual Harness Reel0108161-5Dual Harness Reel34200001Fire Extinguisher18340308Pressure Gauge
Back to Boeing 747-230B