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.
S014205AerFilm LHRS3272AerFilm LHRS010135AerFilm LHRS6666AerFilm LHRS5546AerFilm LHRS3662AerFilm LHRS6688AerFilm LHRS7890AerFilm LHRS09204-015-H5AerFilm LHRS009704AerFilm LHRS5932AerFilm LHRS013964AerFilm LHRS010041AerFilm LHRS5852AerFilm LHRS8723AerFilm LHRS50062-001-H5AerFilm LHRS8994AerFilm LHRS50672-003-H5AerFilm LHRS7532AerFilm LHRS06045-002-H5AerFilm LHRS04016-031-H5AerFilm LHRS2654AerFilm LHRS03930-004-H5AerFilm LHRS03930-001-H5AerFilm LHRS1927AerFilm LHRS1733AerFilm LHRS009216AerFilm LHRS017325AerFilm LHRS2526AerFilm LHRS5175AerFilm LHRS7885AerFilm CGS09274-004-H5AerFilm LHRS5834AerFilm LHRS07253-001-H5AerFilm LHRS50672-001-H5AerFilm LHRS2484AerFilm LHRS3179AerFilm LHRS6564AerFilm LHRS012758AerFilm LHRS009428AerFilm LHRS7058AerFilm LHRS010844AerFilm LHRS012086AerFilm LHRS08015-001-H5AerFilm LHRS012668AerFilm LHRS011712AerFilm LHRS07230-003-H5AerFilm LHRS016069AerFilm LHRS013962AerFilm LHRS7533AerFilm LHR
Back to Boeing 737-377