Skip to content

Registered aircraft · 50

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

N113MVRettig Air LLC · Riverside, CABuilt 2003 · S/N 2193 N12WZNortech Data Services Inc · Wilmington, DEBuilt 2003 · S/N 2206 N148JMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 2020 N159DMLe Kenneth · Henderson, NVBuilt 2000 · S/N 2005 N1888EChoe Young Kyu · Manhasset, NYBuilt 1999 · S/N 1888 N189GTKenai Aviation LLC · Akron, OHBuilt 2001 · S/N 2022 N1903SGriffin Products Inc · Wills Point, TXBuilt 1999 · S/N 1903 N190AVNghiem Daniel · Westminster, CAS/N 2165 N20FQJag Capital LLC · Cocoa, FLBuilt 1986 · S/N 638 N20FRNorton Justin William · Albuquerque, NMS/N 639 N20FZSharp Randy L · Rocklin, CABuilt 1986 · S/N 644 N20GFVerbil Christopher J Trustee · Los Altos, CABuilt 1987 · S/N 645 N20KMMozur Matthew Allen · Danvers, MABuilt 1985 · S/N 558 N20LUCamas Wings LLC · Camas, WAS/N 685 N20LVSilver Skyways LLC · Las Cruces, NMBuilt 1986 · S/N 686 N20NBStauffer Michael S · Wichita Falls, TXS/N 557 N20NCJohnson Professional Aviation LLC · League City, TXS/N 559 N20NDSheff Donald · Redwood City, CAS/N 687 N219SDFreund Gregor · San Francisco, CABuilt 2001 · S/N 2050 N228GHopkins Boone K · Saint Simons Is, GAS/N 612 N241GTBroshchan Ruslan A · Jackson, MSS/N 2141 N245LCImage Craft LLC · Phoenix, AZBuilt 2001 · S/N 2045 N2522DMiller Stephen · St Louisville, OHS/N 872 N290DYZumm Thomas Lawrence · Wheaton, ILBuilt 2002 · S/N 2108 N291GTNattjat Aviation LLC · El Dorado Hills, CABuilt 2001 · S/N 2091 N3056RHassenpflug Derek G · Cincinnati, OHS/N 1598 N377CValiair Limited Company Trustee · Casper, WYBuilt 2005 · S/N 2222 N388JGBeggins Thomas J · Madison, CTBuilt 2000 · S/N 2021 N397TBLiberty Industries LLC · Washington, DCBuilt 1997 · S/N 1804 N421TBHale Concepts LLC · Marietta, OHBuilt 2002 · S/N 2081 N42TGMurray Frederick D · Evans, GAS/N 684 N456TBValentine David L · Katy, TXBuilt 1999 · S/N 1911 N54TWQualitair LLC Trustee · MichelstadtS/N 745 N678TBHunter Dennis F · Rohnert Park, CAS/N 1925 N68JTVallandi Amy E · Las Vegas, NVBuilt 1989 · S/N 904 N691SCSouthern Cross Aircraft LLC · Fort Lauderdale, FLS/N 1552 N703TBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2000 · S/N 2035 N705TBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 2215 N709AMAirtrust LLC - 13 - Series 13 Trustee · Sheridan, WYBuilt 2001 · S/N 2101 N711LYSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2003 · S/N 2182 N713TBKasper Michael · Pahrump, NVBuilt 2002 · S/N 2123 N725TBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2003 · S/N 2201 N726TBRead Russell P · Missoula, MTBuilt 2002 · S/N 2151 N789TBKelly Derrell R · Truman, MNBuilt 1999 · S/N 1919 N824GTBmi Aviation LLC · Bartlesville, OKBuilt 2000 · S/N 2010 N913DJSteele H Scott · Idaho Falls, IDS/N 1280 N92GTBlue Skies Aviation LLC · Riverdale, MDBuilt 2002 · S/N 2100 N967WMLionheart Enterprise Co LLC · Chino Valley, AZBuilt 1990 · S/N 967 N97GTMihalyi Attila · Princeton, NJS/N 2135 N9934PSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1990 · S/N 1086

Back to Socata TB21