Boeing 747-367
PMA parts · 58,851
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-300 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-300 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.
HA812730-3Fill FittingP35240130-5Fill FittingH59776Seal BossP35240130-1Fill FittingH57524Valve CoreP802503Check AssemblyH6370WasherP33440018-6Rupture DiscH55620-02Packing3238329-220STARBall-Bearing, Kit3237450-65STARBall-Bearing, Kit3234-1270STARBall Bearing, Kit3239117-1STARBearing, Roller3238196-265STARBall-Bearing, Kit4376-1562STARBall-Bearing, Kit3234-1235STARBall Bearing, Kit3238196-230STARBall-Bearing, Kit3234-1250STARBall Bearing, Kit3238329-240STARBall-Bearing, Kit3234-1240STARBall Bearing, Kit3238196-250STARBall-Bearing, Kit3238196-255STARBall-Bearing, Kit3238329-245STARBall-Bearing, Kit3234-1245STARBall Bearing, Kit3238329-225STARBall-Bearing, Kit3238196-260STARBall-Bearing, Kit3234-1265STARBall Bearing, Kit4376-1557STARBall-Bearing, Kit3238329-230STARBall-Bearing, Kit3238196-270STARBall-Bearing, Kit3238196-240STARBall-Bearing, Kit3237450-67STARBall-Bearing, Kit3234-1230STARBall Bearing, Kit3237450-64STARBall-Bearing, Kit3238196-275STARBall-Bearing, Kit4376-1552STARBall-Bearing, Kit4376-1567STARBall-Bearing, Kit3238196-235STARBall-Bearing, Kit3239117-1ASTARRoller Bearing, Advanced3238196-280STARBall-Bearing, Kit3238329-250STARBall-Bearing, Kit4376-1572STARBall-Bearing, Kit3237450-66STARBall-Bearing, Kit3238196-245STARBall-Bearing, Kit3238329-235STARBall-Bearing, Kit3234-1255STARBall Bearing, Kit3234-1260STARBall Bearing, Kit3237450-63STARBall-Bearing, Kit3234-1275STARBall Bearing, Kit3238329-215STARBall-Bearing, Kit
Back to Boeing 747-367