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.
CN0941-511RECEPTACLE ASSYCN0941-1007RECEPTACLE ASSYCN0941-505RECEPTACLE ASSYCN0958-107MAIN TK2 RECPT ASSYCN0941-308WIRE BUNDLE ASSYCN0958-111ASSY CABLECN0941-605RECEPTACLE ASSYCN0941-312RECEPTACLE ASSYCN0941-4PLUG ASSYCN0958-110ASSY-RECPTCN0941-1309RECEPTACLE ASSYCN0941-24PLUG ASSYCN0958-106RECPT ASSYCN0941-113RECEPTACLE ASSYCN0941-905RECEPTACLE ASSYCN0941-1005RECEPTACLE ASSYCN0941-514RECEPTACLE ASSYCN0941-1510RECEPTACLE ASSYCN0941-705RECEPTACLE ASSYCN0941-710RECEPTACLE ASSYCN0941-322RECEPTACLE ASSYCN0941-114RECEPTACLE ASSYCN0941-807RECEPTACLE ASSYCN0958-14SHORT PLUG ASSYCN0941-1109RECEPTACLE ASSYCN0941-1111RECEPTACLE ASSYCN0941-607RECEPTACLE ASSYCN0958-105RECPT ASSYSenior Operations P/N 28823-17Water System Compressor391-0001-( )Cellular Module Battery894043WEPin-SpringS9413-552WEPacking, Preformed - FluorocarbonS9413-565WEPacking, Preformed - FluorocarbonS9413-553WEPacking, Preformed - FluorocarbonS9413-023WEPacking, Preformed - FluorocarbonS9413-010WEPacking Preformed - FluorocarbonS9413-117WEPacking, Preformed - FluorocarbonS9413-018WEPacking, Preformed - Fluorocarbon9011M60P03WEGasket - Fuel FilterS9413-554WEPacking, Preformed - FluorocarbonA75MWEPlug - MagneticS9413-110WEPacking, Preformed - FluorocarbonS9413-127WEPacking, Preformed - FluorocarbonS9413-216WEPacking, Preformed - FluorocarbonS9413-261WEPacking, Preformed - FluorocarbonBAC1530-71WESealS9413-016WEPacking, Preformed - FluorocarbonS9413-147WEPacking, Preformed - FluorocarbonS9413-008WEPacking, Preformed - Fluorocarbon183143-1DECCover Assembly
Back to Boeing 747-230B