Rolls-Royce 250-C20B
Registered aircraft · 216
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 ('54385')
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 ('54385')
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.
N4237MTrideca Vertical Solutions LLC · Dallas, TXN4265JRatcliff Dustin · Saltville, VAN431CAChem-Air LLC · Shreveport, LAN432TVSky Choppers LLC · Seneca, KSN458HWHeliwild Investments LLC · Austin, TXN473EOchoco Wood Products LLC · Prineville, ORN478NWTmds Air Inc · Gig Harbor, WAN479DBAmerican Honor Foundation Inc · Ocala, FLN483RVan Horn Aviation LLC · Tempe, AZN48MPPope James D · Lewiston, IDN499SLHlh Leasing LLC · Wilmington, DEN49WKRail N LLC · Oracle, AZN500LKWinco Inc · Aurora, ORN500MUHva Inc · Summersville, WVN500TNOnespan Powerline Services LLC · Peachtree City, GAN500WXTre Aviation Corp · Wilmington, DEN501TATomlinson Aviation Inc · Ormond Beach, FLN504LRAviation Company Inc · Cheyenne, WYN504SLSouth Carolina Law Enforcement Division · Columbia, SCN508XSSouthern Aircraft Consultancy Inc Trustee · Casper, WYN50XBRwb 66 LLC · Victoria, TXN510PACedar Helicopters LLC · Shelton, WAN514PAAa Leasing Lp · Kilauea, HIN516BRichey Bradly L · Chico, TXN518PAPatriot Aviation Inc · Greenville, DEN51MNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN525ZDg&R LLC · Murray, UTN5277FCity Of Houston · Houston, TXN5278FCity Of Houston · Houston, TXN5279FCity Of Houston · Houston, TXN5280FCity Of Houston · Houston, TXN5284FCity Of Houston · Houston, TXN528HPCollective Ag LLC · Osceola, NEN52RDHelicopter Services West LLC · Benicia, CAN530FCFerguson And Sons Construction · Emmett, IDN533DRLt Aviation LLC · Lexington, KYN533RAEnglish Air Service LLC · Georgetown, TXN537TMbm Aviation Consultants Inc · Wilmington, DEN53MAAg Air Inc · Johnstown, CON549VSVertol Systems Co Inc · Destin, FLN556CPCity Of Columbus · Columbus, OHN556MHAa Leasing Lp · Kilauea, HIN56BLHelicopters Inc · Cahokia, ILN572SABank Of Utah Trustee · Salt Lake City, UTN5743GBcww LLC · Bakersfield, CAN58251Windward Aviation Inc · Puunene, HIN582RAMarks Assets Group LLC · Lafayette, LAN59548Hendrickson Flying Service Inc · Rochelle, ILN59564Sale Reported · Topeka, KSSale reportedN59CPRegistration Pending · Phoenix, AZRegistration pending
Back to Rolls-Royce 250-C20B