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.

N612BKKqm Aviation · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 20608325 N6187YSilver Creek Aviation Services · Fort Worth, TXBuilt 2008 · S/N 20608309 N6188BSilver Creek Aviation Services · Fort Worth, TXBuilt 2008 · S/N 20608310 N6188QSilver Creek Aviation Services · Fort Worth, TXBuilt 2008 · S/N 20608305 N631AFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 20608070 N641JMDubose Mack H · Edmonds, WAS/N 20608024 N694SMSurveying And Mapping LLC · Austin, TXBuilt 2004 · S/N 20608223 N694TCBruton Aerial Spraying Inc · Garden City, TXS/N 20608069 N704AVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 20608225 N710RRMulcahy Michael T · Perris, CABuilt 2000 · S/N 20608106 N7254HVevani Aircraft LLC · Miami Gardens, FLBuilt 1999 · S/N 20608036 N725BJBas Part Sales LLC · Greeley, COS/N 20608023 N72614Liberty Leasing IV LLC · Melbourne, FLBuilt 2000 · S/N 20608117 N7261HMurray John Fulton III · Fort Worth, TXS/N 20608143 N7262ACf Aviation Trust LLC Trustee · Wilmington, DEBuilt 2000 · S/N 20608138 N7264DGravity & Grace LLC · Mill Valley, CABuilt 1999 · S/N 20608062 N7266NBeck Robert A · Cove, ORS/N 20608058 N7266YAvero Aviation LLC · Dover, DEBuilt 1999 · S/N 20608059 N7266ZBearing Tree Land Surveying LLC · Oklahoma City, OKBuilt 1999 · S/N 20608060 N72692Mccurdy Dwight B · Anderson, INBuilt 2000 · S/N 20608139 N72697Cbt Aviation LLC · Bellingham, WABuilt 1999 · S/N 20608031 N7276ZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 20608043 N767GEGreystoke Leasing Inc · Flagstaff, AZBuilt 2009 · S/N 20608317 N786TFAmerican Corporate Executive Services · Plantation, FLBuilt 2008 · S/N 20608316 N790SATavern Aviation LLC · Tavernier, FLBuilt 2001 · S/N 20608160 N79WWWindward Aviation Inc · Puunene, HIBuilt 2000 · S/N 20608129 N7CEGerhardstein Gregory V · Friday Harbor, WABuilt 1999 · S/N 20608030 N801TCSturgeon N C · Midland, TXBuilt 2000 · S/N 20608103 N808ZTDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608236 N809EMDepartment Of Homeland Security · Washington, DCBuilt 2004 · S/N 20608213 N809GTDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608245 N809HWDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608248 N809KPDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608249 N809LNDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608251 N809NDDepartment Of Homeland Security · Washington, DCBuilt 2004 · S/N 20608219 N809PGDepartment Of Homeland Security · Washington, DCBuilt 2003 · S/N 20608190 N809QJDepartment Of Homeland Security · Washington, DCBuilt 2004 · S/N 20608209 N809RHDepartment Of Homeland Security · Washington, DCBuilt 2004 · S/N 20608210 N809SEDepartment Of Homeland Security · Washington, DCBuilt 2003 · S/N 20608208 N809TTDepartment Of Homeland Security · Washington, DCBuilt 2004 · S/N 20608211 N809USDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608231 N809VADepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608232 N8203KHandy Air Inc · Douglas, GABuilt 2004 · S/N 20608203 N8330BSilver Creek Aviation Services · Fort Worth, TXBuilt 2011 · S/N 20608330 N833CGParagon Air Group · Fort Worth, TXBuilt 2011 · S/N 20608333 N841LMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 20608341 N852LRSilver Creek Aviation Services · Fort Worth, TXBuilt 2008 · S/N 20608313 N865WMichigan Dept Of Natural Resources · Roscommon, MIBuilt 2013 · S/N 20608352 N86WEBlue Air 1 LLC · Homestead, FLBuilt 2005 · S/N 20608243 N900HPKansas Highway Patrol · Topeka, KSBuilt 2012 · S/N 20608344

Back to Cessna 206H