Skip to content

Registered aircraft · 209

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

N3491VKalbermatter Guillermo A · Ventura, CABuilt 1948 · S/N 7195 N3493VWhalen John M III · Boise, IDS/N 7197 N34PScootair LLC · Alburgh, VTS/N 7193 N355STScootair LLC · Alburgh, VTBuilt 1948 · S/N 7285 N3868VSwift Stephen D · Flower Mound, TXBuilt 1949 · S/N 7329 N3873VAthens Air LLC · Athens, TNBuilt 1949 · S/N 7335 N3877VPetersonrandy · Sonoma, CABuilt 1949 · S/N 7339 N3884VMather Todd A · Huron, OHBuilt 1949 · S/N 7353 N3890VInternational Air Services Inc Trustee · Carson City, NVBuilt 1949 · S/N 7361 N3891VKilo Aviation LLC · East Peoria, ILFirst renewal noticeBuilt 1949 · S/N 7362 N3893VSorenson Bennett L · Wichita, KSBuilt 1949 · S/N 7365 N3894VHighland Thomas Eugene · Portland, ORBuilt 1949 · S/N 7366 N3898VAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1949 · S/N 7376 N3899VMagers Starla · Blessing, TXBuilt 1949 · S/N 7377 N4024AEling Stefan · Savannah, GAS/N 7821 N4051AVintage Sky LLC · Trussville, ALBuilt 1949 · S/N 7318 N4310NMilton William H · Amsterdam, NYBuilt 1948 · S/N 7100 N4311NSchafhausen Mark G · Spokane, WABuilt 1948 · S/N 7099 N4312NBarron John L · Perry, MOBuilt 1948 · S/N 7098 N4319VBarron Jon M · Perry, MOBuilt 1948 · S/N 7226 N4327VFultz Andrew J · Starkville, MSBuilt 1948 · S/N 7270 N4331NThomsen Consulting Inc DBA · Monee, ILBuilt 1947 · S/N 7078 N4332VKenaga Michael L · Downers Grove, ILBuilt 1948 · S/N 7238 N4334NHardy John A · El Paso, TXBuilt 1947 · S/N 7075 N4335VMartin Edward I · Trinity Center, CABuilt 1948 · S/N 7241 N4337NAlldredge Aviation · Auburn, WABuilt 1947 · S/N 7072 N4344NHernden Mike · Rockford, ILBuilt 1947 · S/N 7065 N4344VBarron Aviation LLC · Perry, MOBuilt 1948 · S/N 7250 N4346NJohnson Fredrick S Jr · Shelbyville, KYBuilt 1947 · S/N 7063 N4347VSilver Cessnas LLC · Cheyenne, WYBuilt 1948 · S/N 7256 N4350VAeroclassics LLC · Waynesboro, VABuilt 1948 · S/N 7259 N4351VVandevort Lynn A · Manitowoc, WIBuilt 1948 · S/N 7260 N4352NJantzen Ronald L Trustee · Porter, OKBuilt 1947 · S/N 7055 N4352VRobertson Jon P · Acworth, GAS/N 7261 N4357NDavis Charles H Jr · Manchester, MIS/N 7058 N4357VRodriguez Daniel Lee · West Linn, ORBuilt 1948 · S/N 7266 N4358VBloch Christopher P · Grand Rapids, MIS/N 7274 N4367NMajerle Joseph III · Anchorage, AKBuilt 1947 · S/N 7039 N4367VGreulich Kenneth R Trustee · Sand Springs, OKBuilt 1948 · S/N 7282 N437Sackett Scott H · Krum, TXBuilt 1952 · S/N 7930 N4371NCole David L · Granbury, TXBuilt 1947 · S/N 7035 N4373NApple Jeffrey G · Sheridan, INBuilt 1947 · S/N 7033 N4375VPeck Nathan Mark · Leavenworth, KSBuilt 1949 · S/N 7320 N4380NWarwick Dakota R · Jupiter, FLS/N 7026 N4383VPorter Charles R · Ocala, FLBuilt 1949 · S/N 7305 N4384VBennett Robert M · Felton, DEBuilt 1949 · S/N 7306 N4386VAlerion Aviation LLC · Elbert, COBuilt 1949 · S/N 7308 N4388VPhilbrick Rodney C · Bishop, CABuilt 1949 · S/N 7310 N4391NRoy Rodney E · Grand Marais, MNBuilt 1947 · S/N 7030 N4394NEnnis Shannon E · Chesapeake, VABuilt 1947 · S/N 7011

Back to Cessna 195