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.
8614PGW-3753Marker- Soft, etc. (Chinese)8244VWG-18Marker-Static8614PMW-13875Marker-Drawer8614PGW-2090Marker- Rod, etc.8614PUW-1445Marker- 35, etc.8614PRW-3804Marker-Arrow Tail8614PGW-7847Marker- 75, etc.8614PGW-4501Marker- Rod, etc.8614PRW-3789Marker-Arrow Tail8614PGW-45738Marker- Fasten, etc.8614PGW-15589Marker- Drinking, etc.8614PGW-7841Marker- 150, etc.3238730-1WDNut, Lock3169407-1WEBearing, Annular Ball3169407-3WEBearing, Annular Ball2040061-103SWITCH DIFFERENTIAL PRESSURE, FILTER2040061-103SWITCH DIFFERENTIAL PRESSURE, FILTERH6084-2011 CU FT CYLINDERH6084-14 CU FT CYLINDERH6084-27 CU FT CYLINDERC48-06R16Y24P6-430CONNECTOR, PLUGC48-00R12-3S7-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, THREADED COUPLINGC48-00R14-4P-430CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, THREADED COUPLINGC48-10R12Y12P-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLINGC48-06R12-3P6-430CONNECTOR, PLUGC48-10R10Y5P-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLINGC48-06R22-19S-402CONNECTOR, ELECTRICAL, PLUG, STRAIGHT, THREADED COUPLINGC48-10R10Y5S-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLINGC48-10R10Y5P6-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLINGC48-06R16Y24P-430CONNECTOR, PLUGC48-10R10Y5P8-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLINGC0909A10-05P6Y420CONNECTOR, ELECTC48-10R10Y5P7-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLING200-007-006Master Indicator200-008-002Repeater Indicator200-008-003Repeater Indicator200-099-003Master Indicator200-099-005Master Indicator264-006-002Limited Select Panel200-007-010Master Indicator200-008-001Repeater Indicator200-099-002Master Indicator200-007-007Master Indicator200-007-009Master Indicator015-001-004Transmitter200-099-001Master Indicator264-006-001Limited Select Panel372-012-001Limited Select Panel200-007-008Master Indicator200-007-005Master Indicator
Back to Boeing 747-230B