Skip to content

Registered aircraft · 1,878

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

N85353Linstad Daniel E · Canby, ORBuilt 1946 · S/N 7AC-4093 N85362Demmers Jesse T · Jordan, MNBuilt 1946 · S/N 7AC-4102 N85364Roberts Raymond W · Smithfield, RIBuilt 1946 · S/N 7AC-4104 N85366Lemieux Kenneth G · Oneida, TNBuilt 1946 · S/N 7AC-4106 N85371Williams Darrell W · Fayetteville, ARBuilt 1946 · S/N 7AC-4111 N85378Benger Jeffrey S · Bozeman, MTBuilt 1946 · S/N 7AC-4118 N85380Holmgren Michael G · Kulm, NDBuilt 1946 · S/N 7AC-4120 N85381Kieffer Michael · Honey Creek, IABuilt 1946 · S/N 7AC-4121 N85383Faulkner Ronnie L · Mount Ida, ARBuilt 1946 · S/N 7AC-4123 N85384Stenger Douglas E · Banks, ORFirst renewal noticeBuilt 1946 · S/N 7AC-4124 N85387Temple Peter L · Harrisville, NHS/N 7AC-4127 N85393Crooks Sean P · Canton, MIS/N 7AC-4133 N85394Cunningham Blake F · Rockville, INBuilt 1946 · S/N 7AC-4134 N85396Patton Steven R · Wayne, OHBuilt 1946 · S/N 7AC-4136 N85397Kyle E Rich Inc · Sumner, IABuilt 1946 · S/N 7AC-4137 N85398Gann Gerald N · Conway, MOBuilt 1946 · S/N 7AC4138 N85400Champ85400 LLC · West Jordan, UTBuilt 1946 · S/N 7AC-4140 N85401Bartee Chaddick M · Lubbock, TXBuilt 1946 · S/N 7AC-4141 N85403Fossa Joseph · Essex, MABuilt 1946 · S/N 7AC-4143 N85406Crum John P · Waterloo, ILS/N 7AC-4146 N85411Debaun Gary · Terre Haute, INBuilt 1946 · S/N 7AC-4151 N85413Becker William A · Burlington, WIBuilt 1946 · S/N 7AC-4153 N85424Dirks Daniel P · Seguin, TXBuilt 1946 · S/N 7AC-4164 N85425Micro Aerodynamics Inc · Anacortes, WAS/N 7AC4165 N85430Weitemier Jeffrey D · Browerville, MNBuilt 1946 · S/N 7AC-4170 N85433Sturgell James A · Blanchard, OKBuilt 1946 · S/N 7AC-4173 N85434Letourneau Robert J · Plympton, MABuilt 1946 · S/N 7AC-4174 N85439Kupka John J · Fremont, OHBuilt 1946 · S/N 7AC-4179 N85440Catt Kevin R · Salinas, CABuilt 1946 · S/N 7AC-4180 N85442Hayton James B · Sedro Woolley, WABuilt 1946 · S/N 7AC-4182 N85448Poklar Norman A · Mount Orab, OHBuilt 1946 · S/N 7AC-4188 N85459Owens Joseph E · Winnfield, LABuilt 1946 · S/N 7AC-4199 N85464Spirit Of Superior LLC · Superior, WIBuilt 1946 · S/N 7AC-4204 N85470Mcguire Michael D · Lake Stevens, WAS/N 7AC-4210 N85479Appel David E · Redfield, SDBuilt 1946 · S/N 7AC-4219 N85491Zingery Michael G · Shepherd, MIBuilt 1946 · S/N 7AC-4231 N85499Mitchell Charles M · Ocala, FLBuilt 1946 · S/N 7AC-4239 N85502Stoltzfus Karl D · Homer, AKBuilt 1946 · S/N 7AC-4242 N85505Schnatz Benjamin A · Valley, NEBuilt 1946 · S/N 7AC-4245 N85528Bz Airworks · Eunice, LABuilt 1946 · S/N 7AC-4268 N85534Rinker Kraig G · Winlock, WAS/N 7AC-4274 N85537Agaliotis Paul E · San Martin, CABuilt 1946 · S/N 7AC-4277 N85543Willson Henry M Jr · Pioneer, OHBuilt 1946 · S/N 7AC-4283 N85544Miller James D · Wilmington, NCBuilt 1946 · S/N 7AC-4284 N85549Stock Gale C · Kirksville, MOBuilt 1946 · S/N 7AC-4289 N85564Jaquays Jeffrey C · Maryville, TNBuilt 1946 · S/N 7AC-4306 N85568Fesmire Wilson M · Dyer, TNBuilt 1946 · S/N 7AC-4310 N85571Cantley Richard W · Bluff City, TNBuilt 1946 · S/N 7AC-4313 N85581Mcbride Mark · Sutton, MABuilt 1946 · S/N 7AC-4324 N85582Hermann Vela M · Saint Louis, MOBuilt 1946 · S/N 7AC-4325

Back to Aeronca 7AC