Beech B-19 SPORT
PMA parts · 474
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 ('A1CE')
AND len(list_intersect(tcds_models, ['B19'])) > 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 ('A1CE')
AND len(list_intersect(tcds_models, ['B19'])) > 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.
RA2H3-12Regulator AssemblyRA-B3-5-1Garter FilterCRB122253-02Avionics Blowers, FansLS03-04000-36Hose AvionicsLS10003-01Electronic Noise FiltersCRB6457-04Avionics Blowers, FansLS03-04000-24Hose AvionicsLS03-01004Filter CapacitorW/XT-2341-187-RHBEECHCRAFT MUSKETEER 2ND WINDOWW/XT-2341-RHBEECHCRAFT MUSKETEER 2ND WINDOWW-2341-187-RHBEECHCRAFT MUSKETEER 2ND WINDOWW-2361-LHBEECHCRAFT MUSKETEER RH OR LH FORWARD WINDOW - WITH ASSEMBLED VENTW/G-2327BEECHCRAFT MUSKETEER RH DOOR WINDOWW/T-2327BEECHCRAFT MUSKETEER RH DOOR WINDOWW/T-2361-187-LHBEECHCRAFT MUSKETEER RH OR LH FORWARD WINDOW - WITH ASSEMBLED VENTW/G-1080-375BEECHCRAFT MUSKETEER VENT WINDOWW/G-2337-LHBEECHCRAFT MUSKETEER 2ND WINDOWW-2341-250-LHBEECHCRAFT MUSKETEER 2ND WINDOWW/G-2331BEECHCRAFT MUSKETEER PILOT WINDOWW/T-2361-187-RHBEECHCRAFT MUSKETEER RH OR LH FORWARD WINDOW - WITH ASSEMBLED VENTW-2341-187-LHBEECHCRAFT MUSKETEER 2ND WINDOWW/XT-2337-187-LHBEECHCRAFT MUSKETEER 2ND WINDOWW/T-2331-250BEECHCRAFT MUSKETEER PILOT WINDOWW-2332BEECHCRAFT MUSKETEER PILOT WINDOWW/G-2361-RHBEECHCRAFT MUSKETEER RH OR LH FORWARD WINDOW - WITH ASSEMBLED VENTW/T-2337-250-RHBEECHCRAFT MUSKETEER 2ND WINDOWW/G-2362-LHBEECHCRAFT MUSKETEER RH OR LH FORWARD WINDOW - WITH ASSEMBLED VENTW/T-2341-250-LHBEECHCRAFT MUSKETEER 2ND WINDOWW/T-2337-250-LHBEECHCRAFT MUSKETEER 2ND WINDOWW/G-2362-187-LHBEECHCRAFT MUSKETEER RH OR LH FORWARD WINDOW - WITH ASSEMBLED VENTW/G-2341-187-RHBEECHCRAFT MUSKETEER 2ND WINDOWW/G-2361-187-LHBEECHCRAFT MUSKETEER RH OR LH FORWARD WINDOW - WITH ASSEMBLED VENTW/G-2361-187-RHBEECHCRAFT MUSKETEER RH OR LH FORWARD WINDOW - WITH ASSEMBLED VENTW/T-2341-187-RHBEECHCRAFT MUSKETEER 2ND WINDOWW/G-2327-250BEECHCRAFT MUSKETEER RH DOOR WINDOWW/G-1079-375BEECHCRAFT MUSKETEER VENT WINDOWW/G-2337-187-RHBEECHCRAFT MUSKETEER 2ND WINDOWW/G-2326-250BEECHCRAFT MUSKETEER RH DOOR WINDOWW-2331BEECHCRAFT MUSKETEER PILOT WINDOWW-2327-250BEECHCRAFT MUSKETEER RH DOOR WINDOWW-2361-250-RHBEECHCRAFT MUSKETEER RH OR LH FORWARD WINDOW - WITH ASSEMBLED VENTW/G-1080BEECHCRAFT MUSKETEER VENT WINDOWW/T-2362-187-RHBEECHCRAFT MUSKETEER RH OR LH FORWARD WINDOW - WITH ASSEMBLED VENTW/G-2362-RHBEECHCRAFT MUSKETEER RH OR LH FORWARD WINDOW - WITH ASSEMBLED VENTW-2362-250-RHBEECHCRAFT MUSKETEER RH OR LH FORWARD WINDOW - WITH ASSEMBLED VENTW/G-2361-250-RHBEECHCRAFT MUSKETEER RH OR LH FORWARD WINDOW - WITH ASSEMBLED VENTW-2332-187BEECHCRAFT MUSKETEER PILOT WINDOWW-2327BEECHCRAFT MUSKETEER RH DOOR WINDOWW/XT-2337-250-LHBEECHCRAFT MUSKETEER 2ND WINDOWW/T-2327-250BEECHCRAFT MUSKETEER RH DOOR WINDOW
Back to Beech B-19 SPORT