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.

N81571Gilbert Kent G · Brookshire, TXS/N 7AC-190 N81572Hamilton Riley A · Janesville, WIS/N 7AC-191 N81574Stewart John D · Slatington, PABuilt 1945 · S/N 7AC-192 N81576Bellamy John-Mark · Freeville, NYBuilt 1945 · S/N 7AC-195 N81585Wood Roger E · Waxhaw, NCBuilt 1945 · S/N 7AC-204 N81588Weber Jennifer R · Bryan, TXBuilt 1945 · S/N 7AC-207 N81592Ranger Aviation Inc · Burlington, COS/N 7AC-211 N81595Paliughi Matthew R · Fresno, CABuilt 1945 · S/N 7AC214 N81596Super D Group LLC · Hanoverton, OHBuilt 1945 · S/N 7AC-215 N81598Holmgren Lorence · Kulm, NDFirst renewal noticeBuilt 1945 · S/N 7AC-217 N81600Rybicki Joseph · Hayesville, NCS/N 7AC-219 N81606Tanner R Joel · Schertz, TXBuilt 1945 · S/N 7AC227 N81611Burlace Thomas J III · Aurora, COBuilt 1945 · S/N 7AC-232 N81613Brown Casey · Lowell, MIS/N 7AC-234 N81616Admundsen Jonathan R · Carson City, NVS/N 7AC-222 N81618Mycroft Fred A · Sierra Madre, CABuilt 1945 · S/N 7AC-239 N81624Smith Herbert E · Rochelle, ILS/N 7AC245 N81630Everhart Melvin L · Spring Hill, FLBuilt 1945 · S/N 7AC-249 N81644Cramer Travis J · Moundville, MOBuilt 1945 · S/N 7AC-265 N81650Mcelroy Scott R · Saint Matthews, SCBuilt 1945 · S/N 7AC269 N81652Fabric Flyers LLC · Wilmington, DEBuilt 1945 · S/N 7AC-270 N81656Mueller Lawrence A · Jackson, GABuilt 1945 · S/N 7AC-275 N81661Francisco Doug R · Pensacola, FLS/N 7AC-236 N81663Ranger Airfield Foundation · Ranger, TXBuilt 1945 · S/N 7AC-281 N81666Misulich Mark D · Lawrenceburg, INBuilt 1945 · S/N 7AC-286 N81667Ellingson Leslie B · Harwood, NDBuilt 1945 · S/N 7AC-287 N81675Elliott Ronald H · Alexandria, LABuilt 1945 · S/N 7AC-294 N81678Wilson Jeffrey A · Sardinia, OHBuilt 1945 · S/N 7AC-297 N81679Chamberlain C Douglas · Bellefontaine, OHBuilt 1945 · S/N 7AC-298 N81681Dagnon Paul A · Apple Valley, MNBuilt 1945 · S/N 7AC-300 N81693Coulliette Brian K · Jacksonville, FLBuilt 1945 · S/N 7AC-312 N81700Puryear Rodney K · Pampa, TXS/N 7AC-319 N81704Anderson Mark A · Bates City, MOBuilt 1945 · S/N 7AC-323 N81711G And G Farms Inc · Williamson, NYBuilt 1945 · S/N 7AC-330 N81716Benien Dennis A · Napoleon, OHBuilt 1945 · S/N 7AC-335 N81720Leclere Doug D · Coggon, IABuilt 1945 · S/N 7AC-339 N81724Spee James · Redlands, CABuilt 1945 · S/N 7AC-343 N81732Mccurdy Robert L · Valley Head, ALBuilt 1945 · S/N 7AC-353 N81735Davis Christopher V · Green Forest, ARBuilt 1946 · S/N 7AC-356 N81738Seidner Neil W · Box Elder, SDBuilt 1945 · S/N 7AC-359 N81742Martin Joseph L · Pike Road, ALBuilt 1946 · S/N 7AC-363 N81747Kaba Robert D · Pace, FLBuilt 1945 · S/N 7AC-368 N81755Schrier Robert E · Deland, FLBuilt 1945 · S/N 7AC-376 N81757Culver Robert J · Frankston, TXBuilt 1945 · S/N 7AC-378 N81759Myers Nicholas E · Leipsic, OHBuilt 1945 · S/N 7AC-380 N81760Reed Gretchen M Trustee · Madison, OHBuilt 1945 · S/N 7AC-381 N81761Macveigh Craig A · New Carlisle, OHS/N 7AC-382 N81777Sparks James D · Glennallen, AKBuilt 1945 · S/N 7AC-400 N81780Milstein Jakob · Boulder, COBuilt 1945 · S/N 7AC-403 N81782Camacho Hector F · Andover, KSBuilt 1945 · S/N 7AC-405

Back to Aeronca 7AC