Skip to content

Registered aircraft · 361

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

N100HYLake Hoppers Seaplane Academy LLC · Alexandria, MNS/N 2100 N102AATangoromeo LLC · Kalispell, MTBuilt 2007 · S/N 2393 N102AMAntczak Air LLC · Rice Lake, WIS/N 2182 N102CAQualitair LLC Trustee · MicheistadtBuilt 2004 · S/N 2272 N102HYMhoc LLC · Pensacola, FLBuilt 2005 · S/N 2324 N103AASmith George Barker · Lexington, KYBuilt 2007 · S/N 2411 N103BBHarris John F III · Louisburg, NCBuilt 2000 · S/N 2060 N103HYLegend Flyer LLC · Bozman, MDBuilt 2003 · S/N 2241 N104AMSee Kimberly · Seeley Lake, MTBuilt 2000 · S/N 2093 N104HYGlenn Heath · Ranger, TXBuilt 2006 · S/N 2339 N106MAWaits Kevin A · Red Bluff, CABuilt 2003 · S/N 2228 N108AMTekton Aviation LLC · Austin, TXBuilt 2001 · S/N 2136 N109AALiberty Aviation LLC · Brighton, COBuilt 2007 · S/N 2427 N109WWThiel Daniel R · Cheyenne, WYBuilt 2006 · S/N 2368 N10GPMaule Club Corporation · New York, NYBuilt 1999 · S/N 2016 N10HYHenry Hammond Cobb Jr Foundation · Montgomery, ALBuilt 1998 · S/N 2006 N111UYGonzales Jon · Prairieville, LABuilt 2003 · S/N 2227 N112HYEmerald Farms LLC · Honey Grove, TXBuilt 2006 · S/N 2346 N115XTStaley Ronald L · Lebanon, ORBuilt 2002 · S/N 2216 N123HUDriscoll Jeffery D · Aberdeen, IDBuilt 2000 · S/N 2123 N125MSRegistered aircraftS/N 2022 N127AKSwan Logistics LLC · Toledo, OHS/N 2059 N127EYoung John C · Olathe, KSBuilt 2001 · S/N 2146 N127TZMeng-Hannan Construction Inc · Portland, ORBuilt 2000 · S/N 2108 N12GRJones Richard B · Georgetown, TXBuilt 2001 · S/N 2152 N12PKDuncan Aviation Inc · Lincoln, NEBuilt 2000 · S/N 2103 N12QRWilson Koby D · Southside, ARBuilt 2000 · S/N 2121 N131JMMoffitt John S · Gilroy, CABuilt 2001 · S/N 2150 N131WBSchnell Michael L · Spearman, TXBuilt 2005 · S/N 2311 N132CMWells Garry L · Scotia, NEBuilt 2002 · S/N 2207 N132HYCummings Drew T · Lewistown, MTBuilt 2001 · S/N 2132 N13HYKahler Enterprises LLC · Reedsburg, WIBuilt 1999 · S/N 2050 N13LS13 Lima Sierra LLC · Whitesboro, TXBuilt 2007 · S/N 2439 N143HPDans Aircraft Repair LLC · Gardiner, MTS/N NF0007 N145HPWalek Thomas E · Woodbury, MNBuilt 2003 · S/N NF0006 N148AMEightalphamike LLC · Kissimmee, FLBuilt 2001 · S/N 2148 N148CAAfrican Parks Aviation Inc Trustee · Cheyenne, WYBuilt 2005 · S/N 2293 N153AAHorn Jack E · Erie, COBuilt 2007 · S/N 2386 N153ELOld Mill Marina Inc · Eagle Lake, MES/N 2290 N155WWJohnson Otis L · Seminole, TXBuilt 2006 · S/N 2370 N156AADardis Aviation LLC · Alpine, WYBuilt 2007 · S/N 2390 N157AMPhotofax Inc · Gilberts, ILBuilt 2001 · S/N 2157 N15CMCarolina Aero Group LLC · Youngsville, NCBuilt 2004 · S/N 2280 N160AASauerbrey Andreas M · Steamboat Springs, COBuilt 2007 · S/N 2391 N160WWBrynelsen Charles R · North Oaks, MNBuilt 2007 · S/N 2384 N161AMDe Boissard Karen · New York, NYS/N 2161 N163MABlue Dawg LLC · Sandpoint, IDBuilt 2005 · S/N 2303 N164MAAssend Dragon Aviation LLC · San Antonio, TXS/N 2287 N166WWWalker Keith A · Mason City, NEBuilt 2006 · S/N 2372 N168AAWest Elk Capital LLC · Niwot, COBuilt 2007 · S/N 2392

Back to Aviat A-1B