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.
41389312Paper41391510Paper83A10500-90Seal41391651Paper2007610-001Paper41391410Paper41389313Paper41391450Paper107STC-231EVAS(r)107STC-232EVAS(r)M713225-111Paper RollM8050917-0006Paper Roll1005783-111KTShaft - Footstool PivotKIT 25501407-1ISO Container Offset Restraint KitAA630124-11Carbon Filament Reinforced Aluminum Pressure Vessel 1125 cu. in. VolumeAA4A3192-7Filament Reinforced Aluminum Pressure Vessel-800 cu. in. VolumeAA4A3057Filament Reinforced Aluminum Pressure Vessel-1100 cu. in. VolumeAA630124-06Carbon Filament Reinforced Aluminum Pressure Vessel 1000 cu. in. Volume125-11261-1( )Assist Handle125-11262-1( )Handle Nut125-11261-2( )Assist Handle64751-251JASpacer Bush64751-249JABasket64759-035JABrew Cup Moulding64759-033JABrew Cup Assembly3197003-508JACover and Lens AssemblyMAR15T2T4619Cylinder Assembly1006927-163JAStriker Plate - FootstoolMAR298Ring-Cylinder TrimTAE0728-1Par 64 Lamp Cool SpotTAE0528-2WPar 36 Lamp Warm WideTAE0528-1WPar 36 Lamp Warm SpotTAE0528-2Par 36 Lamp Cool WideTAE0528-1Par 36 Lamp Cool SpotTAE0628-2Par 46 Lamp Cool WideTAE0528-1XPar 36 Lamp Cool Spot Hi IntensitySSMDW8SD633ZNBEARINGSSMGDW5SD668BEARINGSSMGDW5SD633BEARINGSSMKP10ASD633BEARINGSSMGDW4K2SD633BEARINGSSMDSP6SD633ZNBEARINGSSMDSP8SD633BEARINGSSMDSP8SD668BEARINGSSMDW8SD633BEARINGSSMGDW4K2SD668BEARINGSSMDW4K2SD633BEARINGSSMKP10ASD633ZNBEARINGSSMGDW8SD668BEARINGSSMGDW8SD633ZNBEARING
Back to Boeing 747-230B