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.
N407JMIntermountain Medical Transport LLC · Salt Lake City, UTN407JPTango Pop LLC · Wayzata, MNN407JRInternational Air Services Inc Trustee · Carson City, NVN407JTSacramento Executive Helicopters Inc · Acampo, CAN407JVJvc Aviation LLC · Friendsville, PAN407KD7 Roofing LLC · New Baden, ILN407KGAircraft Trustee Services Inc Trustee · Dover, DEN407KSKing County Sheriffs Office · Seattle, WAN407KYRed River Ranch LLC · Wilmington, DEN407LBN888lb LLC · Boca Raton, FLFirst renewal noticeN407LDManatee County Mosquito Control District · Ellenton, FLN407LFClassic Medical Inc · Salt Lake City, UTN407LGHelo Holdings LLC · Fort Worth, TXN407LHLohman Helicopter LLC · Lewiston, IDN407LMOrange County Sheriffs Office · Orlando, FLN407LPIntermountain Medical Transport LLC · Salt Lake City, UTN407LQTilden Helicopter Services LLC · San Antonio, TXN407LSAir Methods LLC · Greenwood Village, CON407MAMetro Aviation Inc · Shreveport, LAN407MMLucky Man LLC · Missoula, MTN407MPFliteworks Aviation LLC · Houston, TXN407MSBank Of Utah Trustee · Salt Lake City, UTN407MTAlmax LLC · Wilmington, DEN407NAFlagstaff Medical Center Inc · Flagstaff, AZN407NCNc Highway Patrol · Cary, NCN407NLOrange County Sheriff'S Office · Orlando, FLN407PPhi Health LLC · Tempe, AZN407PAMaritime Helicopters Inc · Homer, AKN407PFBell Textron Inc · Fort Worth, TXN407PGRedding Air Service Inc · Redding, CAN407RATranspais Aviation LLC · Salt Lake City, UTN407RERegistered aircraftN407RFFlagstaff Medical Center · Flagstaff, AZN407RHMaritime Helicopters Inc · Homer, AKN407RJDixon John W · Asotin, WAFirst renewal noticeN407RLHillsboro Aviation Inc · Hillsboro, ORN407RMGarriott Robert · Austin, TXN407RRRains Ronald D · Odessa, TXN407RWSacremento Executive Helicopters Inc · Acampo, CAN407RXBank Of Utah Trustee · Salt Lake City, UTN407SAAlabama Law Enforcement Agency · Montgomery, ALN407SETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN407SFN390sf LLC · Chandler, AZN407SGSlg Utah LLC · Toquerville, UTFirst renewal noticeN407SHStanislaus County · Modesto, CAN407SSState Of Indiana · Indianapolis, INN407TDElkhorn Aviation Inc · Baker City, ORN407TFTag Aviation LLC · Casper, WYN407THIntermountain Medical Transport LLC · Salt Lake City, UTN407TKIntermountain Medical Transport LLC · Salt Lake City, UT
Back to Rolls-Royce 250-C47B