Rolls-Royce 250-C47B
Registered aircraft · 536
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 ('54585')
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 ('54585')
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.
N372AMAir Methods LLC · Greenwood Village, CON374ALAir Methods LLC · Greenwood Village, CON377RSGm Leasing Co LLC · Broussard, LAN37ATCrosswind Leasing LLC · Prescott, AZN383AMAir Methods LLC · Greenwood Village, CON383STState Of Michigan Department Of State Police · Lansing, MIN384MLParagon Air Group · Fort Worth, TXN3914RRotorcraft Leasing Company LLC · Broussard, LAN398AMAir Methods LLC · Greenwood Village, CON39CLHelicopters Inc · Wilmington, DEN39KMFirst Flight Of Wyoming LLC · Billings, MTN3WVState Of West Virginia · Charleston, WVN400EEGore Nitrogen Pumping Service LLC · Seiling, OKN400PJHelibro LLC · Red Bluff, CAN401PHPhi Health LLC · Tempe, AZN401TDLeading Edge Aviation Inc · Bend, ORN402KTHelicopter Marketing Associates LLC · Colleyville, TXN402MAMinuteman Aviation Inc · Missoula, MTN402PDCity Of Omaha · Omaha, NEN402PHPhi Health LLC · Tempe, AZN403TDHfs Heli 1v LLC · New York, NYN404AMAir Methods LLC · Greenwood Village, CON404LHLohman Helicopter LLC · Lewiston, IDN404NCNorth Carolina State Highway Patrol · Cary, NCN404TDHfs Heli II LLC · New York, NYN405NCNorth Carolina State Highway Patrol · Cary, NCN405SWSw Aviation LLC · Norman, OKN407ARMed-Trans Corp · Denton, TXN407BBBravo Bravo LLC · Chandler, AZN407BEL J Associates Inc · Latrobe, PAN407BGAscendancy Aviation LLC · Melbourne Beach, FLN407BJ911 Aviation LLC · Durant, OKN407BMBravo Operations LLC · Newark, DEN407BUTms Aircraft Leasing LLC · Shreveport, LAN407CMSacramento Executive Helicopters Inc · Acampo, CAN407CNIntermountain Medical Transport LLC · Salt Lake City, UTN407DEPamoin 407 LLC · Brooklyn, NYN407DKPatagual Leasing LLC Trustee · Healdsburg, CAN407DTN407dt LLC · Missoula, MTN407DVMike Hotel Corp · Wilmington, DEN407FLSarasota County Sheriffs Office · Sarasota, FLN407FMIntermountain Medical Transport LLC · Salt Lake City, UTN407GPSacramento Executive Helicopters Inc · Acampo, CAN407GSWindsock Management LLC · Little Rock, ARN407GXBell Textron Inc · Fort Worth, TXN407HBRedding Air Service Inc · Redding, CAN407HDAlleghany Ridge LLC · Middletown, DEN407HKHawkeye Helicopter LLC · Lyndon, KSN407HPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN407JHSacramento Executive Helicopters Inc · Acampo, CA
Back to Rolls-Royce 250-C47B