Skip to content

Registered aircraft · 122

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

N2147CBas Part Sales LLC · Greeley, COBuilt 1954 · S/N 16132 N2149CYoung Marlon V · Santa Rosa, CABuilt 1954 · S/N 16134 N2151CAtkinson Patrick C · Fort Worth, TXBuilt 1954 · S/N 16136 N2152CTeenie 1 LLC · Boynton Beach, FLBuilt 1954 · S/N 16137 N2154CBoynton Scott E · Campbell Hall, NYS/N 16139 N2156CZoom Leasing LLC · Barto, PABuilt 1954 · S/N 16141 N2158CSlocum James E · Poplar Grove, ILBuilt 1954 · S/N 16143 N2160CStephenson Stephanie V · Colby, KSBuilt 1954 · S/N 16145 N2161CHendrix Todd M · Bakersfield, CABuilt 1954 · S/N 16146 N2165CHaltom Alan W · Centennial, COBuilt 1954 · S/N 16150 N2166CMaples Jeffery · Belle, MOBuilt 1954 · S/N 16151 N2168CHowerton Pammela S · Bartlesville, OKBuilt 1954 · S/N 16153 N2172CMcintire Larry C · Marietta, GABuilt 1954 · S/N 16157 N2174CCanandaigua Air Center LLC · Canandaigua, NYBuilt 1954 · S/N 16159 N2175CHoffpauir Stanley C · Waller, TXBuilt 1954 · S/N 16160 N2180CBerg Alvin L · Overgaard, AZBuilt 1955 · S/N 16165 N2185CRichards William R · Columbus, INBuilt 1955 · S/N 16170 N2186CBucher Burton W · North Chicago, ILBuilt 1955 · S/N 16171 N2190CSchmiedt Daniel M · Westminster, SCBuilt 1955 · S/N 16175 N2192CHamann David L · Los Lunas, NMBuilt 1955 · S/N 16177 N2193CClerx Bernard C · Newport Beach, CAFirst renewal noticeBuilt 1955 · S/N 16178 N2194CFavero Sebastian A · Poway, CABuilt 1955 · S/N 16179 N2195CGunter Bradley M · Canon City, COBuilt 1954 · S/N 16180 N2196CPelton Jack J · Wichita, KSBuilt 1955 · S/N 16181 N2197CVintage Aircraft Sales LLC · Radnor, OHBuilt 1954 · S/N 16182 N3001BLarsen James · Santa Rosa, CABuilt 1952 · S/N 7884 N3005BStreamline Aviation LLC · Battlefield, MOS/N 7888 N3010BEuroaviation Inc Trustee · KematenBuilt 1952 · S/N 7893 N3011BCarney Jeffrey · Langhorne, PABuilt 1952 · S/N 7894 N3023BWelch Thomas R · Modesto, CABuilt 1952 · S/N 7906 N3026BMacario T Michael · Townsend, DEBuilt 1952 · S/N 7909 N3027BLacey William F · Parker, COBuilt 1952 · S/N 7910 N3029BWilson Christopher W · Edgewood, NMBuilt 1952 · S/N 7912 N3031BPontieri Kari · Parma, OHBuilt 1952 · S/N 7914 N3035BFlying W Aviation Enterprises · Bellevue, NEBuilt 1952 · S/N 7918 N3037BQualitair LLC Trustee · MichelstadtBuilt 1952 · S/N 7920 N3042BDiaz Carlos Ricardo · Pensacola, FLBuilt 1952 · S/N 7925 N3045BSmokovitz Joseph M · Tecumseh, MIBuilt 1994 · S/N 7928 N3050BNelson William W · Saint Petersburg, FLBuilt 1952 · S/N 7933 N3056BO'Brien Alan S · Camarillo, CABuilt 1952 · S/N 7939 N3064BSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1955 · S/N 7947 N3070BBriscoe Joseph C · Gresham, ORBuilt 1952 · S/N 7954 N3081BPlane Fun Inc Tr Trustee · Snellville, GABuilt 1952 · S/N 7966 N3090BGreen & Green Construction Co Of Grenada Inc · Grenada, MSS/N 7975 N3091BRadisch Herbert R Jr · San Diego, CABuilt 1952 · S/N 7976 N4385NVyfvinkel Frederick J · New Smyrna Beach, FLBuilt 1947 · S/N 7019 N4403CArlins Aircraft Service Inc · Belgrade, MTBuilt 1952 · S/N 7988 N4405CDavis Richard L · Everett, WABuilt 1952 · S/N 7990 N4414CJohnson Thomas W · Westminster, MDBuilt 1953 · S/N 7999 N4420CMilton William H · Amsterdam, NYBuilt 1952 · S/N 16005

Back to Cessna 195B