Rolls-Royce 250-C20J
Registered aircraft · 82
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 ('54181')
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 ('54181')
ORDER BY n_numberRun 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.
N67130Mf Helicopters LLC · East Troy, WIN67176Kootenai County Regional Air Support · Hayden, IDN67183State Of Louisiana · Baton Rouge, LAN67235Brown Helicopter Inc · Pensacola, FLN67269Usda Aphis Ws · Cedar City, UTN67301Mf Helicopters LLC · East Troy, WIN67328Realstaff Rocket LLC · Salem, ORN67347Usda Aphis Ws Atoc · Cedar City, UTN67516Coastal Helicopters Inc · Panama City, FLN67569Anastasia Mosquito Control District · Saint Augustine, FLN67572Aircraft Guaranty Corp Trustee · Oklahoma City, OKN67961Brown Helicopter Inc · Pensacola, FLN682BHBa Group LLC · Glastonbury, CTN707MKSch Aviation Inc Trustee · NorfolkN744TVU S Helicopters Inc · Marshville, NCN7508PReece Michael · Marathon, FLN762LCLeon County Sheriffs Office · Tallahassee, FLN76TLJ L Smith Enterprises LLC · Jackson, KYN770HPDodson International Parts Inc · Rantoul, KSN78BRMontana Air Tankers LLC · Three Forks, MTN803JBGuardian Aero LLC · Flora, ILN83APL&R Investment Partners LLC · Wilmington, DEN83TJGotcher Corby W · West Columbia, TXN885MCPolk County · Bartow, FLN911UUKottman Marvin G · West Point, NEN93LLHelicopters Inc · Linden, NJN946MBemer Aviation Inc · Glastonbury, CTN94XAXtreme Aviation LLC · Falkville, ALN953AZRight Brother Aviation LLC · Chaffee, NYN954TJTx Investments LLC · Fort Lauderdale, FLN95LPPanther Helicopters Inc · Belle Chasse, LAN981RHFly Hangar 13 LLC · Mico, TX
Back to Rolls-Royce 250-C20J