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.

N206RMPadgett Farms And Forestry LLC · Milan, GABuilt 1974 · S/N 1566 N206RVTaylor Made Aircraft Co LLC · Broomfield, COBuilt 1981 · S/N 3230 N206RYEast Tennessee Helicopters Inc · Butler, TNBuilt 1979 · S/N 2807 N206SAGarlick Joyce M · Hamilton, MTBuilt 1973 · S/N 1013 N206SFAlpha Echo Leasing LLC · Sedona, AZBuilt 1978 · S/N 2392 N206SHMc Helicopter LLC · Summerfield, FLBuilt 1975 · S/N 1666 N206SWCounty Of Ocean · Barnegat, NJS/N 4091 N206TATomlinson Aviation Inc · Ormond Beach, FLBuilt 1981 · S/N 3319 N206TGGallien Anthony · Livermore, CABuilt 1979 · S/N 2610 N206THRanger Aviation Leasing LLC · Wilmington, DEBuilt 1975 · S/N 1736 N206TRZma LLC · North Little Rock, ARBuilt 1979 · S/N 2808 N206TWAltitude Solutions LLC · Kalispell, MTBuilt 1978 · S/N 2403 N206WAChem Air LLC · Shreveport, LABuilt 1980 · S/N 3037 N206WFBettencourt Flying Service Inc · Atwater, CABuilt 1973 · S/N 1135 N206WGWorld Golf LLC · Charles City, VABuilt 1979 · S/N 2833 N206XZSunwest Construction Enterprises Inc · Tarpon Springs, FLS/N 3645 N206YTRocky Mountain Grading LLC · Alamo, NVBuilt 1980 · S/N 3126 N206ZZAv Enterprises Inc · Bozeman, MTBuilt 1997 · S/N 4459 N207DHAirone Helicopters LLC · Slaughter, LABuilt 1983 · S/N 3772 N207TVMidcoast Helicopter Inc · La Ward, TXBuilt 1979 · S/N 2696 N208AGAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 1853 N208ERAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2000 · S/N 4527 N209SKalispell Corp · Wilmington, DEBuilt 1981 · S/N 3511 N20WYKelly Sean R · Bozeman, MTBuilt 1979 · S/N 2647 N211CSWithrotor Aviation Inc · Lakeview, ORS/N 2775 N212SPAirman Helicopter Inc · Fort Lauderdale, FLBuilt 1976 · S/N 2043 N213PDDrb Helicopters LLC · Klamath Falls, ORBuilt 1976 · S/N 1992 N21470Southwest Heliservices LLC · Mesa, AZS/N 3467 N21507Steuben Foods Inc · Elma, NYBuilt 1981 · S/N 3464 N2155ZHeli Incorporated · Las Vegas, NVBuilt 1981 · S/N 3476 N217HKHolden Thomas J · Warrington, PABuilt 1995 · S/N 4347 N217JSOceanside Vertical Express LLC · Canaan, NYBuilt 1981 · S/N 3454 N2183YRegistered aircraftBuilt 1981 · S/N 3519 N2187LRanger Aviation Leasing LLC · Wilmington, DEBuilt 1981 · S/N 3497 N2192Flyers Enterprises Inc · Alpine, CABuilt 1977 · S/N 2192 N2193XIndustrial Helicopters LLC · Lafayette, LAS/N 3506 N2196JIron Horse Cub LLC · Arlington, TXBuilt 1981 · S/N 3513 N219SHRegistered aircraftBuilt 1974 · S/N 1532 N21MRMacy Robert S · Post, TXBuilt 1978 · S/N 2370 N21MWAir Flite Inc · Shawnee, OKBuilt 1982 · S/N 3585 N21RTL&R Investment Partners LLC · Wilmington, DES/N 2659 N220GPRotorheads Leasing LLC · Perham, MNBuilt 1991 · S/N 4196 N220SASpurger Aviation LLC · Spurger, TXBuilt 1969 · S/N 476 N221GPChemair Helicopters Inc · Jefferson, WIBuilt 1994 · S/N 4309 N222HAJasons Helicopter Services · New Prague, MNBuilt 1974 · S/N 1316 N224EESutton James Donald · Turkey, NCBuilt 2004 · S/N 4576 N224KMStatzel Steve DBA · New Haven, MOS/N 1124 N225PDBaton Rouge Police Department · Baton Rouge, LABuilt 1994 · S/N 5162 N2268GCrm Investments Inc · Wilmington, NCBuilt 1982 · S/N 3603 N2268WChorman Spraying LLC · Milton, DEBuilt 1982 · S/N 3606

Back to Bell 206B