Boeing 747-SR
PMA parts · 38,389
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, ['747SR 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, ['747SR 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.
65B05476-2UPPER STRUT PIN65B05316-6TUBE ASSY69B00158-3BEARING PAD65B01399-3RETAINER NUT65B70287-150CONDUIT ASSEMBLYY65B08830-2CYLINDER69B70773-6BRACKET69B71107-1ARM ASSY-69B04081-1WASHER69B15136-3KEY69B04140-1WASHER, KEY69B00188-1BOLT69B14918-1RING PISTON65B05221-2BOLT-APEX69B70231-7COUPLING69B00371-1BUSHING69B80877-2GUIDE ASSY65B08859-7INSERT ASSY69B14928-1WIRE65B08854-11INNER RACE65B18239-1NUT69B04067-2BUSHING65B05488-2BOLT69B04071-2RETAINING RING65B80711-3Shaft Sleeve69B71132-1BUMPER ASSY69B00227-1WASHER65B82552-17BRACKET ASSY69B04094-2NUT69B80798-2BRACKET69B83909-1CLAMP69B13362-1LOCK PLATE65B08807-9INSERT ASSY65B08856-3BOLT65B01443-1SPACER ASSY60-4455-2Shaft65B70287-179CONDUIT ASSY-B69-38919-35Sleeve69B71278-2BEARING SUPPORT65B19983-2PIN69B14903-1WASHERBACN10HR12CSELF-LOCKING NUT69B14925-1WASHER69B04093-1WASHER65B08103-67BUSHING-PLAIN65B05302-3PLUG ASSY69B00258-1RETAINING RING69B80300-8STRAP69B11213-1NUT69B11235-2RUB STRIP
Back to Boeing 747-SR