Skip to content

Registered aircraft · 158

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 ('2073301', '2073307')
  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 ('2073301', '2073307')
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.

N102AKRegistered aircraftBuilt 2006 · S/N 20608264 N103SJBarnick Air Holdings LLC · Santa Barbara, CABuilt 2000 · S/N 20608101 N10457Six Ten Ventures LLC · Cedar Hill, TXBuilt 2003 · S/N 20608194 N1074XKelley Air LLC · Milford, MIBuilt 2005 · S/N 20608233 N108CTDepartment Of Homeland Security · Washington, DCBuilt 2004 · S/N 20608212 N10CXAlameda County Sheriffs Office · Livermore, CAS/N 20608082 N1123FUrsus Air Services · Anchorage, AKBuilt 2002 · S/N 20608173 N11379Bas Part Sales LLC · Greeley, COBuilt 1999 · S/N 20608077 N1155PN1155p Corp Trustee · Wilmington, DEBuilt 2003 · S/N 20608193 N125MDMaryland Aviation Administration · Bwi Airport, MDBuilt 2000 · S/N 20608099 N12730Silver Creek Aviation Services · Fort Worth, TXBuilt 2007 · S/N 20608302 N131WCVoigt Aviation Inc · Park Rapids, MNS/N 20608034 N132PSU S Department Of The Interior · Boise, IDS/N 20608278 N1338BSilver Creek Aviation Services · Fort Worth, TXBuilt 2011 · S/N 20608331 N137PFerguson Frampton Z · Furman, SCS/N 20608304 N139SAMississippi Forestry Commission · Pearl, MSBuilt 2003 · S/N 20608195 N157HFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 20608228 N158PAndry Holdings LLC · Missoula, MTBuilt 2008 · S/N 20608306 N181SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 20608192 N183MERegistration Pending · Page, AZRegistration pendingBuilt 2000 · S/N 20608107 N188MESenior Mi LLC · Batavia, ILBuilt 2000 · S/N 20608108 N193PNc Wildlife Resources Commission Enforcement Div · Raleigh, NCBuilt 2008 · S/N 20608307 N196SA3d Capture LLC · Beaumont, TXBuilt 2003 · S/N 20608197 N202BWCoastal Defense Inc · Mill Hall, PABuilt 2000 · S/N 20608088 N2061BM R O Drug Test Results LLC · Wintersville, OHBuilt 2003 · S/N 20608200 N206BCSkelton Thomas N · Madison, MSBuilt 1999 · S/N 20608025 N206CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 20608227 N206FNFlying Neutrons LLC · Lebanon, OHBuilt 1999 · S/N 20608026 N206GCCook Tyler · Seldovia, AKBuilt 2002 · S/N 20608001 N206JAFabick John D · Saint Louis, MOBuilt 1999 · S/N 20608014 N206KMHoskins Marc R · Kennett, MOBuilt 2001 · S/N 20608153 N206LBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 20608055 N206MXFrogfeet LLC · BarcelonaBuilt 2001 · S/N 20608149 N206SBCounty Of Santa Barbara · Santa Barbara, CAS/N 20608167 N206ZB16d LLC · Vashon, WABuilt 2006 · S/N 20608276 N213SMArrowhawk Imaging LLC · Morgantown, WVBuilt 2003 · S/N 20608206 N2163SOlde Towne Transport LLC · Beaufort, NCBuilt 2007 · S/N 20608285 N2167PTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 20608217 N2175QTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 20608191 N21787Birch Jerome I Trustee · Anchorage, AKS/N 20608215 N220DETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 20608241 N223HCG206 LLC · San Juan, PRBuilt 2006 · S/N 20608269 N226LSilver Creek Aviation Services · Fort Worth, TXBuilt 2004 · S/N 20608226 N229ESilver Creek Aviation Services · Fort Worth, TXBuilt 2005 · S/N 20608229 N234USouthwest Aviation Enterprises · Haslet, TXBuilt 2005 · S/N 20608230 N2360ARegistration Pending · Cedar Falls, IARegistration pendingS/N 20608016 N237CADepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608239 N23802Gherst Richard H · Seattle, WABuilt 2000 · S/N 20608137 N238DSilver Creek Aviation Services · Fort Worth, TXBuilt 2005 · S/N 20608238 N242MEMike Echo Ventures LLC · Coral Gables, FLBuilt 2000 · S/N 20608112

Back to Cessna 206H