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.
BAC29PPS20897MarkerBAC29PPS20856MarkerBAC29PPS15368MarkerBAC29PPS20857MarkerBAC29PPS54894MarkerBAC29PPS20862MarkerBAC29PPS15243MarkerBAC29PPS15249MarkerBAC29PPS15372MarkerBAC29PPS15369MarkerBAC29PPS15370MarkerBAC29PPS20865MarkerBAC29PPS20859MarkerBAC29PPS20876MarkerBAC29PPS15360MarkerBAC29PPS54893MarkerBAC29PPS20852Marker11-10865Filter Assy-InlineBAC29PPS20841Marker7511295Filter Element7507227Filter ElementBAC29PPS15259Marker162BL903INDICATOR, TEMPERATURE, ELECTRICAL RESISTANCE VOLTAGECOMPENSATED162BL902INDICATOR163LCP80INDICATOR162BL801INDICATOR1140-0111-73DRIPSTICK ASSY, MEASURING STICK FUEL LEVEL1140-0111-72DRIPSTICK ASSY, MEASURING STICK FUEL LEVEL1140-0111-74DRIPSTICK ASSY, MEASURING STICK FUEL LEVEL1140-0111-68DRIPSTICK ASSY, MEASURING STICK FUEL LEVEL1140-0111-70DRIPSTICK ASSY, MEASURING STICK FUEL LEVEL1140-0111-66DRIPSTICK ASSY, MEASURING STICK FUEL LEVEL1140-0111-65DRIPSTICK ASSY, MEASURING STICK FUEL LEVEL1140-0111-67DRIPSTICK ASSY, MEASURING STICK FUEL LEVEL1140-0111-64DRIPSTICK ASSY, MEASURING STICK FUEL LEVEL1140-0111-69DRIPSTICK ASSY, MEASURING STICK FUEL LEVELBAC27DCC2705MarkerBAC29PPS21740Marker152LMA23INDICATOR, EGT 2" RND153400-26502-16K, ALTITUDE SWITCHBAC29PPS12049Marker163CV59INDICATOR, WATER QTY, OUTLINE DWGBAC29PPS21735MarkerBAC29PPS21745Marker154LUA104INDICATOR, VALVE POSBAC29PPS21751Marker149LF10INDICATOR, FREQUENCYBAC27DHY0265Marker149LA6INDICATOR, DC AMP149LV8INDICATOR, D.C. VOLTS
Back to Boeing 737-476