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.

N85585Brauer Eric M · Signal Mountain, TNS/N 7AC-4328 N85587Broderson Dennis L · Port Townsend, WABuilt 1946 · S/N 7AC-4330 N85590Newton Dale H · Louisville, OHS/N 7AC-4333 N85596Leek Roger W · Salem, ORBuilt 1946 · S/N 7AC-4339 N85598Stewart Jr Emerson C · Waynesville, OHBuilt 1946 · S/N 7AC-4341 N85606Backyard Aero LLC · Rockville, INBuilt 1946 · S/N 7AC-4349 N85607Berge Paul J · Indianola, IABuilt 1946 · S/N 7AC-4350 N85609Neader Steven W · Colusa, CABuilt 1946 · S/N 7AC-4352 N85611Sellmeyer Charles A · Lakeland, FLBuilt 1971 · S/N 7AC-4355 N85613Stick N Rudder Enterprises LLC · Miami, FLBuilt 1946 · S/N 7AC-4357 N85615Rasmussen Peter · Orient, OHBuilt 1946 · S/N 7AC-4359 N85617Swiney Timothy L · Tower Hill, ILBuilt 1946 · S/N 7AC-4361 N85633Hardy John R · Wasilla, AKBuilt 1946 · S/N 7AC-4377 N85636Corradi John M · Rixeyville, VABuilt 1946 · S/N 7AC-4380 N85639Duvall Paul M · Scottsburg, INBuilt 1946 · S/N 7AC-4383 N85641Hammer Ronald R · Polo, ILBuilt 1946 · S/N 7AC-4385 N85647Perkins Robert A · New Richmond, WIS/N 7AC-4391 N85652Steenstry Larry E · Delavan, WIBuilt 1946 · S/N 7AC-4396 N85656Jasinski Jack J · Necedah, WIBuilt 1946 · S/N 7AC-4401 N85661Hutton Georgia Lee Trustee · Norman, OKBuilt 1946 · S/N 7AC-4406 N85663Stewarts Aircraft Service Inc · Waynesville, OHBuilt 1946 · S/N 7AC-4408 N85664Emslie Donis A · West Lafayette, OHS/N 7AC-4409 N85668Seckerson Dale W · Jamestown, NDBuilt 1946 · S/N 7AC-4413 N85671Gentz Barbara J · Strykersville, NYS/N 7AC-4416 N85673Sherrow Kent · Viburnum, MOBuilt 1946 · S/N 7AC-4418 N85675Beranek John W · Prairieburg, IABuilt 1946 · S/N 7AC-4420 N85676Bardwell Warren E · Gonvick, MNBuilt 1946 · S/N 7AC-4421 N85682Teck Roger M · Mayfield, NYBuilt 1946 · S/N 7AC-4427 N85688Whitbeck Larry J · Lincoln, ILBuilt 1946 · S/N 7AC-4434 N85691Johnson Christopher N · West Richland, WABuilt 1946 · S/N 7AC-4437 N85692Duncan Christopher L · Austin, TXBuilt 1946 · S/N 7AC-4438 N85695Griffith Dan W · Indianapolis, INBuilt 1946 · S/N 7AC-4441 N85697Registration Pending · Hudson, INRegistration pendingBuilt 1946 · S/N 7AC-4443 N85703Weaver Carl · Halstead, KSBuilt 1946 · S/N 7AC-4449 N85708Oltmans Michael J · Cotter, ARBuilt 1946 · S/N 7AC-4454 N85715Kiser Aviation LLC · Grottoes, VABuilt 1946 · S/N 7AC-4462 N85721Walker Mark C · Scottsdale, AZBuilt 1946 · S/N 7AC-4468 N85729Albright William C Jr · Olathe, COS/N 7AC-4476 N85730Peters Alexander F · Emporia, VABuilt 1946 · S/N 7AC-4477 N85742Phillips Douglas R · Sellersville, PAFirst renewal noticeBuilt 1946 · S/N 7AC-4491 N85743Houdashell Ernest L · Amarillo, TXBuilt 1946 · S/N 7AC-4492 N85745Pelan Lynn · Oakland, NES/N 7AC-4494 N85747Kunze Lee A · Howards Grove, WIBuilt 1946 · S/N 7AC-4496 N85748Yellow Bird Flyers Association · Springfield, OHBuilt 1955 · S/N 7AC-4497 N85753Burton William G · Palmetto, FLBuilt 1946 · S/N 7AC-4502 N85754Frieh Albert E · Brookfield, ILBuilt 1946 · S/N 7AC-4503 N85762Airknockers LLC · Godley, TXBuilt 1946 · S/N 7AC-4511 N85767Beranek James D · Cottage Grove, ORBuilt 1946 · S/N 7AC-4516 N85774Peterson Jeffery John · Medford, WIBuilt 1963 · S/N 7AC-4523 N85777Haubs Photography & Services · Dayton, IAS/N 7AC-4526

Back to Aeronca 7AC