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.

N82040Shamburg Daniel John · Tekamah, NEBuilt 1946 · S/N 7AC-666 N82042Neubauer Michael A · Port Angeles, WABuilt 1946 · S/N 7AC-668 N82050Scheiner Brett S · Newberg, ORBuilt 1946 · S/N 7AC-676 N82052Medlin Kenneth O · Raleigh, NCBuilt 1946 · S/N 7AC-678 N82059Studer Rod J · Shelby, MIBuilt 1946 · S/N 7AC-685 N82062Huffman Jacob M III · Burleson, TXBuilt 1946 · S/N 7AC-688 N82070Hall Larry D · Conesus, NYBuilt 1946 · S/N 7AC-696 N82072Thorne John S · Woodland Hills, CABuilt 1946 · S/N 7AC-698 N82074Audo Michael J · Gobles, MIBuilt 1946 · S/N 7AC-700 N82080Klomparens Zachary R · Lawton, MIBuilt 1946 · S/N 7AC-706 N82088Stegeman Tim · South Haven, MIS/N 7AC-714 N82093Oborny Alan R · Choteau, MTBuilt 1946 · S/N 7AC-719 N82098Arbaugh Joanne N · Harbor Springs, MIBuilt 1946 · S/N 7AC-724 N82101Sutherland Johnny Leon · Goldthwaite, TXBuilt 1946 · S/N 7AC-727 N82103Petro Jerry R · Williamsburg, VABuilt 1946 · S/N 7AC-729 N82104Caulkins Howell V · Chico, CABuilt 1946 · S/N 7AC-730 N82105Ennis Michael J · Eminence, MOBuilt 1946 · S/N 7AC-731 N82107Mclavy Michael J · Puyallup, WABuilt 1946 · S/N 7AC-733 N82113Strain D Bret · White River, SDBuilt 1946 · S/N 7AC-739 N82117Johnson Scott E · Union Bridge, MDBuilt 1946 · S/N 7AC-743 N82125J & D Services Inc · Wilmington, DEBuilt 1946 · S/N 7AC-751 N82129Gruhlkey Cameron T · Dalhart, TXBuilt 1946 · S/N 7AC-755 N82134El Paso Flying Service LLC · El Paso, ILBuilt 1946 · S/N 7AC-760 N82135Willis Roger · Belleview, FLBuilt 1946 · S/N 7AC-761 N82137Abbott Dylan L · Lompoc, CABuilt 1946 · S/N 7AC-763 N82138Abrahamson Duane E · Manawa, WIBuilt 1946 · S/N 7AC-764 N82140Bingham Sammy J · Manvel, TXBuilt 1946 · S/N 7AC-766 N82142Snell Gary A · Dresden, MEBuilt 1946 · S/N 7AC-768 N82146Sale Reported · Williamson, NYSale reportedBuilt 1946 · S/N 7AC-772 N82147Sipes Robert L · Mound City, MOBuilt 1946 · S/N 7AC-773 N82151Gramke Thomas · Tekamah, NES/N 7AC-777 N82153Catlin Vaughn H · Mardela Springs, MDS/N 7AC-779 N82154Hutter Charles G · Carson City, NVBuilt 1946 · S/N 7AC-780 N82159Morris Larry R · Guntersville, ALBuilt 1946 · S/N 7AC-785 N82160Coop David L · Albia, IABuilt 1946 · S/N 7AC-786 N82170Colombe George L · Wentworth, SDBuilt 1946 · S/N 7AC-796 N82179Sibbitt Alice N · Chandler, AZBuilt 1946 · S/N 7AC-806 N82181Hester James T · Fayetteville, GABuilt 1946 · S/N 7AC-809 N82183Westland Mark Eric · Saint George, UTBuilt 1946 · S/N 7AC-810 N82184N82184 LLC · Indianapolis, INS/N 7AC-811 N82187Dolder Gary E · Waterman, ILBuilt 1946 · S/N 7AC-814 N82200Markwood Hannah E · Anchorage, AKS/N 7AC828 N82201Mgs Ventures Ltd · Wilmington, DES/N 7AC-829 N82202Air-K Enterprises LLC · Weirsdale, FLBuilt 1946 · S/N 7AC-830 N82205Mcinerny Charles H Jr · Dansville, NYBuilt 1946 · S/N 7AC-833 N82215Robinson Michael F · Decatur, ALBuilt 1946 · S/N 7AC-843 N82219Myakka Head Aviation LLC DBA · Bradenton, FLS/N 7AC-847 N82220Snyder Jason D DBA · Oakland, MDBuilt 1946 · S/N 7AC-848 N82230Grieser James K · Wauseon, OHBuilt 1946 · S/N 7AC-858 N82234Long Kenneth L · Everett, WABuilt 1946 · S/N 7AC-862

Back to Aeronca 7AC