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.
10A347-350-350Housing, Peri-Seal14A320-7Retainer460-825Seal14A314-7Piston14A339Seal14A469Seal14A362RetainerADV-3575-1251-07Heater AssyADV-428-0074-1Tank AssyADV-RL119-2Relay21FA213FilterLA140U4005-18Pane - Outer, Passenger WindowLA140U4005-19Pane - Outer, Passenger Window8050917-0006BWEPaper, RollLA140U4005-13Pane - Outer, Passenger WindowLA140U4005-5Pane - Outer, Passenger WindowLA140U4005-11Pane - Outer, Passenger WindowLA140U4005-9Pane - Outer, Passenger Window3501741-2WEGearshaft, SpurLA140U4005-14Pane - Outer, Passenger WindowLA140U4005-10Pane - Outer, Passenger WindowLA140U4005-15Pane - Outer, Passenger WindowLA140U4005-7Pane - Outer, Passenger WindowLA140U4005-17Pane - Outer, Passenger WindowLA140U4005-1Pane - Outer, Passenger WindowLA140U4005 -3Pane - Outer, Passenger WindowLA140U4005-20Pane - Outer, Passenger Window740801-6WDSleeve, BearingP22010Bearing AssemblyE410-1543RelayES410-1538RelayE410-1550RelayES210-1632RelayE210-1643RelayE210-1642RelayE210-1631RelayE210-1641RelayKT972576Element, Seal69-12359-4Fitting-Nut65B05441-3BOLT ASSY65B08104-202Bushing-Flanged65B80143-1CLAMP ASSY69B71234-1PLATE65B41664-3CUSHIONED CLAMP ASSY69B00171-1SPACER69B00230-2NUT65B05244-2PIN69B43388-30BOX ASSY65B01485-1HOUSING SPRING69B11217-1BRACKET-SIDE ROLLER
Back to Boeing 747-230B