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.

N4395VAbel John R · Haslet, TXBuilt 1949 · S/N 7323 N4398NHammerle Tye F · Kenosha, WIBuilt 1947 · S/N 7007 N4400CLange Marc B · Spokane Valley, WABuilt 1952 · S/N 7985 N4408CBarron Aviation LLC · Perry, MOBuilt 1952 · S/N 7993 N4415CHunter Mason B · Helena, MTBuilt 1952 · S/N 16000 N4424CCollard Mark · Montague, MIBuilt 1953 · S/N 16009 N4426CAllen Stephen W · Fredericksburg, TXBuilt 1953 · S/N 16011 N4439CRegistration Pending · Wilmington, DERegistration pendingBuilt 1953 · S/N 16024 N4458CMarken Jeffrey R · Baker, FLBuilt 1953 · S/N 16043 N4467CNighthawk Air Systems Inc · Palmetto Bay, FLS/N 16052 N4468CCommand Aire LLC · Sitka, AKBuilt 1953 · S/N 16053 N4474CSlipshod Aviation LLC · Hurricane, UTBuilt 1953 · S/N 16059 N4484CHoward William D · Coupland, TXBuilt 1953 · S/N 16068 N4494CWest Thomas P · Bridgeport, OHBuilt 1953 · S/N 16078 N4495CAustin Cody · Pflugerville, TXS/N 16079 N460AHensley Scott · Elbert, COS/N 7553 N4707VWhite Timothy C · Grapevine, TXS/N 7275 N4745GMorris Thomas B · Imlay City, MIBuilt 1948 · S/N 7173 N4929CBerry Darrel · Camden, TNBuilt 1959 · S/N 7803 N55MStevens Donald K · Canton, GABuilt 1949 · S/N 7408 N597KKriedeman Daniel Paul · Port Orange, FLBuilt 1949 · S/N 7403 N60WRadisch Herbert R Jr · San Diego, CABuilt 1949 · S/N 7385 N6492DVessey Benjamin S · Fort Collins, COBuilt 1959 · S/N 7383 N6577DScootair LLC · Alburgh, VTS/N 7847 N6857DDynamic Aerospace Inc · Framingham, MABuilt 1951 · S/N 7848 N6889DBarron Aviation LLC · Perry, MOBuilt 1949 · S/N 7846 N6896CCurry Caleb C · Edmond, OKS/N 7340 N689THBig Squirrelly LLC · Kalispell, MTBuilt 1947 · S/N 7025 N72CCasa Acquisitions LLC · Winter Haven, FLBuilt 1948 · S/N 7219 N829TJJ T Airshows · Slidell, TXBuilt 1953 · S/N 16048 N87EFCaldera Efrain · West Milford, NJBuilt 1950 · S/N 7482 N8860NBroussard Lewis A Jr · Morse, LABuilt 1948 · S/N 7232 N9054ZAeronautical Educational Foundation · Stockton, CABuilt 1951 · S/N 7819 N9312ARudisel Kenneth J · Williamsburg, MIBuilt 1949 · S/N 7367 N9318ASmith Michael Todd · Edgerton, MOBuilt 1949 · S/N 7397 N9319AMyers Alan J · Danville, ILBuilt 1949 · S/N 7398 N9322ALeamon Douglas H Trustee · Stockwell, INBuilt 1949 · S/N 7401 N9330ACrh LLC · Middlebury, CTBuilt 1949 · S/N 7409 N9334AHusser Leonard A · Camano Island, WABuilt 1949 · S/N 7413 N9339ASwede Aviation LLC · Tucson, AZS/N 7419 N9341ARollison James · Scottsdale, AZS/N 7421 N9350AGalloway Thomas E S · Oklahoma City, OKBuilt 1949 · S/N 7429 N9353ARoelofs David M · Prescott, AZBuilt 1949 · S/N 7432 N9368AKimberlin Mark · Grants Pass, ORBuilt 1949 · S/N 7447 N9371ACosper Rodney S · Killeen, TXS/N 7450 N9373AAlis Russell D · Fairbanks, AKBuilt 1949 · S/N 7452 N9375AGillam Donald E · Lafayette, LABuilt 1949 · S/N 7454 N9382ASeniw Alan G · Bonfield, ILBuilt 1949 · S/N 7461 N9386AWarhank David · Rudyard, MTBuilt 1949 · S/N 7465 N9399ABarron Aviation LLC · Perry, MOBuilt 1950 · S/N 7556

Back to Cessna 195