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.
BAC29PPS22396MarkerBAC29PPS2247MarkerBAC29PPS2250MarkerBAC27DEL1069MarkerBAC29PPS22430MarkerBAC27DEL1250MarkerBAC27DCC2866MarkerBAC29PPS22394MarkerBAC29PPS22402MarkerBAC27DCC2884MarkerBAC27DEL1239MarkerBAC27DEL1271MarkerBAC29PPS22513MarkerBAC27DEL1150MarkerBAC27DCC2885MarkerBAC27DCC1813MarkerBAC29PPS22631MarkerBAC29PPS22523MarkerBAC27DEL1227MarkerBAC29PPS22573MarkerBAC27DEL1221MarkerBAC27DCC2763MarkerBAC27DEL1240MarkerBAC27DEL1249MarkerBAC29PPS2242MarkerBAC29PPS22395MarkerBAC27DBY194MarkerBAC29PPS22390MarkerBAC27DCC3010MarkerBAC29PPS22392MarkerBAC27DEL1228MarkerBAC29PPS2257MarkerBAC27DEL1233MarkerBAC29PPS2251MarkerBAC27DEL1225MarkerBAC27DEL1152MarkerBAC29PPS22571MarkerBAC27DEL1149MarkerBAC27DFS261MarkerBAC27DCC2764MarkerBAC27DEL1229MarkerBAC27DEL1273MarkerBAC27DFS230MarkerBAC27DEL1237MarkerBAC29PPS22524MarkerBAC27DEL1232MarkerBAC27DEX-700MarkerBAC29PPS22398MarkerBAC27DHY0315MarkerBAC29PPS2259Marker
Back to Boeing 737-476