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.
BALCap Assembly, Light Assembly311-711-4941-003Switch Matrix Assembly, Light Assembly303-1001-001Base Assembly, Switch276-5324-006Indicator Light Assembly, Socket318-630-5391-003Indicator Light Assembly, Light Assembly406Lamp Socket711-1029-001Cap Assembly, Cap332-632-1055-01Lighted Switch Matrix, Switch Assembly432-632-0981-11Pushbutton Switch Assembly332-632-1056-02Lighted Switch Matrix, Switch Assembly432-632-0982-07Pushbutton Switch Assembly711-1012-011APushbutton Switch Cap Assembly, Cap340-640-0371-001Lighted Switch Assembly, Light Assembly311-711-0989-008Indicator Light Assembly, Switch Assembly332-632-1023-01Lighted Switch Assembly711-1012-012APushbutton Switch Cap Assembly, Cap711-1012-018APushbutton Switch Cap Assembly, Cap343-640-0882-001Indicator Assembly341-640-6992-002Lighted Switch Assembly, Light Assembly311-711-4952-002Switch Light Assembly, Light AssemblySTB130-4Indicator, Light Assembly130Base Assembly, Light Assembly432-632-0981-02Pushbutton Switch Assembly311-711-0081-001Indicator Light Assembly, Light Assembly311-711-0989-007Indicator Light Assembly, Switch Assembly632-5161-05Cap Assembly, Light Assembly033-547-4952-001Indicator Light Assembly, Light332-632-0994-01Lighted Switch Matrix, Switch Assembly632-5161-03Cap Assembly, Light AssemblyST130-4Cap Assembly, Light Assembly318-630-1025-003Indicator Light Assembly, Light Assembly632-5161-04Cap Assembly, Light Assembly432-632-0981-13Pushbutton Switch Assembly711-1012-032APushbutton Switch Cap Assembly, Cap711-0081-006Cap Assembly, Light Assembly341-640-1535-001Lighted Switch Matrix, Switch332-632-0990-01Lighted Switch Matrix, Switch Assembly332-632-1036-01Lighted Switch Matrix, Switch Assembly332-632-1018-01Lighted Switch Matrix, Switch AssemblySTB130Base Assembly, Light Assembly311-711-1029-001Lighted Switch Matrix, Switch311-711-4952-005Switch Light Assembly, Light Assembly432-632-0981-18Pushbutton Switch Assembly432-632-0981-10Pushbutton Switch Assembly711-1012-025APushbutton Switch Cap Assembly, Cap432-632-0982-05Pushbutton Switch Assembly276-0614-001Indicator Light Assembly560Socket Assembly, Lamp432-632-0981-03Pushbutton Switch Assembly332-632-1096-01Lighted Switch Assembly
Back to Boeing 747-230B