Franklin 4AC176B series airworthiness directives

Airworthiness directives that may apply · 0

ADs whose products match this engine model. Each AD’s applicability may narrow it by serial number, part number or configuration.

No ADs matched this model

Registered aircraft · 125

N20414Clark James R · Rhome, TXBuilt 1938 · S/N 1102 N2154MTrumbull Thomas A · Leland, MIS/N 20940 N21583Batte Randall · Forest, MSBuilt 1938 · S/N 2436

See all 125 registered aircraft

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE engine_model_code IN ('27006')
  ORDER BY n_number"

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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE engine_model_code IN ('27006')
ORDER BY n_number

Run 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.

NTSB investigations · 30

Aircraft matched to this engine model through the registry, by N-number and event date, checked against the reported serial number, make and model.

Defining event, 2008 on

Of 3 cases NTSB coded with a defining event. All defining events

In the probable cause, 2008 on

Findings NTSB made part of the probable cause. A case can have several. All findings

First occurrence, 1982 to 2007

Of 11 cases with NTSB’s older coding, defined in its coding manual.

NTSB CEN22LA199Accident · No injuriesClass 4 · LimitedFinal reportPiper J3F-65 · Port Bolivar, TXThe pilot’s failure to maintain directional control during takeoff.May 13, 2022 · N35257 · Substantial damage NTSB CEN16LA239Accident · Minor injuriesLimited investigationFinal reportPiper J3F 65 · Strasburg, COA partial loss of engine power due to carburetor ice accumulation.Jun 27, 2016 · N29042 · Substantial damage NTSB ANC12CA081Accident · No injuriesData collectionFinal reportPiper J3F-65 · Beluga, AKThe pilot's delayed decision to go around, which resulted in a hard landing.Jun 21, 2012 · N77EC · Substantial damage

See all 30 investigations

Query with SQL

SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.engine_model_code IN ('27006') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
  FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.engine_model_code IN ('27006')
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" 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 c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.engine_model_code IN ('27006')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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.

FAA incident reports · 32

Matched to this engine model through the registry, by N-number and event date, checked against the reported make and model.

Incident 20161202018909IPiper J3F-65 · Saluda, SCDescription of event: veered off side of runway 19 on landing and went down an embankment. Pilot statement: Concerning the incident on December 2, 2016 involving the Piper j 3 cub - NC38759. I took off from kirk air base T73 at 9:00AM. The destination was…Dec 2, 2016 · N38759 · Minor damage Accident 20160626009969APiper J3F-65 · Strasburg, COOn 06/26/2016 at approximately 19:52H MDT, N29042, a Piper J3F-65 aircraft sustained substantial damage after settling in a wheat field approximately 10 miles east of the front range airport and flipping over forward, coming to rest upside down. According to…Jun 26, 2016 · N29042 · Substantial damage Incident 20140822014429ITaylorcraft BF-65 · Victor, NYAircraft was returning from lancaster (bqr) around 19:30 and ran out of fuel. Emergency landing was attempted (42.960749, -77.384466 boughton hill rd Victor NY.) To what appeared to be a open field. Field was in fact a corn field and aircraft nosed over and…Aug 22, 2014 · N26620 · Minor damage

See all 32 incident reports

Query with SQL

duckdb -csv -c "SELECT report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number
  FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet'
  WHERE engine_model_code IN ('27006')
  ORDER BY event_date DESC, report_number 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 report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number
FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet'
WHERE engine_model_code IN ('27006')
ORDER BY event_date DESC, report_number DESC

Run 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.

Service difficulty reports · 1

SDR 2001FA0000469Gear · brokenFOLLOWING TAKEOFF, AT ABOUT 200 FT, ENGINE FAILED. AIRCRAFT LANDED IN FIELD WITHOUT FURTHER INCIDENT. SUBSEQUENT INSPECTION REVEALED CAM GEAR, WHICH DRIVE BOTH MAGNETO GEARS, HAD SHATTERED. CAM GEAR IS MADE OF MICARTA (FIBER) MATERIAL.Oct 3, 2001 · N3948 · Amtr HEADWIND · Magneto/Distributor

Query with SQL

duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy
  FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet'
  WHERE engine_model_key = '4AC176B'
  ORDER BY difficulty_date 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 sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy
FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet'
WHERE engine_model_key = '4AC176B'
ORDER BY difficulty_date DESC

Run 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.