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.
7035-34Valve-Regulated Lead-Acid Battery2307055-1Aviation Landing Light2307055-1Aviation Landing LightADS1200-7Main Seal, (Front Entry DoorADS1200-17Seal (Storm Window)ADS1200-19 ADS1200-19Seal (Storm Window) Seal (Storm Window)SC-W/T-2334-187Beechcraft Musketeer Pilot Window - Without Door (.187 SC Green)SC-W/G-2334-187Beechcraft Musketeer Pilot Window - Without Door (.187 SC Gray)SC-W/G-2334-250Beechcraft Musketeer Pilot Window - Without Door (.250 SC Gray)W-2360-250Beechcraft Musketeer Pilot's Window Assy (.250 Clear)W/G-2334-187Beechcraft Musketeer Pilot Window - Without Door (.187 Gray)W-2334Beechcraft Musketeer Pilot Window - Without Door (Clear)W/T-2334-187Beechcraft Musketeer Pilot Window - Without Door (.187 Green)W-2360Beechcraft Musketeer Pilot's Window Assy (Clear)SC-W/G-2334Beechcraft Musketeer Pilot Window - Without Door (SC Gray)W/G-2360-250Beechcraft Musketeer Pilot's Window Assy (.250 Gray)W/G-2334Beechcraft Musketeer Pilot Window - Without Door (Gray)SC-W/T-2360Beechcraft Musketeer Pilot's Window Assy (SC Green)W/T-2360-250Beechcraft Musketeer Pilot's Window Assy (.250 Green)W/T-2334Beechcraft Musketeer Pilot Window - Without Door (Green)W/G-2334-250Beechcraft Musketeer Pilot Window - Without Door (.250 Gray)W-2334-250Beechcraft Musketeer Pilot Window - Without Door (.250 Clear)W/T-2360Beechcraft Musketeer Pilot's Window Assy (Green)W/G-2360Beechcraft Musketeer Pilot's Window Assy (Gray)SC-W/G-2360Beechcraft Musketeer Pilot's Window Assy (SC Gray)SC-W/G-2360-250Beechcraft Musketeer Pilot's Window Assy (.250 SC Gray)SC-W/T-2334Beechcraft Musketeer Pilot Window - Without Door (SC Green)SC-W/T-2360-250Beechcraft Musketeer Pilot's Window Assy (.250 SC Green)SC-W/T-2334-250Beechcraft Musketeer Pilot Window - Without Door (.250 SC Green)W/T-2334-250Beechcraft Musketeer Pilot Window - Without Door (.250 Green)W-2334-187Beechcraft Musketeer Pilot Window - Without Door (.187 Clear)2044Volt and Vac2040-1-1, 2040-1-2Voice Alert System08125CONE08231CUPLM29749CONELM29710CUPTR-A1280-2Lens-Navigation Light AssyTR-A1280-3Lens- Navigation Light AssyK169-940017-173CoverTR-55-0339-101G2C2Capacitor2307055-1Aviation Landing LightTR-55-0339- 101G2C2CapacitorAL12-F60Alternator KitAL12-P70Alternator KitAL24-P70Alternator KitAL12-P70Alternator Kit7025-20Valve-Regulated Lead-Acid BatteryLM29710CUP08231CUP
Back to Beech B-19 SPORT