Skip to content

Allison 250 SER 400HP

Registered aircraft · 136

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 ('03013', '03012')
  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 ('03013', '03012')
ORDER BY n_number

Run 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.

N102NJUsda Forest Service Fepp · Trenton, NJBuilt 1975 · S/N 1671 N1133CSara Helicopters Inc · Wilmington, DEBuilt 1974 · S/N 940636S N123RJR J Corman Railroad Co/Bardstown Line · Nicholasville, KYBuilt 1968 · S/N 148 N125TAGm Leasing Company LLC · Broussard, LABuilt 1974 · S/N 1315 N126SHKey West Helicopters LLC · Key West, FLBuilt 1974 · S/N 1269 N133AEAir Evac Ems Inc · O Fallon, MOBuilt 1979 · S/N 45280 N136JSBettencourt Flg Svc Inc · Atwater, CABuilt 1968 · S/N 136 N137MSKansas State University · Salina, KSBuilt 1979 · S/N 2686 N13WDGrayman Group LLC · Coeur D Alene, IDBuilt 1975 · S/N 150685S N1404WPendley Rory G · Torrance, CABuilt 1968 · S/N 298 N1435WFarwest Aviation LLC · Billings, MTS/N 916 N145LTLt Aviation LLC · Louisa, KYS/N 1880 N148KYCommonwealth Of Kentucky · Frankfort, KYBuilt 1975 · S/N 1795 N16760Riggs Bobby W · Lake Mary, FLBuilt 1977 · S/N 45081 N16770R & T Aviation LLC · Ethel, LABuilt 1977 · S/N 2147 N16832Orgis B J · Hallettsville, TXBuilt 1977 · S/N 2243 N1909RCenterline Holdings · Camden, DEBuilt 1976 · S/N 1909 N204SWybenga Aviation LLC · Twin Falls, IDBuilt 1975 · S/N 1742 N205PARidgeline Enterprises LLC · Twin Falls, IDBuilt 1976 · S/N 1996 N206BGMerced County Sherrifs Office · Merced, CABuilt 1972 · S/N 861 N206FTCreason Todd · Carrollton, MOBuilt 1978 · S/N 2539 N206KRHandy Air Inc · Douglas, GABuilt 1969 · S/N 437 N206LWStanislaus County Sheriffs Department · Modesto, CABuilt 1978 · S/N 45182 N206NUNorth Wind Aviation LLC · Chelan, WABuilt 1979 · S/N 2708 N206SHMc Helicopter LLC · Summerfield, FLBuilt 1975 · S/N 1666 N206WFBettencourt Flying Service Inc · Atwater, CABuilt 1973 · S/N 1135 N2192Flyers Enterprises Inc · Alpine, CABuilt 1977 · S/N 2192 N219SHRegistered aircraftBuilt 1974 · S/N 1532 N21MRMacy Robert S · Post, TXBuilt 1978 · S/N 2370 N250DEAkheli99 LLC · Anchorage, AKBuilt 1973 · S/N 999 N27574Ranger Aviation Leasing LLC · Wilmington, DEBuilt 1979 · S/N 2562 N27AEAir Evac Ems Inc · O Fallon, MOBuilt 1978 · S/N 45192 N27JBCape Gyro Inc · North Chatham, MABuilt 1973 · S/N 1026 N27UKOrlando Aircraft Sales LLC · Orlando, FLBuilt 1975 · S/N 1871 N28EDWilliams Management & Consulting Inc · Anacoco, LAS/N 2498 N28MLTre Aviation Corp · Wilmington, DEBuilt 1978 · S/N 1080362D N295CAChem-Air LLC · Shreveport, LABuilt 1976 · S/N 1929 N2FGRmc Aviation LLC · Klamath Falls, ORBuilt 1978 · S/N 2514 N307RDHelicopter Services Of Illinois LLC · Fisher, ILBuilt 1978 · S/N 2516 N316TVAero Products · Show Low, AZBuilt 1979 · S/N 2704 N322NBlue Sky LLC · Anchorage, AKS/N 1507 N352MCCitrus County Mosquito Control District · Lecanto, FLBuilt 1973 · S/N 1131 N35RPB & B Investments Inc · Yucaipa, CAS/N 1431 N362MNHeli Ag LLC · Plantersville, TXBuilt 1979 · S/N 390462D N363CCBank Of Utah Trustee · Salt Lake City, UTBuilt 1977 · S/N 1070208D N363JSWilson Robert B · Superior, AZBuilt 1973 · S/N 930517S N369MPAviation Advantage Inc · Tabor City, NCBuilt 1977 · S/N 670150D N36MKHorizon Helicopters Inc · Newark, DEBuilt 1974 · S/N 1360 N37AJL&R Investment Partners LLC · Wilmington, DES/N 1877 N400UCPacific Rotors Inc · Oceanside, CABuilt 1974 · S/N 1407

Back to Allison 250 SER 400HP