Skip to content

Registered aircraft · 166

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

N445YSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1951 · S/N 22817 N473GFHonolulu Soaring Club Inc · Waialua, HIBuilt 1967 · S/N 2018 N4819RContinental Title Trust LLC · Wichita, KSS/N 22280 N48PFFree Philip O · Collierville, TNBuilt 1971 · S/N 23721 N49236Lakeland Aero Club Inc · Lakeland, FLS/N 23192 N49237Arnold J T · Sevierville, TNBuilt 1952 · S/N 23195 N5061XAir Repair Inc · Cleveland, MSS/N 23260 N50731Datema Steven K · Susanville, CAS/N 21379 N5073UMutha Fokker Aviation LLC · Wilmington, DEBuilt 1951 · S/N 21562 N5073WPerkins Joel · Senoia, GABuilt 1950 · S/N 21096 N5073YLone Star Flight Museum · Houston, TXS/N 21714 N5074ATherp Todd J · Ashton, IDBuilt 1950 · S/N 21252 N5074BMehrhoff Stanley E · Prairie Home, MOBuilt 1951 · S/N 21600 N5074HRollins Thomas M · Salt Lake City, UTBuilt 1950 · S/N 21091 N5074ZVadeboncoeur Michael D · Danville, ILS/N 21637 N5075AKahn David J · Roanoke, VAS/N 21299 N5075KCelebrate Freedom Foundation · West Columbia, SCS/N 21487 N5075NRetroair Restoration LLC · Big Lake, AKS/N 21296 N5075SWhitlock Holdings LLC · Honey Grove, TXBuilt 1951 · S/N 21529 N5075UMiller David E · Goode, VAS/N 21370 N509EAAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1953 · S/N 23090 N51446Decreeft Joseph · Homer, AKBuilt 1966 · S/N 2013 N5167GWyatt Colby · Cherokee, OKBuilt 1951 · S/N 22302 N5168GForster Edward J · Antrim, NHBuilt 1950 · S/N 21186 N5169GPepper Tyler I · Port Orange, FLBuilt 1951 · S/N 22760 N5170GVihlen Steven C · Locust Grove, GABuilt 1951 · S/N 22713 N5172GNoyes Stephen · Newbury, MAS/N 21513 N5174GMartin William · San Antonio, TXS/N 22304 N5175GKahn David J · Roanoke, VAS/N 22577 N5178GCourville Gerald K · Reeves, LAS/N 22242 N5179GElie Jonathan · Hopewell Junction, NYS/N 22272 N5181GWalton Daniel G · Troy, MOBuilt 1951 · S/N 22234 N5182GWeese C · Quinlan, TXBuilt 1951 · S/N 23206 N5188GPlane And Simple Leasing LLC · Delano, MNBuilt 1951 · S/N 22196 N5190GFinney Billy D · Muncie, INBuilt 1951 · S/N 22452 N5192GCarey International Aviation Services LLC · Long Beach, NYBuilt 1951 · S/N 21683 N5194GRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1951 · S/N 22000 N5195GPowelson Mark · Pataskala, OHS/N 22208 N5199GBeck Gary F · Lake Havasu City, AZS/N 22118 N51BDSearle Kenneth V · Bigfork, MTS/N 22566 N5200GReed Conrad H · Centre, ALBuilt 1951 · S/N 23073 N5201GAirmo LLC · Monrovia, INS/N 22433 N5207GBeck Gary F · Lake Havasu City, AZS/N 21645 N5208GSnider Gary L · West Des Moines, IABuilt 1951 · S/N 21936 N5209GFlax Brian J · Germantown, TNBuilt 1951 · S/N 21811 N5210GGraf III Eugene · Bozeman, MTBuilt 1951 · S/N 22186 N5211GChavez Clifford L · Seguin, TXBuilt 1951 · S/N 21744 N5212GSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1950 · S/N 21201 N5213GSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1951 · S/N 21573 N5214GKirby Sherry · Granite Falls, NCBuilt 1951 · S/N 22514

Back to Cessna 305A