- Manufacturer (registry)
- CONNELL MICHAEL J
- Model
- ROTEC RALLY 3A
- Registry code
- 05647NR
- Registered
- 0 aircraft
- Type
- Fixed wing single engine
- Engines
- 1 · Reciprocating
- Seats
- 2
- Weight class
- Up to 12,499 lb
- Certification
- Not 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
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.
Cooper Jerry M ROTEC RALLY 3A1 registered aircraftReagan JR ROTEC RALLY 3A0 registered aircraftStickney Edward L ROTEC RALLY 3A0 registered aircraftHoule Albert J ROTEC RALLY 3A0 registered aircraftTomanek Robert T ROTEC RALLY 3A0 registered aircraftDixon Robert T ROTEC RALLY 3A0 registered aircraftNoble Brad ROTEC RALLY 3A0 registered aircraftPotter Nerl A ROTEC RALLY 3A0 registered aircraftPitcock Dan J ROTEC RALLY 3A0 registered aircraftRotec Ingineering ROTEC RALLY 3A0 registered aircraftRotec Engineering ROTEC RALLY 3A0 registered aircraftThomasson Donald ROTEC RALLY 3A0 registered aircraft
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 = 'ROTECRALLY3A' AND m.code NOT IN ('05647NR')
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 = 'ROTECRALLY3A' AND m.code NOT IN ('05647NR')
GROUP BY ALL
ORDER BY aircraft DESC
LIMIT 12Run 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.