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.
P00440Bushing, Wear95A10420-86Seal490-300Seal460-550Seal95A10420-20Seal615-750Seal95A10401Seal85A10069-767Seal79A3976-36Seal12M102-866Seal95A10420-39Seal95A10420-7Seal14A28Seal86A10117-781Seal460-500Seal600-825Seal1012866-055-FG04Video Arm Assembly1006496-753-BG07Video Arm Assembly1013559-707Video Arm Assembly1013559-708Video Arm Assembly1011751-055-FG05Video Arm Assembly1006496-756-BG07Video Arm Assembly1006496-751-BG07Video Arm Assembly1006496-755-BG07Video Arm AssemblySP2510-00-10010Thermal Switch2088197-0007WDBearingJA1005375-303ASMCarriage Cover - Tray TableSP3822-03-1080Poppet/ Float AssyH801417Filter AssemblyH10009359Clip69B46002-74Module Assy69B56132-18Switch Assy65B47675-2Relay Module Assy65B47511-38Accessory Box Assy69B56132-2Switch Assy69B46013-25Module Assy69B46119-100Module Assy417U5019-14Wire Assy - Floor Proximity Light65B47595-3Computer Assy69B56132-20Switch Assy69B46021-4Module Assy65B46118-171Module Assy69B43446-1Module Assy69B46325-1Module Assy65B47573-23Accessory Box Assy69B46134-1Module Assy69B46012-4Module Assy417U5019-6Wire Assy65B50620-9Panel Assy69B56132-12Switch Assy
Back to Boeing 747-230B