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.
BAC29PPS22358MarkerBAC27DLG0137MarkerBAC27TCT0033MarkerBAC27NEC241MarkerBAC29PPS2223MarkerBAC29PPS2228MarkerBAC27DLG0120MarkerBAC27TCT0014MarkerBAC27DHY0302MarkerBAC29PPS22374MarkerBAC27DPP0123MarkerBAC27TCT0031MarkerBAC27TCT0012MarkerBAC27NEC244MarkerBAC27NEC240MarkerBAC27TCT0016MarkerBAC29PPS22385MarkerBAC29PPS2234MarkerBAC29PPS22377MarkerBAC27NEC239MarkerBAC29PPS22370MarkerBAC29PPS22389MarkerBAC29PPS22361MarkerBAC27TCT0018MarkerBAC29PPS22354MarkerBAC27TCT0013MarkerBAC27NEC226MarkerBAC29PPS2224MarkerBAC29PPS22384MarkerBAC29PPS22352MarkerBAC29PPS22360MarkerBAC27TCT0015MarkerBAC27DHY0301MarkerBAC27DLG0110MarkerBAC29PPS2226MarkerBAC29PPS22386MarkerBAC29PPS2227MarkerBAC29PPS22356MarkerBAC29PPS22383MarkerBAC29PPS22373MarkerBAC29PPS22378MarkerBAC27TCT0010MarkerBAC29PPS2217MarkerBAC27DCT0327MarkerBAC27TCT0032MarkerBAC29PPS22387MarkerBAC27NEC243MarkerBAC29PPS22359MarkerBAC29PPS22382MarkerBAC29PPS2225Marker
Back to Boeing 737-476