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.
743S0040Spring743S0066Body743S0026Brace Screw743S0054Drive PinGP17B038Inlet Seal O-Ring743S0021Cylinder8195-35Hydraulic Press. Snubber65B05319-1Valve Assembly72372Flight Lock68640-2Valve, Press. OP. Check67530-2Valve, Check, Press. OP.37540-1Solenoid -Cargo Door6510-3Valve ASSY, Sel. Res *SNLA553044ValveLA555012DiaphragmLA555015DiaphragmLA553008GasketLA555153DiaphragmLA495357SleeveLA555016DiaphragmLA559018Dilution ScreenLA490X190A5005O-RingLA3460X240A20 B6O-RingLA412505SleeveLA220X160A20B6O-RingLA555033DiaphragmLA555070DiaphragmJA0YX0470A07M01MountJA0YX0324A02R03SpacerJA0YX0110A02M03PinJA0YX0320A02G11Handle AssemblyJA0YX0500A09M03BracketJA0YX0322A05M03HandleJA0YX0110A03M01PinJA0YX0324A02R01Indicator PlateJA0YX0324A02R05Indicator PlateJA0YX0324A02G01Indicator AssemblyM1005783-035Yoke Assembly-Footstool107STC-231EVAS(r)107STC-232EVAS(r)FG323000-21Gasket - Fuel Tank Access Door, 18 X 8FG323000-20Gasket - Fuel Tank Access Door, 18 X 10ADV-TNK-04Welded Tank AssemblyADV-TNK-04Welded Tank AssemblySSMKP23BSSD683ZNBEARINGSSMKP25BSSD685BEARINGSSMKP25BSD633BEARINGSSMKP23BSD668BEARINGSSMKP23BSD683ZNBEARINGSSMKP21BSSD668BEARING
Back to Boeing 747-230B