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.
W/T-2162-250BEECHCRAFT C23 WINDSHIELDW-2361-250-LHBEECHCRAFT MUSKETEER RH OR LH FORWARD WINDOW - WITH ASSEMBLED VENTW/T-2341-250-RHBEECHCRAFT MUSKETEER 2ND WINDOWW-2341-RHBEECHCRAFT MUSKETEER 2ND WINDOWW/T-2361-250-RHBEECHCRAFT MUSKETEER RH OR LH FORWARD WINDOW - WITH ASSEMBLED VENTW/T-1080BEECHCRAFT MUSKETEER VENT WINDOWW-1079-375BEECHCRAFT MUSKETEER VENT WINDOWW/XT-2337-LHBEECHCRAFT MUSKETEER 2ND WINDOWW/T-2326-187BEECHCRAFT MUSKETEER RH DOOR WINDOWW-2361-RHBEECHCRAFT MUSKETEER RH OR LH FORWARD WINDOW - WITH ASSEMBLED VENTW/G-2337-250-LHBEECHCRAFT MUSKETEER 2ND WINDOWW/G-2331-250BEECHCRAFT MUSKETEER PILOT WINDOWW-2337-LHBEECHCRAFT MUSKETEER 2ND WINDOWW/T-2341-RHBEECHCRAFT MUSKETEER 2ND WINDOWW/T-2326-250BEECHCRAFT MUSKETEER RH DOOR WINDOWW/G-2341-250-RHBEECHCRAFT MUSKETEER 2ND WINDOWW/T-2362-RHBEECHCRAFT MUSKETEER RH OR LH FORWARD WINDOW - WITH ASSEMBLED VENTW/T-2361-250-LH W/G-2361-250-LHBEECHCRAFT MUSKETEER RH OR LH FORWARD WINDOW - WITH ASSEMBLED VENTW/G-2327-187BEECHCRAFT MUSKETEER RH DOOR WINDOWW/G-2337-RHBEECHCRAFT MUSKETEER 2ND WINDOWW/G-2332-187BEECHCRAFT MUSKETEER PILOT WINDOWW/T-2332-187BEECHCRAFT MUSKETEER PILOT WINDOWW-2326-187BEECHCRAFT MUSKETEER RH DOOR WINDOWW/T-2362-250-LHBEECHCRAFT MUSKETEER RH OR LH FORWARD WINDOW - WITH ASSEMBLED VENTW-2162-250BEECHCRAFT C23 WINDSHIELDW/T-1079-375BEECHCRAFT MUSKETEER VENT WINDOWW-2331-250BEECHCRAFT MUSKETEER PILOT WINDOWW/G-2162BEECHCRAFT C23 WINDSHIELDW-2359BEECHCRAFT MUSKETEER LANDING LIGHT LENS (PANE)W-2327-187BEECHCRAFT MUSKETEER RH DOOR WINDOWW/T-1079BEECHCRAFT MUSKETEER VENT WINDOWW/G-2341-187-LHBEECHCRAFT MUSKETEER 2ND WINDOWW/T-2362-LHBEECHCRAFT MUSKETEER RH OR LH FORWARD WINDOW - WITH ASSEMBLED VENTW-2362-187-RHBEECHCRAFT MUSKETEER RH OR LH FORWARD WINDOW - WITH ASSEMBLED VENTW-2162-187BEECHCRAFT C23 WINDSHIELDW-1079BEECHCRAFT MUSKETEER VENT WINDOWW/G-2341-250-LHBEECHCRAFT MUSKETEER 2ND WINDOWW/T-2361-RHBEECHCRAFT MUSKETEER RH OR LH FORWARD WINDOW - WITH ASSEMBLED VENTW/XT-2337-250-RHBEECHCRAFT MUSKETEER 2ND WINDOWW/T-2327-187BEECHCRAFT MUSKETEER RH DOOR WINDOWW-2341-250-RHBEECHCRAFT MUSKETEER 2ND WINDOWW/T-2331BEECHCRAFT MUSKETEER PILOT WINDOWW/T-2361-LHBEECHCRAFT MUSKETEER RH OR LH FORWARD WINDOW - WITH ASSEMBLED VENTW/G-2362-187-RHBEECHCRAFT MUSKETEER RH OR LH FORWARD WINDOW - WITH ASSEMBLED VENTW-2337-187-LHBEECHCRAFT MUSKETEER 2ND WINDOWW/G-2162-250BEECHCRAFT C23 WINDSHIELDW/T-1080-375BEECHCRAFT MUSKETEER VENT WINDOWW/T-2326BEECHCRAFT MUSKETEER RH DOOR WINDOWW/G-2341-LHBEECHCRAFT MUSKETEER 2ND WINDOWW-2326BEECHCRAFT MUSKETEER RH DOOR WINDOW
Back to Beech B-19 SPORT