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.
S016372AerFilm LHRS7650AerFilm LHRS6170AerFilm LHRS05448-001-H5AerFilm LHRS009868AerFilm LHRS3274AerFilm LHRS012733AerFilm LHRS06478-001-H5AerFilm LHRS8980AerFilm LHRS08948-002-H5AerFilm LHRSP2511-11-16008Steam OutletS07068-001-H5AerFilm LHRS009129AerFilm LHRS8903AerFilm LHRS14201-001-H5AerFilm LHRS15207-002-H5AerFilm LHRS009817AerFilm LHRS07445-001-H5AerFilm LHRS4496AerFilm LHRS3805AerFilm LHRS4318AerFilm LHRS2071AerFilm LHRS017232AerFilm LHRS05077-002-H5AerFilm LHRS016271AerFilm LHRS09276-001-H5AerFilm LHRS013446AerFilm LHRS016564AerFilm LHRS011013AerFilm LHRS010861AerFilm LHRS7290AerFilm LHRS08201-001-H5AerFilm LHRS04075-001-H5AerFilm LHRS3068AerFilm LHRS016755AerFilm LHRS8993AerFilm LHRS04132-001-H5AerFilm LHRS05903-001-H5AerFilm LHRS016374AerFilm LHRS010848AerFilm LHRS011759AerFilm LHRS6019AerFilm LHRS3056AerFilm LHRS05097-001-H5AerFilm LHRS05421-001-H5AerFilm LHRS012674AerFilm LHRS00663-001-H5AerFilm LHRS015157AerFilm LHRS8284AerFilm CGS2321AerFilm LHR
Back to Boeing 737-377