Douglas DC3

Aircraft model · Fixed wing multi engine · Airplane · registry code 3021401

Manufacturer (registry)
DOUGLAS
Model
DC3
Registry code
3021401
Registered
32 aircraft
Type
Fixed wing multi engine
Engines
2 · Turbo-prop
Seats
32
Weight class
20,000 lb and over
Cruise speed
174 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 · 154

1936Registered nowDeregistered2026
Aircraft by the year they were built: 154 aircraft
19364
193710
19381
19395
194013
19419
194224
194326
194414
19458
19466
19471
19493
19523
19531
19541
19551
19565
19591
19631
19681
19691
19732
19762
19793
19803
19812
19891
19932

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

See all 32 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 ('3021401')
  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.

STCs approved for this model · 110

See all 110 STCs
Query with SQL
duckdb -csv -c "SELECT s.stc_number, s.description, s.holder, s.status, s.status_date
  FROM 'https://openairdocs.org/data/latest/faa_stc.parquet' s
  WHERE s.stc_number IN (SELECT stc_number FROM 'https://openairdocs.org/data/latest/faa_stc_model.parquet' WHERE model_key = 'DC3')
  ORDER BY s.status = 'Current' DESC, s.stc_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 · 52

Aircraft matched to this model through the registry, by N-number and event date.

See all 52 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 ('3021401')
  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 · 53

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

See all 53 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 ('3021401')
  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 · 20

See all 20 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 = 'DC3'
  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.