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.
BAC27DAC78MarkerBAC29PPS20755MarkerBAC29PPS20715MarkerBAC27DAC133MarkerBAC29PPS20825MarkerBAC29PPS20714MarkerBAC27DEX6653MarkerBAC27TEX0573MarkerBAC29PPS20769MarkerBAC29PPS20817MarkerBAC29PPS2079MarkerBAC29PPS20820MarkerBAC29PPS20744MarkerBAC27DCC2952MarkerBAC27DCT756MarkerS9026L124KTPacking, PreformedS9026L110KTPacking, PreformedBAC27DCC2752MarkerS9026D038KTPacking, PreformedS9026D124KTPacking, PreformedBAC27DCC3008MarkerS9026L111KTPreformed PackingS9026E241KTPreformed PackingS9026E260KTPacking, PreformedS9026D111KTPacking, PreformedS9026L124KTPreformed PackingS9026F903KTPacking, PreformedS9026D124KTPreformed PackingS9026E163KTPacking, PreformedBAC29PPS20754MarkerBAC27NEC227MarkerS9026D038KTPreformed PackingS9026L110KTPreformed PackingS9026E241KTPacking, PreformedBAC27DEX6613MarkerS9026L111KTPacking, PreformedS9026D110KTPacking, PreformedS9026D110KTPreformed PackingS9026L038KTPreformed PackingS9026D111KTPreformed PackingBAC29PPS20752MarkerS9026G267KTPreformed PackingS9026L040KTPreformed PackingS9026L040KTPacking, PreformedS9026G267KTPacking, PreformedBAC29PPS21414MarkerS9026L235KTPreformed PackingS9026L038KTPacking, PreformedS9026F903KTPreformed PackingS9026E260KTPreformed Packing
Back to Boeing 737-476