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.

N82639Cloud Joe E · Kenai, AKBuilt 1946 · S/N 7AC-1281 N82643Hendrickson Gary A · Chico, CAS/N 7AC-1285 N82650Mjj Aircraft Inc · Wilmington, DES/N 7AC-1292 N82655Boatright Kyle W · Marietta, GABuilt 1946 · S/N 7AC-1294 N82658Kimbrough Dan M · Mc Minnville, TNBuilt 1946 · S/N 7AC-1303 N82660Stalls Matthew B · Denver, COBuilt 1946 · S/N 7AC-1301 N82662Fisher Douglas W · Holton, KSBuilt 1946 · S/N 7AC-1302 N82666Woode Denico · Fort Riley, KSBuilt 1946 · S/N 7AC-1306 N82672Duerkop Burnell · Rockland, WIBuilt 1946 · S/N 7AC-1314 N82677Walker Jeffrey P · Warwick, NYBuilt 1946 · S/N 7AC-1318 N82680Hoffman Edward C · Tarpon Springs, FLBuilt 1946 · S/N 7AC-1322 N82681Herold Dana R · Mcminnville, ORBuilt 1946 · S/N 7AC-1323 N82686Boucher Kenneth G · Scotland, CTBuilt 1955 · S/N 7AC-1332 N82694Henderson Norman L · Bowling Green, MOS/N 7AC-1336 N82701Woldow Fredric A · Morton, ILBuilt 1946 · S/N 7AC-1345 N82703Duffy William J · Cincinnati, OHS/N 7AC-1347 N82704Ferry Eugene M · Lander, WYBuilt 1946 · S/N 7AC-1352 N82705Couvillion Rickey J · Lafayette, LAS/N 7AC-1351 N82711N82711 LLC · Mesa, AZS/N 7AC-1357 N82721Godra Michael A · Oxford, PABuilt 1946 · S/N 7AC1368 N82724Trail William H · Reidsville, NCBuilt 1948 · S/N 7AC-1371 N82730Scott Tabb E · Clyde, TXBuilt 1946 · S/N 7AC-1377 N82733Green Vernon G · Rolla, MOBuilt 1946 · S/N 7AC-1380 N82734Shaw Timothy G · Columbus, INBuilt 1946 · S/N 7AC-1381 N82739Odom Jack G · Cabot, ARS/N 7AC-1386 N82742Sellick Kim L · Kingston, WABuilt 1946 · S/N 7AC-1389 N82747Hood Timothy G Jr · Morrison, ILBuilt 1946 · S/N 7AC-1394 N82752Massey Edward R · Union, MSBuilt 1946 · S/N 7AC-1399 N82758Cheal Finley · Eugene, ORBuilt 1946 · S/N 7AC-1405 N82759Rock River Flyers · Mount Morris, ILS/N 7AC-1406 N8275EHay Charles Kevin · Peachtree City, GAS/N 7AC-1398 N82762Buffkin Louis G · Creola, ALBuilt 1946 · S/N 7AC-1409 N82764Jo E Rankin · Maryville, MOBuilt 1946 · S/N 7AC-1411 N82766Midway Aviation Co · Plant City, FLBuilt 1946 · S/N 7AC-1413 N82767Kent Keith M · Ellijay, GABuilt 1946 · S/N 7AC-1414 N82768Beasley Charles A · Spencer, VABuilt 1946 · S/N 7AC-1415 N82771Doherty Joseph G · Le Sueur, MNBuilt 1946 · S/N 7AC-1418 N82773Horst Sheldon L · Columbia, PABuilt 1946 · S/N 7AC-1420 N82777Cromwell Marlena A · Napa, CABuilt 1946 · S/N 7AC-1424 N82780Zerovich Karl · Cortland, OHBuilt 1946 · S/N 7AC-1427 N82781Schmid Ayden J · Lagrangeville, NYBuilt 1946 · S/N 7AC-1428 N82787Kaufman Timothy B · Charlotte, NCBuilt 1946 · S/N 7AC-1434 N82789Grieser James K · Wauseon, OHBuilt 1946 · S/N 7AC-1436 N82796Holt Worthe S Jr · Fishers, INBuilt 1946 · S/N 7AC-1443 N82802Kimbrel Martin E · Oakville, WABuilt 1946 · S/N 7AC-1449 N82805Cheatham Paul · La Verne, CABuilt 1946 · S/N 7AC-1452 N82809Seven Acee LLC · Alexander City, ALBuilt 1946 · S/N 7AC-1456 N82812Gibson Randy L · Clinton, TNBuilt 1946 · S/N 7AC-1459 N82816Ficklin Robert L · Fairbury, ILBuilt 1946 · S/N 7AC-1463 N82819Fitzgerald Cynthia J · Bedford, NHS/N 7AC-3362

Back to Aeronca 7AC