Boeing 737-476
PMA parts · 66,360
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 ('A16WE')
AND len(list_intersect(tcds_models, ['737-400 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 ('A16WE')
AND len(list_intersect(tcds_models, ['737-400 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.
BAC27DCT628MarkerBAC29PPS2245MarkerBAC29PPS22403MarkerBAC29PPS22593MarkerBAC29PPS2252MarkerBAC27DFS235MarkerBAC27DEL1272MarkerBAC27DFS236MarkerBAC29PPS2243MarkerBAC27DCC2762MarkerBAC27DEL1222MarkerBAC27DEL1223MarkerBAC29PPS22471MarkerBAC27DFS237MarkerBAC27DEL1153MarkerBAC27DEL1148MarkerBAC29PPS2248MarkerBAC27DHY0319MarkerBAC27DCC1812MarkerBAC29PPS2254MarkerBAC27DHY0316MarkerBAC27DEX5921MarkerBAC29PPS22397MarkerBAC29PPS22400MarkerBAC27DCT0383MarkerBAC29PPS2253MarkerBAC27DCA769MarkerBAC27DEL1274MarkerBAC27DEL1268MarkerGGO3D-3WWC-2000802.11 acWAP ConfigurationGGO2C-2MSM-0200Modem SoftwareGGO44-MPER-0100Erase SaaS8050917-0010ANIPaperGGO2E-3WSU-6533802.11 acWAP SoftwareGGO23-2MGS-0362GOS 3.6.2GGO52-LSSU-0523SACL SoftwareP19667-103LRU, ACPU-2, ABS CONTROL PROCESSOR UNIT, TM3 MOD743-0213-003SYSTEM CONTROL UNIT980-9800-001SERIES 800 AUDIO REPRO ASSEMBLY57141-1MITButton Assy - ReleaseN1495XLED LIGHT BULBL1309XL1309 LED LIGHT BULB3171577JP-1SetscrewAG943000-17Gasket-UHF/VHF Antenna8050917-0010ANIPaperBAC27TCT0017MarkerBAC27DHY0312MarkerBAC29PPS2232MarkerBAC29PPS2221MarkerBAC27DCT0326Marker
Back to Boeing 737-476