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.
10101C758Valve, Waste Drain (Posi-Lift(tm))C48-10R18-14P-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLINGC48-10R18Y31P7-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLING86-4102-2Cover Assembly, Pressure Oiler86-4253-1Adapter, Pressure Oiler336-0036-01Valve, Waste DrainC48-10R14Y12P-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLING86-4101-1Adapter, Pressure OilerC48-10R18-14S-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLING580-082Valve, Fill, Frangible, Potable Water86-4102-1Adapter, Pressure OilerC48-10R14-7S-402CONNECTOR, ELECTRICAL, RECEPTACLE, FLANGE MOUNT, BAYONET COUPLING86-4101-2Cover, Pressure Oiler81000-43907ATSLED FLOOR LIGHT81000-43906ATSLED FLOOR LIGHT00252-001Left Oven Closeout Kit91301-001Drawer Top Assy.00252-002Right Oven Closeout Kit91300-001Oven Assy.137-517-9602WDBearing, SleeveRK747-7-LWCargo RollerRK747-10Cargo RollerRK747-8Cargo RollerRK747-6Cargo RollerRK747-11Cargo RollerRK747-1Cargo RollerRK747-7Cargo RollerRK747-9Cargo RollerRK747-12Cargo RollerRK747-2Cargo RollerRK747-4Cargo RollerRK747-3Cargo RollerRK747-5Cargo Roller69B10701-1SPACER69B13225-1ROLLER ASSY65B89752-20FAIRLEAD69B11591-6HINGE HALF65B89715-14SEAL, BULB65B08218-1UPPER LINK ASSY65B08215-1SLEEVE - TELESCOPIC69B00138-1PADH999109Gasket321U0447-51PLUG65B90150-6BRACKET880500-4WESeal, Shaft738325-2WEBearing, Ball733899-1WEBearing, Ball, Annular358385-1WEBearing, Ball, Annular3826381-3WDBushing, Vespel3501156-1WEBearing, Ball, Annular
Back to Boeing 747-230B