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.

N81787Mikkelson William M · West Bend, WIBuilt 1945 · S/N 7AC-410 N81789Franks David · Rices Landing, PABuilt 1945 · S/N 7AC-412 N8178ASkowbo Rock G · Palatka, FLBuilt 1945 · S/N 7AC-407 N81790Statkus Stephen P · Cincinnati, OHBuilt 1945 · S/N 7AC-413 N81792Doughty Robert W · Casa Grande, AZBuilt 1946 · S/N 7AC-415 N81804Hicks Richard T · Statesville, NCBuilt 1945 · S/N 7AC-427 N81813Pippenger Jason S · Albion, INBuilt 1945 · S/N 7AC-436 N81824Sell Scott F · Moody, TXBuilt 1945 · S/N 7AC-447 N81825King Daniel A · Midland, VABuilt 1945 · S/N 7AC-448 N81829Small Mark B · Walla Walla, WABuilt 1945 · S/N 7AC-452 N81840Graves Jed · Proctor, MNS/N 7AC-463 N81841Hayes Victor R · Columbus, MIBuilt 1946 · S/N 7AC-464 N81855Pegasus Flyers Inc · Saylorsburg, PABuilt 1946 · S/N 7AC-478 N81856Hendrickson Todd R · Woodstock, ILS/N 7AC-479 N81867Far North Aviation LLC · Fargo, NDBuilt 1946 · S/N 7AC-490 N81870Desnoyer George M · Merrill, WIBuilt 1946 · S/N 7AC-493 N81878Mcclave Wilkes III · Hanover, NHBuilt 1946 · S/N 7AC-501 N81881Quayle John P · Pleasanton, CABuilt 1946 · S/N 7AC-504 N81886Hartfield Storage LLC · Mayville, NYBuilt 1946 · S/N 7AC-509 N81887Mccleary William D · Montoursville, PABuilt 1946 · S/N 7AC-510 N81889Custer Nathan James · Friedens, PABuilt 1946 · S/N 7AC-512 N81900Burns Joe D · Scottsville, NYBuilt 1946 · S/N 7AC-523 N81903Pumphrey Ronald W · Houston, MSBuilt 1946 · S/N 7AC-526 N81913Ardizone Robert G · Mckinney, TXBuilt 1946 · S/N 7AC-536 N81924Potkin Mark R · Chico, CABuilt 1946 · S/N 7AC-549 N81928Lingwall John C · Peyton, COBuilt 1946 · S/N 7AC-553 N81930Jones Victor A A · Delaware, OKS/N 7AC-555 N81933Kendall James W · Sherwood, ORBuilt 1946 · S/N 7AC-558 N81935Lambkin John C · Grand Rapids, MIBuilt 1946 · S/N 7AC-560 N81939Johnson David H · Jasper, GABuilt 1946 · S/N 7AC-564 N81946Potter Charles W · Clover, SCBuilt 1946 · S/N 7AC-571 N81948Senseney Michael B · Kathleen, GABuilt 1946 · S/N 7AC-573 N81966Payne Robert · Lewiston, IDBuilt 1946 · S/N 7AC-591 N81967Miller Shane A · Edgemont, SDBuilt 1946 · S/N 7AC-592 N81971Holmgren David J · Plainfield, NJFirst renewal noticeBuilt 1946 · S/N 7AC-4399 N81975Krejchik Daniel J · Portage, WIBuilt 1946 · S/N 7AC-600 N81979Sabella Jacob · Wentzville, MOS/N 7AC-604 N81983Peet James L · Valley Springs, CABuilt 1946 · S/N 7AC-608 N81985Dewinter James A · Ludlow Falls, OHBuilt 1946 · S/N 7AC-610 N81986Sullivan Daniel S · Fayetteville, GABuilt 1946 · S/N 7AC-611 N81989Olvera Jose Carlos Trejo · Belton, SCBuilt 1946 · S/N 7AC-614 N81BDGrondin Chris · Danforth, MEBuilt 1946 · S/N 7AC-6569 N81JHSmith William D · San Antonio, TXBuilt 1945 · S/N 7AC-57 N82003Bugsmashers Inc · San Miguel, CABuilt 1946 · S/N 7AC-628 N82007Caldwell George A · Fairhope, ALBuilt 1946 · S/N 7AC-632 N82012Thomson Mary Ellen · East Berlin, PABuilt 1946 · S/N 7AC-637 N82014Mendenhall Lauri P · Ann Arbor, MIBuilt 1946 · S/N 7AC-640 N82015Craig John S Jr · Glenburn, MEBuilt 1946 · S/N 7AC-641 N82029Sarason Jay A · Monte Vista, COBuilt 1946 · S/N 7AC-655 N82038Peder Alexander E · Kirkland, WAS/N 7AC-664

Back to Aeronca 7AC