Ross Charles E ODYSSEY airworthiness directives

Manufacturer (registry): ROSS CHARLES E
Model: ODYSSEY
Registry code: 05904PP
Registered: 0 aircraft
Type: Fixed wing single engine
Engines: 1 · 4 cycle
Seats: 2
Weight class: Up to 12,499 lb
Certification: Light sport

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

On this page

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

No aircraft currently registered with this model

NTSB investigations

No NTSB investigations matched to aircraft with this modelMatched through the registry by N-number, so foreign aircraft and some older cases aren’t counted.

FAA incident reports

No reports matched to aircraft of this modelMatched through the registry by N-number, so foreign aircraft and some older reports aren’t counted.

Service difficulty reports

No reports name this modelGeneral aviation reporting is voluntary.

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 = 'ODYSSEY' AND m.code NOT IN ('05904PP')
  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.

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 = 'ODYSSEY' AND m.code NOT IN ('05904PP')
GROUP BY ALL
ORDER BY aircraft DESC
LIMIT 12

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.