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.
S009702AerFilm LHRS010847AerFilm LHRS6852AerFilm LHRS1591AerFilm LHRS013821AerFilm LHRS5220AerFilm LHRS010436AerFilm LHRS04922-003-H5AerFilm LHRS04075-001-H5AerFilm LHRS011339AerFilm LHRS2845AerFilm LHRS017352AerFilm LHRS011066AerFilm LHRS010540AerFilm LHRS2841AerFilm LHRS04900-013-H5AerFilm LHRS012554AerFilm LHRS016070AerFilm LHRS10290-002-H5AerFilm LHRS010559AerFilm LHRS04083-012-H5AerFilm LHRS07068-002-H5AerFilm LHRS5908-003-H5AerFilm LHRS7262AerFilm LHRS05903-001-H5AerFilm LHRS08259-006-H5AerFilm LHRS009491AerFilm CG w/ HA211S016371AerFilm LHRS012446AerFilm LHRS03563-002-H5AerFilm LHRS4429AerFilm LHRS7372AerFilm LHR84946AerFilm LHRS010593AerFilm LHRS015400AerFilm LHRS4477AerFilm LHRS04083-002-H5AerFilm LHRS2505AerFilm LHRS03090-001-H5AerFilm LHRS5852AerFilm LHRS14201-001-H5AerFilm LHRS3662AerFilm LHRS5932AerFilm LHRS8595AerFilm LHRS3357AerFilm LHRS4715AerFilm LHRS04018-001-H5AerFilm LHRS03918-002-H5AerFilm LHRS03941-001-H5AerFilm LHRS3148AerFilm LHR
Back to Boeing 737-377