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.
PR071722B12SN-000Connector, Electrical, Receptacle, Flange Mount, Bayonet CouplingPR071028D42P8-200Connector, ElectricPR071622B55SN-000Connector, Electrical, Plug, Straight, Bayonet CouplingPR071024D30P7-200Connector, ElectricPR071128F42S8-200Connector, ElectricPR071022D12P6-200Connector, ElectricPR070020B25SN-200Connector, ElectricPR071112J12SN-200Connector, ElectricPR071012C03P9-200Connector, ElectricPR071616B24S6-000Connector, Electrical, Plug, Straight, Bayonet CouplingPR071210B05SN-200Connector, ElectricPR071620B41P6-000Connector, Electrical, Plug, Straight, Bayonet CouplingPR071024C30PN-200Connector, ElectricPR073916SE10S6-000Connector, ReceptPR070118G14P8-200Connector, ReceptPR073824SE30P9-000Connector, PlugPR071012G12SN-200Connector, ElectricPR070018G08S7-200Connector, ElectricPR071714B12P6-000Connector, Electrical, Receptacle, Flange Mount, Bayonet CouplingPR070012G03P8-200Electrical ConnectorPR071010F05S6-200Connector, ElectricPR071116F10S8-200Electrical ConnectorPR071014D07S8-200Connector, ElectPR071114F07P7-200Connector, ElectricPR071112J12S6-200Connector, ElectricPR071018D14P6-200Connector, ElectricPR070018G14SN-200Connector, ElectricPR072714B07SN-200Connector, Receptacle, CircularPR070124G30P8-200Connector, ReceptPR770G0001S7-200Connector, ReceptPR071114F04S6-200Connector, ElectricPR070014B12PN-200Connector, ElectricPR071120J41SN-200Connector, ElectricPR071116F10S6-200Connector, ElectricPR070120B25SN-200Connector, ReceptPR070122G12S7-200Connector, ReceptPR071722B55PN-200Connector, Electrical, Receptacle, Flange Mount, Bayonet CouplingPR071012D03PN-200Connector, ElectricPR070122B55PN-200Connector, ReceptPR071720B41PN-000Connector, Electrical, Receptacle, Flange Mount, Bayonet CouplingPR073828SE42SN-000Electrical ConnectorPR071710B05P8-000Connector, Electrical, Receptacle, Flange Mount, Bayonet CouplingPR073816SE10S6-000Connector, Circular, PlugPR071118F14S8-200Connector, ElectricPR071618B31P8-000Connector, Electrical, Plug, Straight, Bayonet CouplingPR071008G03SN-200Connector, Electric6001-99-0538EHHeating ElementH55620-01PackingH59776Seal BossH13362Gasket Dem&Valve
Back to Boeing 747-230B