Jacobs L-4MB

Engine model · Reciprocating · 245 hp · registry code 35030

Manufacturer (registry)
JACOBS
Model
L-4MB
Registry code
35030
Type
Reciprocating
Power
245 hp

Model codes come from the FAA registry’s reference file.

On this page

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 · 1

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 ('35030')
  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.

NTSB investigations · 1

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 1 case 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

Query with SQL
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 ('35030')
  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.

FAA incident reports · 1

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

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 ('35030')
  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.

Service difficulty reports · 1

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 = 'L4MB'
  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.