Boeing/Porter/Epperson B-75N1
PMA parts · 269
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 ('A-743')
AND len(list_intersect(tcds_models, ['B75N1 (Navy N2S-3)'])) > 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 ('A-743')
AND len(list_intersect(tcds_models, ['B75N1 (Navy N2S-3)'])) > 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.
BS75-1401L-10-1Spar Bracket, Servo Tab Linkage, RightBS75-1408L-13End Closure Rib, LeftBS75-1408L-12End Closure Rib, RightBS75-1409-4Neoprene DamperBS75-1408L-7Hinge Attach AngleBS75-1240UAileron Attach FittingBS75-1404LRear IntercostalBS75-1405U-2Forward Reinforcement BracketBS75-1406L-3Bottom SkinBS75-1402L-2-1Stub Rib, Right AileronBS75-1401L-11Linkage Rod, Servo TabBS75-1406UAttach BracketBS75-1406L-2Top SkinBS75-1406LAttach BracketBS75-1404URear IntercostalBS75-1405U-3Rear Reinforcement BracketDL1401Sellers Swathmaster Kit No. 1401AFC-K008 dated 1/8/94 or later FAA-Approved RevisionRemote Mount Oil Filter KitPetersen Dwg List Boeing Stearman dated 12/12/83 or later FAA approved rev.Operation of Airplane on Unleaded or Leaded Automotive Gasoline
Back to Boeing/Porter/Epperson B-75N1