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.
N229AMAir Methods LLC · Greenwood Village, CON229SFN179sf LLC · Chandler, AZN233JSCreekside Aviation LLC · Nashville, NCN241MTMed-Trans Corp · Denton, TXN242MTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN246AMAir Methods LLC · Greenwood Village, CON24NRGeorgia Department Of Natural Resources · Atlanta, GAN24NYHeliinc LLC · Wilmington, DEN253HBank Of Utah Trustee · Salt Lake City, UTN2592TBrown Helicopter Inc · Pensacola, FLN26NRGeorgia Department Of Natural Resources · Atlanta, GAN26VAVirginia State Police · Richmond, VAN278AMAir Methods LLC · Greenwood Village, CON280LBBell Textron Inc · Fort Worth, TXN284AMAir Methods LLC · Greenwood Village, CON284SPKentucky State Police · Frankfort, KYN2869FSilver Creek Aviation Services · Fort Worth, TXFirst renewal noticeN286GJambb LLC · La Verne, CAN28LLHelicopters Inc · Wilmington, DEN292AMAir Methods LLC · Greenwood Village, CON293AMAir Methods LLC · Greenwood Village, CON294VMGm Leasing Co LLC · Broussard, LAN301LELifeflight Eagle · Kansas City, MON302LELifeflight Eagle · Kansas City, MON3050SAr Aviation Group LLC · Springfield, ORN308MHMaritime Helicopters Inc · Homer, AKN309LWStraight Up Leasing Inc · Medford, ORN309MHMaritime Helicopters Inc · Homer, AKN30HFN179sf LLC · Chandler, AZN312MHMaritime Helicopters Inc · Homer, AKN312STState Of Michigan · Lansing, MIN314JPCity Of Jacksonville · Jacksonville, FLN314SFN179sf LLC · Chandler, AZN319MHMaritime Helicopters Inc · Homer, AKN325MHMaritime Helicopters Inc · Homer, AKN330BCBell Textron Inc · Fort Worth, TXN338AMAir Methods LLC · Greenwood Village, CON348ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN349ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN34TP307 Air Medical Transportation LLC · Clovis, NMN352HRJoe H Anderson Jr & Sons Inc · Old Town, FLN352MHMaritime Helicopters Inc · Homer, AKN353HKHkb Global Supply LLC · Wilmington, DEN3546TStraight Up Leasing Inc · Medford, ORN355MHMaritime Helicopters Inc · Homer, AKN356MHMaritime Helicopters Inc · Homer, AKN357AMAir Methods LLC · Greenwood Village, CON366SPNew Hampshire State Police · Concord, NHN369PAGm Leasing Co LLC · Broussard, LAN372ALAir Methods LLC · Greenwood Village, CO
Back to Rolls-Royce 250-C47B