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.

N3060Marishak Frank T Jr · Bedford, VAS/N 7AC-6649 N3062EAdair Gregory M · Collierville, TNBuilt 1946 · S/N 7AC-6651 N3063EWoodson Robert L Jr · Ft Mill, SCBuilt 1946 · S/N 7AC-6652 N3064EFisher Hoke L · Peachtree Corners, GABuilt 1946 · S/N 7AC-6653 N3066EMurray John M · Eufaula, ALBuilt 1946 · S/N 7AC-6655 N3068EWhatley Allen W · Catlett, VAS/N 7AC-6657 N3071EHendrickson Flying Service Inc · Rochelle, ILBuilt 1946 · S/N 7AC-6660 N3084EBallard Lee · Morven, GABuilt 1946 · S/N 7AC-6673 N3088ELamphere Michael · Whitehall, NYBuilt 1946 · S/N 7AC-6677 N3096ESilver Hair Air LLC · Fairfax, VABuilt 1946 · S/N 7AC-6685 N3097EBean James P · Tulsa, OKBuilt 1946 · S/N 7AC-6688 N3101EVolpp J Michael · Muncie, INBuilt 1946 · S/N 7AC-6692 N3108AMccutcheon Jeffery T · Clinton, LABuilt 1946 · S/N 7AC-6699 N3111ELochner Richard A · Eagle River, AKBuilt 1948 · S/N 7AC-6708 N3112EKuhn Darrell G · Irma, WIBuilt 1946 · S/N 7AC-6710 N3114ESmith Ronald M · Brawley, CABuilt 1946 · S/N 7AC6711 N3115EBushman Kyle P · Pleasant Hill, ORBuilt 1946 · S/N 7AC-6712 N3117EKiehle Ingrid E · Anchorage, AKBuilt 1946 · S/N 7AC-6714 N3129EMack Air LLC · Shelbyville, TNBuilt 1946 · S/N 7AC-6726 N3130ECowley Shane R · Bartlett, TXS/N 7AC-6727 N31339Mceachern Robert · Tupelo, MSBuilt 1958 · S/N 7AC-1325 N3133EViall Patricia L · Scio, ORFirst renewal noticeBuilt 1946 · S/N 7AC-6730 N31346Daacke Michael L · Glen Rock, PABuilt 1946 · S/N 7AC-1286 N3134EMuehlstein Charles W · Stamford, TXBuilt 1946 · S/N 7AC-6731 N3136EWest William T · Clarksville, VAS/N 7AC-6733 N3140EChapman Jerry L · Oakdale, MNBuilt 1946 · S/N 7AC-6737 N3144EAirpower Museum Inc · Ottumwa, IABuilt 1947 · S/N 7AC-6740 N3187Bentley Chris H · Tallahassee, FLS/N 7AC5761 N3241EAdams Harold L · Beaver, OHS/N 7AC-5578 N3276EWhite Mark E · Cold Spring, NYBuilt 1947 · S/N 7AC6764 N330WWBaker Vernon W · Springboro, OHBuilt 1946 · S/N 7AC-629 N3312EDexter Fred H · Live Oak, FLBuilt 1947 · S/N 7AC-6756 N3316EBeach Bound Baron LLC · Modena, NYBuilt 1947 · S/N 7AC-6761 N3321EGudgel Daniel R · Merced, CABuilt 1947 · S/N 7AC-6770 N3322EBudd Sharon · Rushville, NEBuilt 1947 · S/N 7AC-6771 N3325EUnderland Brian G · Atwater, MNS/N 7AC-6784 N3335EVawter William R Jr · Fort Worth, TXBuilt 1947 · S/N 7AC-6785 N3336ENoga Gwain J · Youngstown, OHS/N 7AC-6786 N333WBGammill David R · Tyronza, ARBuilt 1947 · S/N 7AC-3461 N3340ERichardson Michael T · Inver Grove, MNS/N 7AC-6790 N3342ESpears Patricia C · Longmont, COBuilt 1947 · S/N 7AC-6792 N3348DDuke Robert D · Darrouzett, TXFirst renewal noticeBuilt 1946 · S/N 7AC-3348 N3370EBas Part Sales LLC · Greeley, COBuilt 1947 · S/N 7AC-6778 N3372ETracy Johnny L · Troy, MOBuilt 1947 · S/N 7AC-6798 N3374ESlone Donald L · Holden, MOS/N 7AC-6800 N3390EReid Dale L · Eau Claire, WIBuilt 1947 · S/N 7AC-6808 N3390RNuckles Charles A Jr · Suffolk, VABuilt 1946 · S/N 7AC-1700 N3409EHerrema Scott · White Cloud, MIBuilt 1947 · S/N 7AC-6822 N3418ELauer Raymond C · Amissville, VABuilt 1947 · S/N 7AC-6826 N3424EDowdy John H · Union, WVBuilt 1947 · S/N 7AC-6829

Back to Aeronca 7AC