Rolls-Royce 250-C47E/4
Registered aircraft · 182
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 ('54236')
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 ('54236')
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.
N407DADillon Aero Inc · Scottsdale, AZN407ESDarana Aviation Services LLC · Hamilton, OHN407GMBell Textron Inc · Fort Worth, TXN407GRGrand River Dam Authority · Tulsa, OKN407HCAir Methods LLC · Greenwood Village, CON407HFHalo-Flight Inc · Corpus Christi, TXN407JFJuliet Foxtrot LLC · Scott City, KSN407JJQuiktrip Corp · Tulsa, OKN407LWLewis Aeronautical LLC · San Antonio, TXN407MJFlying Barefoot Ranch LLC · Wilmington, DEN407MZIntermountain Medica Transport LLC · Salt Lake City, UTN407NPAviation Trust Company LLC Trustee · Oklahoma City, OKN407NWIntermountain Medical Transport LLC · Salt Lake City, UTN407PBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN407PMHc 407 LLC · Missoula, MTN407PWIntermountain Medical Transport LLC · Salt Lake City, UTN407RUIntermountain Medical Transport LLC · Salt Lake City, UTN407SLIntermountain Medical Transport LLC · Salt Lake City, UTN407TJAdair Jay · Dallas, TXN407VCBell Textron Inc · Fort Worth, TXN407WDBrask T-4 Equipment LLC · Gallatin Gateway, MTN407WTSeaguard Aviation LLC · Kalispell, MTN408LFLife Flight Network LLC · Aurora, ORN408TVTennessee Valley Authority · Muscel Shoals, ALN40DNBank Of Utah Owner Trustee 11/20/2023 · Salt Lake City, UTN410LFLife Flight Network LLC · Aurora, ORN412LFLife Flight Network LLC · Aurora, ORN414LFLife Flight Network LLC · Aurora, ORN422CTKing County Sheriffs Office · Seattle, WAN424LFLife Flight Network LLC · Aurora, ORN430CCCharleston County Sheriffs Office · North Charleston, SCN4338GSouthwest Aviation Enterprises · Haslet, TXN43BRHighland Paving Co LLC · Fayetteville, NCN441LFLife Flight Network LLC · Aurora, ORN443LFLife Flight Network LLC · Aurora, ORN445LFLife Flight Network LLC · Aurora, ORN447LXSafe Aviation Leasing LLC · Lakeland, FLN449LFLife Flight Network LLC · Aurora, ORN450LFLife Flight Network LLC · Aurora, ORN451LFLife Flight Network LLC · Aurora, ORN452LFLife Flight Network LLC · Aurora, ORN453LFLife Flight Network LLC · Aurora, ORN455LFLife Flight Network LLC · Aurora, ORN455PDCharlotte Mecklenburg Police Department · Charlotte, NCN456LFLife Flight Network LLC · Aurora, ORN458LFLife Flight Network LLC · Aurora, ORN460WMSouth Florida Water Mgmt District · West Palm Beach, FLN462LFLife Flight Network LLC · Aurora, ORN463LFLife Flight Network LLC · Aurora, ORN465BMWe High LLC · Colleyville, TX
Back to Rolls-Royce 250-C47E/4