Boeing 737-377
PMA parts · 72,475
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-300 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-300 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.
BAC29PPS1247MarkerBAC29PPS19666MarkerBAC29PPS19564MarkerBAC29PPS19668MarkerBAC29PPS19594MarkerBAC29PPS19609MarkerBAC29PPS19999MarkerBAC29PPS19613MarkerBAC29PPS20060MarkerBAC29PPS19511MarkerBAC29PPS19610MarkerBAC29PPS19672MarkerBAC29PPS19557MarkerBAC29PPS19547MarkerBAC29PPS19612MarkerBAC29PPS60514MarkerBAC29PPS19562MarkerBAC29PPS19509MarkerBAC29PPS19510MarkerBAC29PPS12436MarkerBAC29PPS19561MarkerBAC29PPS19566MarkerBAC29PPS20042MarkerBAC29PPS31114MarkerBAC29PPS46944MarkerBAC29PPS20049MarkerBAC29PPS20010MarkerBAC29PPS20067MarkerBAC29PPS33773MarkerBAC29PPS19645MarkerBAC29PPS19536MarkerBAC29PPS19507MarkerBAC29PPS29613MarkerBAC29PPS45188MarkerBAC29PPS19992MarkerBAC29PPS19880MarkerBAC29PPS19501MarkerBAC29PPS20043MarkerBAC29PPS20056MarkerBAC27TEX6887MarkerBAC29PPS1243MarkerBAC29PPS58939MarkerBAC29PPS20068MarkerBAC29PPS19664MarkerBAC29PPS20002MarkerBAC29PPS19996MarkerBAC29PPS19993MarkerBAC29PPS19497MarkerBAC29PPS19502MarkerBAC29PPS29617Marker
Back to Boeing 737-377