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.
BAC27DEL1190MarkerBAC27DCT577MarkerBAC29PPS10672MarkerBAC29PPS10686MarkerBAC29PPS10633MarkerBAC29PPS20078MarkerBAC27DEX5580MarkerBAC27DEL1189MarkerBAC27DLG0143MarkerBAC27DEX5973MarkerBAC27DEX5974MarkerBAC29PPS10684MarkerBAC29PPS10639MarkerBAC29PPS10682MarkerBAC27DCT579MarkerBAC29PPS20080MarkerBAC29PPS20122MarkerBAC27DEX6235MarkerBAC27DCC2771MarkerBAC27DCC2756MarkerBAC27DCC2778MarkerBAC27DHY414MarkerBAC27DEX5550MarkerBAC29PPS10658MarkerBAC29PPS10643MarkerBAC27DHY392MarkerBAC29PPS20087MarkerBAC29PPS10683MarkerBAC29PPS10669MarkerBAC27DEX5975MarkerBAC27NCT0180MarkerBAC27DEL1191MarkerBAC29PPS10660MarkerBAC27DCA805MarkerBAC29PPS10655MarkerBAC27DEX5458MarkerBAC27DPA4989MarkerBAC29PPS20084MarkerBAC27DEX-358MarkerBAC27DEX491MarkerBAC29PPS20071MarkerBAC27DEX5460MarkerBAC29PPS20088MarkerBAC27DEX5961MarkerBAC29PPS20085MarkerBAC29PPS20072MarkerBAC29PPS10673MarkerBAC29PPS10648MarkerBAC29PPS10663MarkerBAC29PPS10634Marker
Back to Boeing 737-476