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.

N1187EEsterak David R · Boyce, LABuilt 1946 · S/N 7AC-4744 N11916Pleasure Air LLC · Lake Havasu City, AZBuilt 1946 · S/N 7AC-1508 N1191ELawler Thomas O · Lava Hot Springs, IDBuilt 1946 · S/N 7AC-4748 N1196ECofer Billie W · Double Oak, TXBuilt 1946 · S/N 7AC-4753 N1197ECouch John Ainsley · Sealy, TXBuilt 1946 · S/N 7AC-4754 N1200ELockner Peter Phelps · Batavia, NYBuilt 1946 · S/N 7AC-4757 N1202EPinsky Heather G · Hurlburt Field, FLFirst renewal noticeS/N 7AC4759 N1209EKaraty Joseph · Bates City, MOBuilt 1946 · S/N 7AC-4766 N1213EWilcox Ralph G · Owensboro, KYBuilt 1946 · S/N 4771 N1214EMurray Craig P · Hagaman, NYBuilt 1946 · S/N 7AC-4772 N1216EFrancisco Doug R · Pensacola, FLBuilt 1946 · S/N 7AC-4776 N1219EPlyler Aviation Lp · Sherman, TXBuilt 1946 · S/N 7AC-4777 N1222EMorssink Peter J · Bel Air, MDBuilt 1946 · S/N 7AC-4780 N1226EPotock John M · South Riding, VABuilt 1946 · S/N 7AC-4784 N1229EOriginal Design Ministries · Eatonville, WABuilt 1946 · S/N 7AC-4787 N1234ELyddon Steven R · Liberal, KSBuilt 1946 · S/N 7AC-4792 N1237EKing Bruce · El Paso, TXS/N 7AC-4795 N1240EGevay James C · Circle Pines, MNBuilt 1946 · S/N 7AC-4798 N1241EThomas Paul J · Oakland, MDS/N 7AC-4799 N1244ERuppert Russell E · Dover, PABuilt 1946 · S/N 7AC-4802 N1249EChez Clay LLC · Georgiana, ALS/N 7AC-4807 N1254EMiller James L · Galena, ILBuilt 1946 · S/N 7AC-4812 N1255EReed Gretchen M · Madison, OHBuilt 1946 · S/N 7AC-4813 N1258ECadd Jonathan A · Newberg, ORBuilt 1946 · S/N 7AC-4816 N1268EBlocker Steve J · Edgar Springs, MOBuilt 1946 · S/N 7AC-4826 N1270ESteiner Zachary J · Bethlehem, CTBuilt 1946 · S/N 7AC-4828 N1278EBradley Christopher · Juneau, AKS/N 7AC-4836 N1282EMolek Eugene · Warren, OHBuilt 1946 · S/N 7AC-4842 N1286EWilson Stuart L · Glenpool, OKBuilt 1946 · S/N 7AC-4846 N1294ESouthwind Aviation Inc · Maryville, TNBuilt 1946 · S/N 7AC-4855 N1296EBigger William · Partlow, VABuilt 1946 · S/N 7AC-4858 N12DFGagne Gilbert R · Apple Valley, CABuilt 1946 · S/N 7AC-5050 N1302EVitiello Anthony J · Ballwin, MOS/N 7AC-4864 N1303EGregory James A · East Burke, VTBuilt 1946 · S/N 7AC4863 N1310EEaglet Flight Operations Lp · Fort Worth, TXBuilt 1946 · S/N 7AC-4871 N1313EKokes Joseph A · Greenwood, INS/N 7AC-4874 N1321EMiller Mark A · Waldoboro, MEBuilt 1946 · S/N 7AC-4882 N1330EEly Scott K · Goshen, OHBuilt 1946 · S/N 7AC-4891 N1331EEdmiston Brandon L · Murray, KYBuilt 1946 · S/N 7AC4892 N1334EJanes Peggy L · Ontario, ORBuilt 1946 · S/N 7AC-4895 N1337EOwens Wilbur · Rch Palos Vrd, CABuilt 1946 · S/N 7AC-4898 N1338EBurger Carolyn J · Tucson, AZS/N 7AC-4899 N1339EPhillips Kathleen G · New Milford, CTBuilt 1946 · S/N 7AC-4900 N1343EKness Richard P · Casa Grande, AZS/N 7AC-4904 N1344EDeford Francis D · Delphi, INBuilt 1946 · S/N 7AC-4905 N1348EHarper Joseph · Cecilia, KYBuilt 1946 · S/N 7AC-4909 N1350ELam Philip · San Francisco, CABuilt 1946 · S/N 7AC-4911 N1355EStonebrink Melvin · Wallowa, ORBuilt 1946 · S/N 7AC-4916 N1358ELiimatainen William J · Monroe, WIBuilt 1946 · S/N 7AC-4919 N1363EMenshan LLC · Weston, FLBuilt 1940 · S/N 7AC-4924

Back to Aeronca 7AC