Skip to content

Registered aircraft · 371

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 ('1182206')
  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 ('1182206')
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.

N10LESlws LLC · Missoula, MTBuilt 2003 · S/N 53556 N118SPMinnesota State Patrol · Saint Paul, MNBuilt 2005 · S/N 53646 N11SPState Of New York · Albany, NYBuilt 2002 · S/N 53530 N125WHWestwind Helicopters Inc · Santa Fe, TXBuilt 2000 · S/N 53411 N12CTCt Air LLC · Clovis, NMBuilt 2006 · S/N 53743 N12HXHelicopter Express LLC · Chamblee, GABuilt 2000 · S/N 53415 N137PDPuerto Rico Police Department · San Juan, PRBuilt 2000 · S/N 53431 N138PDPuerto Rico Police Department · San Juan, PRBuilt 2004 · S/N 53630 N139PDPuerto Rico Police Dept · San Juan, PRBuilt 2004 · S/N 53631 N140HLGm Leasing Company LLC · Broussard, LABuilt 2003 · S/N 53575 N1416Gm Leasing Company LLC · Broussard, LAS/N 53110 N141APGm Leasing Co LLC · Broussard, LABuilt 2000 · S/N 53441 N142MAMinuteman Aviation Inc · Missoula, MTBuilt 1996 · S/N 53123 N144MAMinuteman Aviation Inc · Missoula, MTBuilt 1998 · S/N 53255 N14HXHelicopter Express LLC · Chamblee, GABuilt 1997 · S/N 53184 N1612Gm Leasing Co LLC · Broussard, LABuilt 1996 · S/N 53044 N163RLRotorcraft Leasing Company LLC · Broussard, LAS/N 53163 N164RLRotorcraft Leasing Company LLC · Broussard, LABuilt 1997 · S/N 53140 N165SPSouthern Utah University · Cedar City, UTBuilt 2000 · S/N 53458 N168TBSouthwest Aviation Enterprises · Haslet, TXBuilt 2000 · S/N 53434 N16SPState Of New York · Albany, NYBuilt 2002 · S/N 53532 N171WHWestwind Helicopters Inc · Santa Fe, TXBuilt 1997 · S/N 53149 N175PAMansfield Helifight · Milton, VTBuilt 1997 · S/N 53154 N17DEBell Textron Inc · Fort Worth, TXBuilt 2006 · S/N 53700 N17SPNew York State Police · Albany, NYBuilt 2000 · S/N 53444 N184SFGm Leasing Co LLC · Broussard, LABuilt 1996 · S/N 53087 N18BHAbc Helicopters Inc · Jefferson, WIBuilt 1997 · S/N 53217 N18DBN87bb LLC · Monroe, NCS/N 53165 N18SPState Of New York · Albany, NYBuilt 2002 · S/N 53533 N1903ADale County Sheriffs Office · Ozark, ALBuilt 2001 · S/N 53475 N203HAHelo N203ha LLC · Richmond, VABuilt 1996 · S/N 53023 N206TLTurbines Ltd · West Point, NES/N 53589 N207SJSan Juan Aviation LLC · Wilmington, DES/N 53721 N20BHChemair Helicopters Inc · Jefferson, WIBuilt 1998 · S/N 53242 N20WHGulf Helicopters LLC · Santa Fe, TXBuilt 1999 · S/N 53377 N218BHOsceola County Sheriffs Office · Kissimmee, FLBuilt 2006 · S/N 53704 N219BHOsceola County Sheriffs Office · Kissimmee, FLBuilt 2002 · S/N 53525 N21BHChemair Helicopters Inc · Jefferson, WIBuilt 1998 · S/N 53262 N21CLHelicopters Inc · Linden, NJBuilt 2002 · S/N 53536 N225FMCoastal Investments Inc · Wilmington, DEBuilt 2000 · S/N 53425 N229SFN179sf LLC · Chandler, AZBuilt 2005 · S/N 53652 N2592TBrown Helicopter Inc · Pensacola, FLBuilt 2007 · S/N 53748 N262KBSkytoyz Enterprises LLC · Loveland, COBuilt 1999 · S/N 53380 N267SFN179sf LLC · Chandler, AZBuilt 1996 · S/N 53102 N26CHCoastal Air Service Inc · Panama City, FLBuilt 1998 · S/N 53312 N26VAVirginia State Police · Richmond, VABuilt 2006 · S/N 53688 N27HXHelicopter Express LLC · Chamblee, GABuilt 1996 · S/N 53012 N284SPKentucky State Police · Frankfort, KYBuilt 2005 · S/N 53655 N2869FSilver Creek Aviation Services · Fort Worth, TXBuilt 2004 · S/N 53623 N286GJambb LLC · La Verne, CABuilt 1996 · S/N 53042

Back to Bell 407