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.
LM29749CONEGF169-910013-157Fairing-Lower CowlGF169-910013-157Fairing-Lower Cowl8001602Engine Oil Cooler Assembly2307055-1Aviation Landing LightK169-640000-97Tip-Vertical FinGF169-620001-27Tip Assy, Stabilator LHGF169-620001-28Tip Assy, Stabilator RHTR-55-0339-101G6C2Capacitor2307055-1Aviation Landing LightB-00368-17Alternator Control, 28VB-00289-2Relay, Over-Voltage, 14VB-00331-2Voltage Regulator, Type I, 14V2307055-1Aviation Landing LightST-215System 40/50 Single and Two Axis Automatic Flight Guidance SystemsRA066-10500-4KBrake Lining KitRA066-11200Brake LiningRA066-10500Brake LiningRA105-00200RivetRA066-11200-4KBrake Lining KitRA066-11200Brake LiningRA066-11200-4KBrake Lining KitAMTI-B3805SSNTail Skid / Tie RingAMTI-B3805SSTail Skid / Tie RingAMTI-B3800STie RingGF169-620000-111Stabilizer Tip LeftGF169-440013-11DorsalGF169-1100-01Wing Tip RightGF169-620000-112Stabilizer Tip RightGF169-1100-00Wing Tip LeftGF-169-4411-STail ConeGF169-420028-11Fuel Sump Drain Cover8001602Engine Oil Cooler AssemblyJ-7402-16Lord Engine Mounting KitJ-7402-16Lord Engine Mounting KitK169-534096-3Panel LHK169-534092-10Window RHK169-534092-9Window LHK169-534096-4Panel RHB-00331-2Voltage Regulator, Type I, 14VB-00289-2Relay, Over-Voltage, 14VB-00368-17Alternator Control, 28V2307055-1Aviation Landing LightST-855-20/30System 20/30 Single and Two Axis Automatic Flight Guidance System1160005-0Sunvisor System1730001-0Sunvisor System1160007-0Sunvisor SystemST-893System 30ALT Altitude Hold SystemAMTI-B3805SAssembly, SkidAMTI-B3800Ring, Angled, Wing Hold-Down
Back to Beech B-19 SPORT