Skip to content

PMA parts · 10,464

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 ('4A26')
    AND len(list_intersect(tcds_models, ['707-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 ('4A26')
  AND len(list_intersect(tcds_models, ['707-400 Series'])) > 0
ORDER BY supplement_date DESC, drs_guid DESC

Run 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.

DSP3-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10CA3 · Jan 4, 2015 1916-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10BB80 · Jan 4, 2015 1909-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10BB45 · Jan 4, 2015 B543-EBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10CF25 · Jan 4, 2015 DSP6-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10CA6 · Jan 4, 2015 KP29B-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10BW29 · Jan 4, 2015 DSP5-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10CA5 · Jan 4, 2015 6931-700Pressure GaugeMeggitt Safety Systems Inc · PMA PQ0303NM · Replaces 10-60576-1 · Jan 4, 2015 B541DD-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10CF17PP · Jan 4, 2015 B538DD-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10CF10PP · Jan 4, 2015 SP3558-51-1070SleeveSoundair Aviation Services · PMA PQ2540NM · Replaces 412505 · Dec 28, 2014 1211LLT-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10AZ55PP · Dec 17, 2014 9104-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10BA20 · Dec 17, 2014 1207LT-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10AZ35P · Dec 17, 2014 9105-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10BA25 · Dec 17, 2014 37LLT-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10AY7PP · Dec 17, 2014 9110LT-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10BA50P · Dec 17, 2014 9105LLT-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10BA25PP · Dec 17, 2014 1202FF-1C1-02BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10AZ15MM · Dec 17, 2014 1206FF-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10AZ30MM · Dec 17, 2014 1203FF-1C1-02BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10AZ17MM · Dec 17, 2014 38-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10AY8 · Dec 17, 2014 35FF-1C1-02BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10AY5MM · Dec 17, 2014 9109LLT-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10BA45PP · Dec 17, 2014 36LLT-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10AY6PP · Dec 17, 2014 1201FF-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10AZ12MM · Dec 17, 2014 37FF-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10AY7MM · Dec 17, 2014 1210-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10AZ50 · Dec 17, 2014 9118-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10BA90 · Dec 17, 2014 36-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10AY6 · Dec 17, 2014 9112LLT-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10BA60PP · Dec 17, 2014 1212LLT-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10AZ60PP · Dec 17, 2014 9117LLT-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10BA85PP · Dec 17, 2014 1306-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10AX30 · Dec 17, 2014 9101LLT-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10BA12PP · Dec 17, 2014 39-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10AY9 · Dec 17, 2014 9102LT-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10BA15P · Dec 17, 2014 34FF-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10AY4MM · Dec 17, 2014 9120-1B1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10BA100 · Dec 17, 2014 9108LLT-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10BA40PP · Dec 17, 2014 9111LLT-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10BA55PP · Dec 17, 2014 39FF-1C1-01BEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10AY9MM · Dec 17, 2014 K3L3-EBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10A50 · Dec 11, 2014 KSP3L-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10AC03L · Dec 11, 2014 MB539DD-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10AS12 · Dec 11, 2014 KP4R16-EBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10A339 · Dec 11, 2014 KSP3-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10AC03 · Dec 11, 2014 MB542DD-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10AS21 · Dec 11, 2014 KSP8-PBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10AC08 · Dec 11, 2014 K3L2-EBEARINGSchatz Bearing Corporation · PMA PQ1067NE · Replaces BACB10A48 · Dec 11, 2014

Back to Boeing 707-430