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.

N1611EGrimshaw Ricky M · Elk Grove, CAFirst renewal noticeBuilt 1946 · S/N 7AC-5176 N1617ECarter Tonja B · Monroeville, ALBuilt 1946 · S/N 7AC-5182 N1618EParker Lee R · Alsea, ORBuilt 1946 · S/N 7AC-5184 N1624EStadel Jim D · Yuba City, CABuilt 1946 · S/N 7AC-5189 N1636EMcilonie Robert L · Pingree, NDS/N 7AC5201 N1642EMeade Raymond L · Chester, VABuilt 1946 · S/N 7AC-5207 N1646ESwager Joel P · Ione, CAS/N 7AC-5211 N1647EConder James C · Hemet, CAS/N 7AC-5212 N1648ECollins Keith D · Clanton, ALBuilt 1946 · S/N 7AC-5213 N1652EHemphill Holdings LLC · Hemphill, TXBuilt 1946 · S/N 7AC-5217 N1659EBrown Frank A · Seal Beach, CABuilt 1946 · S/N 7AC-5225 N1660EVia Johnnie W · Atascadero, CABuilt 1946 · S/N 7AC-5226 N1662ECalifornia Antique Aircraft Museum DBA · San Martin, CABuilt 1946 · S/N 7AC-5228 N1663EGrave Eugene G · Spencer, INBuilt 1946 · S/N 7AC-5229 N1664EJatho Jimmy W · Augusta, GABuilt 1944 · S/N 7AC-5230 N1665ETeichman Betty H · Venice, FLBuilt 1946 · S/N 7AC-5231 N1666EBelanger Paul L · Westbrook, MEFirst renewal noticeBuilt 1946 · S/N 7AC-5232 N1669EKangas Ralph A · Donnelly, IDBuilt 1946 · S/N 7AC-5235 N1681ERoy David J Sr · Clinton, NYBuilt 1946 · S/N 7AC-5247 N1690ELaplante Bruce · Vilonia, ARBuilt 1946 · S/N 7AC-5255 N1693EHanger Brian R · Ethel, WABuilt 1946 · S/N 7AC-5258 N1698EHunter Jared P · Somerville, MABuilt 1946 · S/N 7AC-5263 N1700EErfle Gordon A · Rapelje, MTBuilt 1946 · S/N 7AC-5265 N1703ERegistration Pending · Columbia, SCRegistration pending, pending cancellationBuilt 1946 · S/N 7AC-5268 N1706ECrabbe Michael B · Galloway, OHBuilt 1946 · S/N 7AC-5271 N1713EMurray Donald L · Two Harbors, MNBuilt 1946 · S/N 7AC-5278 N1714ELeonx Aaron R · Cambridge, WIBuilt 1946 · S/N 7AC-5279 N1715EDelong Erika D · Forest Lake, MNS/N 7AC-5280 N171HBKrawchuck Paul L · Live Oak, FLBuilt 1946 · S/N 7AC-2169 N1724EMorgan John T · Fort Payne, ALBuilt 1946 · S/N 7AC-5290 N1726ESale Reported · Overland Park, KSSale reportedBuilt 1946 · S/N 7AC-5291 N1729EFogg William R · Greensburg, INBuilt 1946 · S/N 7AC-5296 N1731EWelton Doug L · Fairbanks, AKBuilt 1946 · S/N 7AC-5298 N1744EDietz Steven C · Poplar Grove, ILBuilt 1946 · S/N 7AC-6125 N1749EPrice William B · Lamar, SCBuilt 1946 · S/N 7AC-5316 N1751ELowe Thomas E · Crystal Lake, ILBuilt 1946 · S/N 7AC-5318 N1752EStoos Robert A · Lakeland, FLS/N 7AC-5319 N1756ESlg Aviation LLC · Berlin, WIBuilt 1946 · S/N 7AC-5323 N1762EKopecky Carle J · Warnerville, NYBuilt 1946 · S/N 7AC-5329 N1763EKohn Michael E · Endicott, NYS/N 7AC-5330 N1764EBlackwood Edward W Jr · Mt Holly, NCBuilt 1946 · S/N 7AC-5331 N1766EKottemann Gregory C · Kentwood, LABuilt 1946 · S/N 7AC-5333 N1770ESimmers Jonathan P · Mandan, NDS/N 7AC-5337 N1771EBerntsen Bradley T Trustee · Apple Valley, MNBuilt 1946 · S/N 7AC-5338 N1774EKendall Jeffrey A · Vero Beach, FLFirst renewal noticeBuilt 1946 · S/N 7AC-5341 N177ACIsaac Bron A · Soldotna, AKS/N 7AC-5275 N1780EKalb Kenneth R · Dubois, INS/N 7AC-5347 N1785EHamlett Reece W · Anchorage, AKBuilt 1946 · S/N 7AC-5352 N1787EStevens Jerrold B · Salem, ORS/N 7AC-5354 N1789EPinkston Billy Walker · Lambert, MSBuilt 1946 · S/N 7AC-5356

Back to Aeronca 7AC