Lake LA-4-200

Aircraft model · Fixed wing single engine · Airplane · registry code 5110310

Manufacturer (registry)
LAKE
Model
LA-4-200
Registry code
5110310
Registered
91 aircraft
Type
Fixed wing single engine
Engines
1 · Reciprocating
Seats
4
Weight class
Up to 12,499 lb
Cruise speed
91 mph
Certification
Type certificated

Model codes come from the FAA registry’s reference file. ADs are matched to them by model name and maker.

On this page

Aircraft by year built · 144

1970Registered nowDeregistered2026
Aircraft by the year they were built: 144 aircraft
19707
197119
197219
197323
197428
197517
19762
19771
19782
19802
19814
19821
198310
19846
19891
19981
20161

Airworthiness directives that may apply · 0

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

No ADs matched this model

Registered aircraft · 91

See all 91 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 aircraft_model_code IN ('5110310')
  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 · 71

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

See all 71 investigations
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.aircraft_model_code IN ('5110310')
  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 · 121

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

See all 121 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 aircraft_model_code IN ('5110310')
  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 · 39

See all 39 difficulty reports
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 aircraft_model_key = 'LA4200'
  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.

The same model under other registry codes

Amateur-built copies and renamed makers get their own codes.

Query with SQL
duckdb -csv -c "SELECT m.code, m.manufacturer, m.model, count(g.n_number) AS aircraft
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g ON g.aircraft_model_code = m.code
  WHERE m.match_key = 'LA4200' AND m.code NOT IN ('5110310')
  GROUP BY ALL
  ORDER BY aircraft DESC
  LIMIT 12"

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.