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.
AL24-P70Alternator KitP12-2322FilterAECI PN, 169-380043AECSpring, Landing GearAECI PN, 169-524050AECBearingLS03-01022Alternator/ Generator System FilterMCNAS31427-1131CableMCNAS31427-1370CableMCNAS31425-1220CableMCNAS31426-1170CableMCNAS31425-0931CableMCNAS31424-1152CableMCNAS31424-0870CableMCNAS31424-1242CableMCNAS31424-0934CableMCNAS31425-0820CableMCNAS30245-2053CableMCNAS31425-1411CableAECI PN 169-380086-1AECValve, Fuel SelectorADS-1200-7Forward Cabin Entry Door Seal119Left Center #2 Window274Landing Light Lens, Taxi Light Lens267Storm Window (Vent Window)120Left Center #2 Window107Left Front Pilot Window108Left Front Pilot Window121Right Center #2 Window132Right Center #2 Window273, 273.187, 273.250Windshield266Right Front Cabin Door Window109Right Front Cabin Door WindowRA164-04300Brake DiscRA164-06900Brake DiscAL12-P70Alternator KitAL12-P70Alternator KitAL24-P70Alternator KitAL12-P70Alternator KitAL24-P70Alternator KitAL12-F60Alternator KitAL12-P70Alternator KitAL12-P70Alternator KitAL12-F60Alternator KitAL12-P70Alternator KitAECI P/N 169-430012-19AECDoor Seal, BaggageAECI P/N 169-420036-124AECSeal, Cabin DoorAECI P/N H2532-13AECLever Assembly with Key Lock (Exterior, Door Handle)AL12-F60Alternator KitAL12-P70Alternator KitLS10003-01Electronic Noise FiltersLS03-01004Filter CapacitorRA2H3-12Regulator Assembly
Back to Beech B-19 SPORT