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.
US743730-39Electrical WiresUS743730-83Electrical WiresUS743401-13Angle ClipUS743730-15Electrical WiresUS743730-37Electrical WiresUS745100-165PlateUS745730-15Electrical Wires7FS0140B03M05PlacardUS740PS3-15WT. PlacardUS745170-3DoublerUS743200-239PlateUS743120-175PlateUS743193-1Oven Bracket AssyH6364-00Safety DiscH7171-00Safety DiscH801815-00Safety Cap AssemblyH10006001Safety Disc270T0002-42WDBall, BearingCN0941-521RECEPTACLE ASSYCN0941-1310RECEPTACLE ASSYCN0958-108CNTR TK RECPT ASSYCN0941-721RECEPTACLE ASSYCN0941-1105RECEPTACLE ASSYCN0941-706RECEPTACLE ASSYCN0941-314RECEPTACLE ASSYCN0958-114ASSY CABLECN0941-711RECEPTACLE ASSYCN0941-509RECEPTACLE ASSYCN0941-707RECEPTACLE ASSYCN0941-906RECEPTACLE ASSYCN0941-14CABLE ASSYCN0941-506RECEPTACLE ASSYCN0941-805RECEPTACLE ASSYCN0941-910RECEPTACLE ASSYCN0941-507RECEPTACLE ASSYCN0958-109RECPT ASSYCN0941-1205RECEPTACLE ASSYCN0941-313RECEPTACLE ASSYCN0958-205ASSY CABLECN0941-911RECEPTACLE ASSYCN0958-207ASSY-RECPT-MAIN TK3CN0941-510RECEPTACLE ASSYCN0958-113ASSY CABLECN0941-709RECEPTACLE ASSYCN0941-112RECEPTACLE ASSYCN0941-907RECEPTACLE ASSYCN0941-1509RECEPTACLE ASSYCN0941-1110RECEPTACLE ASSYCN0941-909RECEPTACLE ASSYCN0958-112ASSY CABLE
Back to Boeing 747-230B