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.
M123170-1Roller, CoveredM126170-1Roller, Covered58163-7WERing-Piston58163-4WERing-PistonSP2510-00-8A080Plate Assembly (L)SP2510-00-8A105Polyester SpringSP2510-00-8A095ProbeSP2510-00-8A075Plate Assembly (R)SP2510-00-2152ScreenSP2510-00-2097JDouble Probe Guard3860158-1WEBearing, RollerPT528AV08A025ABUSHING, FLANGED O/SSP3810-09-1010Knob, Drain RodSP3810-09-1005Drain RodSP3810-09-1005BDrain RodSP3810-09-1015Bracket, MountingWF329910Filter Element, OilWF326035Filter Element, OilSP2510-00-7075BWater Jet141U3006U501STRAP ASSEMBLY141U3006U502STRAP ASSEMBLYB102000-1( )WD Where ( ) Represents Logo CodeCoffee CarafeLA140U4005 -1, -3, -5, -7, -9, -10, -11, -13, -14, -15, -17, -18, 19 & -20Pane, Outer, Passenger WindowB4A3057CylinderB5RC225HT3CylinderB5A2644-8CylinderB630124-11CylinderB6084-26CylinderAA69B52215-5BearingB4A3192-7CylinderB630124-06CylinderB6084-34CylinderB21507-06CylinderB6084-33Cylinder859989-4PRRing, Piston859989-4PRRing, Piston16816-15JETSlip-On Back Cover859989-4PRRing Piston974353-1PRPiston Ring859989-4PRRing, Piston16814-15JETSlip-On Headrest Cover16813-15JETSlip-On Bottom Cover859989-20PRRing PistonWF326105Filter Element1-580-704O-Ring Face Seal315-2Number Reminder1103P1349Switch, PressureB42365-1Quick disconnect fitting362-502-9208WEGasket-Met224-1340-19SDWeld Assy
Back to Boeing 747-230B