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.
N407TXAir Methods LLC · Greenwood Village, CON407VSKalispell Regional Medical Center · Kalispell, MTN407WFBell 407 LLC · Bend, ORN407WHScouts Rest Ranch LLC · Darby, MTN407XLExecutive Transport Group Inc · Las Vegas, NVN407ZMIntermountain Medical Transport LLC · Salt Lake City, UTN408CCCounty Of Contra Costa · Martinez, CAN408GGHfs Heli III LLC · New York, NYN408GMBostick Bowers Padgett Ltd · Jackson, GAN408LMAir Methods LLC · Greenwood Village, CON408LNAir Methods LLC · Greenwood Village, CON408PJHelibro LLC · Red Bluff, CAN408SHAir Methods LLC · Greenwood Village, CON408SK911 Aviation LLC · Durant, OKN408UHUniversity Of Utah · Salt Lake City, UTFirst renewal noticeN408UTMed-Trans Corp · Denton, TXN409APA&P Helicopters Inc · Richvale, CAN409GAFlagstaff Medical Center Inc · Flagstaff, AZN409LMAir Methods LLC · Greenwood Village, CON409PHPhi Health LLC · Tempe, AZN409PJHelibro LLC · Red Bluff, CAN409TDCastle Black Aviation LLC · Manati, PRN40KDZero Kilodelta LLC · Littleton, NCN40VRSanctuary Partners LLC · Ball Ground, GAN410APA&P Helicopters Inc · Richvale, CAN410PHPhi Health LLC · Tempe, AZN410TD407 Partners LLC · Bend, ORN411PHPhi Health LLC · Tempe, AZN411PJHelibro LLC · Red Bluff, CAN411PRWindsock Management LLC · Little Rock, ARN411UHUniversity Of Utah · Salt Lake City, UTN412CFCareflite · Grand Prairie, TXN412PPhi Health LLC · Tempe, AZN412PHPhi Aviation LLC · Lafayette, LAN412UHMetro Aviation Inc · Shreveport, LAN413UHMetro Aviation Inc · Shreveport, LAN4144CTen Point Tours Inc · Nashville, TNN414PJHelibro LLC · Red Bluff, CAN414UHMetro Aviation Inc · Shreveport, LAN416CFCareflite · Grand Prairie, TXN416SFN390sf LLC · Chandler, AZN417CFCareflite · Grand Prairie, TXN417USCrosswind Leasing LLC · Prescott, AZN418CFCareflite · Grand Prairie, TXN418PHPhi Aviation LLC · Lafayette, LAN418PJHelibro LLC · Red Bluff, CAN419CFCareflite · Grand Prairie, TXN419PPhi Health LLC · Tempe, AZN41TLTurbines Ltd · West Point, NEN420GAFlagstaff Medical Center Inc · Flagstaff, AZ
Back to Rolls-Royce 250-C47B