Skip to content

Rotorway RW-100 series

Registered aircraft · 18

Aircraft with this engine in the FAA registry, by N-number.

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

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 ('55001')
ORDER BY n_number

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.

N102RWKomko Randy M · Mckenna, WABuilt 1982 · S/N 001 N162FPDenman Kenneth R · Marysville, OHS/N 3717 N162FWEpps Marcus V · Phenix City, ALBuilt 2005 · S/N 6848 N162MRSpivey Darwyn D · Guntersville, ALS/N 6009 N162RTR&S Enterprises DBA · Fort Wayne, INBuilt 1995 · S/N 6059 N171WPovolny Henry R · Elmore, OHBuilt 2009 · S/N 01249 N22614Harris C Mark · Litchfield, OHS/N 5250 N256RWRogers Charles W · Bay Saint Louis, MSBuilt 2004 · S/N 6734 N3019UCollins Jay F · Olive Hill, KYBuilt 1994 · S/N 6008 N494DStanley Randel L · Pilot Mountain, NCBuilt 2005 · S/N 6567 N501WHRivera Jaime · San Antonio, TXBuilt 2002 · S/N 6613 N811Azevedo Antonio De Costa · Virginia Beach, VABuilt 1995 · S/N 6070 N812GWVa Office Of Emergency Servico · Hampton, VABuilt 1995 · S/N 5136 N8206XJet-Copter LLC · Holmen, WIBuilt 2017 · S/N 6985 N84GBWarnock Tony J · Mobile, ALBuilt 1984 · S/N 1 N8509AElliott Patrick K · North Bend, ORBuilt 1981 · S/N DC-002 N87EXGautsch Mike J · Onalaska, WIBuilt 2005 · S/N 6709 N999BHBhi Aviation LLC · Hudson, IABuilt 1999 · S/N 6267

Back to Rotorway RW-100 series