Skip to content

Registered aircraft · 790

Aircraft of this model 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 aircraft_model_code IN ('1181511')
  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 aircraft_model_code IN ('1181511')
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.

N100NJAlba Leasing Services LLC · Scottsdale, AZBuilt 1987 · S/N 3992 N101DGSummit Helicopters Inc · Salem, VABuilt 1986 · S/N 3929 N102NJUsda Forest Service Fepp · Trenton, NJBuilt 1975 · S/N 1671 N104APRock Creek Leasing LLC · Sapulpa, OKBuilt 1990 · S/N 4149 N104RLVertical Vegetation Management LLC · Darlington, INS/N 4315 N104TVFdfah LLC · Chula Vista, CABuilt 1978 · S/N 2379 N105APBearing Tree Land Surveying LLC · Oklahoma City, OKBuilt 1995 · S/N 4381 N105JDHavens Aviation LLC · Blacklick, OHBuilt 1973 · S/N 1105 N105LHHelilease LLC · Lewes, DEBuilt 1979 · S/N 2185 N105LPEnright Arne P Trustee · Ward Cove, AKBuilt 1980 · S/N 3068 N10699Smith James E Trustee · Kalispell, MTBuilt 1979 · S/N 2857 N106AMJasons Helicopter Services LLC · New Prague, MNBuilt 1974 · S/N 1384 N106JCTrans Peco Aviation LLC · Fort Stockton, TXBuilt 1982 · S/N 3622 N10729Sale Reported · Philomath, ORSale reported, canceledBuilt 1979 · S/N 2876 N1076GHenderson Aviation Co · Junction City, ORBuilt 1979 · S/N 2831 N1078QAris Leasing Inc · Sunnyvale, CABuilt 1978 · S/N 2425 N1079AN1079a LLC · Missoula, MTBuilt 1980 · S/N 2927 N107GGCarbon River Helicopter Services LLC · Lexington, KYBuilt 1980 · S/N 2917 N107PHSouthern Helicopter Service Inc · Millington, TNBuilt 1979 · S/N 2789 N1080NReynolds Aviation LLC · Wills Point, TXBuilt 1981 · S/N 3549 N1084XJefferson County Sheriffs Office · Birmingham, ALS/N 5170 N1085BDel Rio Aviation Inc · Paso Robles, CABuilt 1980 · S/N 2908 N108DRParamount International Inc · Millville, NJBuilt 1976 · S/N 1875 N108LHHelilease LLC · Lewes, DEBuilt 1978 · S/N 2426 N109DXSunwest Construction Enterprises Inc · Tarpon Springs, FLS/N 3489 N109RASunny Sky LLC · Stacyville, IABuilt 1979 · S/N 2741 N109USU S Helicopters Inc · Marshville, NCBuilt 1977 · S/N 2164 N10AJEl Aero Services LLC · Elko, NVBuilt 1980 · S/N 3169 N10KXWhirly Leasing Inc · Richvale, CABuilt 1975 · S/N 1628 N10MSKas Enterprises LLC · Lewes, DEBuilt 1980 · S/N 3208 N111BVOceanside Vertical Express LLC · Canaan, NYS/N 3264 N111HFPlane Fun Inc Tr Trustee · Snellville, GABuilt 1968 · S/N 208 N111PMTri Rotor Spray And Chemical · Ulysses, KSBuilt 1975 · S/N 1770 N112LPRanger Aviation Leasing LLC · Wilmington, DES/N 3403 N1158BAir Gov 1 LLC · Rome, NYBuilt 1996 · S/N 4431 N117HKSettan Corp · Goleta, CABuilt 1997 · S/N 4462 N118FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 1991 · S/N 4182 N118TVInterstate Helicopter Inc · Bethany, OKBuilt 1979 · S/N 2844 N11FHD H Helicopter Inc DBA · Sauget, ILBuilt 1993 · S/N 4270 N1219WMoes Crop Dusting Service Inc · Marysville, CABuilt 1975 · S/N 1843 N122BTNorth Wind Aviation LLC · Cottage Grove, ORBuilt 1989 · S/N 4053 N122JLotus Aviation LLC · Boring, ORBuilt 1976 · S/N 2035 N123WFJk Aviation LLC · Kerman, CAS/N 3058 N125TAGm Leasing Company LLC · Broussard, LABuilt 1974 · S/N 1315 N126SHKey West Helicopters LLC · Key West, FLBuilt 1974 · S/N 1269 N127APGm Leasing Co LLC · Broussard, LABuilt 1997 · S/N 4460 N12ATCustom Cub LLC · Keizer, ORBuilt 1974 · S/N 1329 N130CCAirone Helicopters LLC · Slaughter, LABuilt 1978 · S/N 2307 N130JHRanger Aviation Leasing LLC · Wilmington, DES/N 4166 N134MSSunny Sky LLC · Stacyville, IABuilt 1977 · S/N 2226

Back to Bell 206B