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.

N82462Malone Grady I · Loudon, TNBuilt 1946 · S/N 7AC-1095 N82466Hrutkay Charles S · Scenery Hill, PABuilt 1946 · S/N 7AC-1099 N82468Hemphill Holdings LLC · Hemphill, TXBuilt 1946 · S/N 7AC-1101 N82472Douglas Billy Ray · Brookston, TXBuilt 1946 · S/N 7AC-1108 N82478Salisbury Thomas · Coeymans Hollow, NYBuilt 1946 · S/N 7AC-1114 N82480Flugzeug LLC · Hanover, INBuilt 1946 · S/N 7AC-1117 N82484Grow David A · Gloucester Point, VABuilt 1946 · S/N 7AC-1121 N82489Behling James E · Cumberland, WIBuilt 1946 · S/N 7AC-1126 N82490Martin Nathaniel W · Wasilla, AKFirst renewal noticeS/N 7AC-1127 N82496Mako Investments Lc · Lafayette, LABuilt 1946 · S/N 7AC-1133 N82498Maedgen William L · Salado, TXBuilt 1946 · S/N 7AC-1135 N82503Church David A · Schnecksville, PABuilt 1946 · S/N 7AC-1140 N82506Church Sammie H · Statesville, NCBuilt 1946 · S/N 7AC-1143 N82510Swift Izak H · Fargo, NDBuilt 1946 · S/N 7AC-1147 N82512Reed Charles H · Shelbyville, KYBuilt 1946 · S/N 7AC-1149 N82515Pangelinan Regina Mafnas · Dublin, CABuilt 1946 · S/N 7AC-1152 N82519Ross Elizabeth K · Schenectady, NYBuilt 1946 · S/N 7AC-1156 N82523Hardy John R · Wasilla, AKBuilt 1946 · S/N 7AC-1160 N82529Champ Aero LLC · Louisville, KYBuilt 1946 · S/N 7AC1166 N82538Adkins Dwain L · Sycamore, ILBuilt 1946 · S/N 7AC-1175 N82540Valburg Lonnie H · Holton, KSBuilt 1959 · S/N 7AC-1177 N82541Tranby Wayne A · Fargo, NDBuilt 1946 · S/N 7AC-1178 N82543Janes Brenda Trustee · Shepherdsville, KYBuilt 1946 · S/N 7AC-1180 N82546Veillon Joseph B · Alexandria, LABuilt 1946 · S/N 7AC-1183 N82548Registration Pending · Milwaukee, WIRegistration pendingBuilt 1946 · S/N 7AC-1185 N82551Brumfiel Joshua A · Hebron, KYS/N 7AC-1188 N82558Leedom David L · Caney, OKBuilt 1946 · S/N 7AC-1195 N82559Sifsof Victor G · Dillingham, AKS/N 7AC-1196 N82560Reynolds William J · Griffin, GABuilt 1946 · S/N 7AC-1197 N82564Davis Richard · Reno, NVBuilt 1946 · S/N 7AC-1201 N82569Rinker Kraig G · Winlock, WABuilt 1946 · S/N 7AC-1206 N82571Glastar LLC · Greenwood, MNBuilt 1946 · S/N 7AC-1208 N82573Powell Michael D · Sealy, TXBuilt 1946 · S/N 7AC-1210 N82574Wendland Kenneth N · Big Timber, MTBuilt 1946 · S/N 7AC-1211 N82576Gainor Mark C · Milnor, NDBuilt 1946 · S/N 7AC-1213 N82578Moser Calvin · Milbank, SDS/N 7AC-1215 N82579Weston Lee R · Lilliwaup, WABuilt 1946 · S/N 7AC-1216 N82589George James C · Lenoir, NCBuilt 1946 · S/N 7AC-1226 N82590Hubble Harley J · Gallipolis, OHBuilt 1946 · S/N 7AC-1227 N82594Four C Sons Inc · Kersey, COBuilt 1946 · S/N 7AC-1231 N82595Dragons Tail LLC · Midland, MIBuilt 1946 · S/N 7AC-1232 N82599Hayden Sarah Alison · Owensboro, KYS/N 7AC-1236 N82610Elliott John O · Lathrop, MOBuilt 1946 · S/N 7AC-1250 N82611Brehmer Paul M · Eagle River, AKBuilt 1946 · S/N 7AC-1251 N82615Gebbert Larrell D · Victoria, TXBuilt 1946 · S/N 7AC-1255 N82620Debonair Consulting Inc · Wilmington, DEBuilt 1946 · S/N 7AC-1260 N82621Weeks Nancy H · Abilene, TXBuilt 1946 · S/N 7AC-1261 N82625Weisberg Perry A · Minot, NDBuilt 1946 · S/N 7AC-1265 N82626Rinker Michael D · Martin, TNBuilt 1946 · S/N 7AC-1266 N82637Snow Carol A · Rattan, OKBuilt 1946 · S/N 7AC-1280

Back to Aeronca 7AC