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.
200-099-004Master Indicator015-001-003Transmitter200-099-006Master IndicatorSP2510-00-7016Packing, PreformedSP2510-00-7018BallSP2510-00-7019HousingSP2510-00-7014Valve Vent AssemblySP2510-00-7017Body SubassemblySP2510-00-7014Valve Vent Assembly65B07673-6Pane- outer65B07674-15Pane- middle140U4005-3Pane, Outer140U4006-203Window Assy.2793916JP-101Link140U4005-5Pane, Outer65B54194-2Reveal140U4005-10Pane, Outer140U4006-219Window Assy.65B07673-12Pane- outer140U4005-1Pane, Outer25049JPHanger and Trunion Assembly140U4005-20Pane, Outer65B50022-4Inner Reveal Assy.140U4006-201Window Assy.65B07673-3Pane- outer140U4006-215Window Assy.65B07674-8Pane- middle65B07674-14Pane- middle140U4005-15Pane, Outer65B07640-20Window assy65B07673-1Pane-outer65B50022-6Inner Reveal Assy.65B07674-7Pane- middle65B07639-20Window Assy65B07674-11Pane, middle65B54194-1Reveal65B50022-3Inner Reveal Assy.65B07674-12Pane- middle65B07673-4Pane- outer140U4006-209Window Assy.65B07673-8Pane- outer858885JP-3Diaphragm Assembly Diaphragm Assembly65B07674-1Pane, middle140U4006-207Window Assy.793114JP-1Brake Cable Sub Assembly65B07640-19Window assy140U4006-220Window Assy.66877JPHanger (Swash Plate)858886JP-14Diaphragm Assembly Diaphragm Assembly65B07674-13Pane- middle
Back to Boeing 747-230B