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.

N85192Daphna Inc · Middletown, DEBuilt 1946 · S/N 7AC-3925 N85194Gray Rex L · Palmer, AKBuilt 1946 · S/N 7AC-3927 N85198Bootz Patrick C · Lemmon, SDBuilt 1946 · S/N 7AC-3931 N85199Osprey Holding Company LLC · Foley, ALBuilt 1946 · S/N 7AC-3932 N85207Blome Terry L · Pleasant Plains, ILS/N 7AC3940 N85216Russell Christopher Nicholas · Everett, WAS/N 7AC-3949 N85222Dm Asset Management LLC · Plain City, OHS/N 7AC-3955 N85223Gautreau Peter F · Chickaloon, AKBuilt 1946 · S/N 7AC-3956 N85225Bushby Harvey M · Minooka, ILBuilt 1946 · S/N 7AC-3958 N85226Hosmer Richard S · Baileyton, ALBuilt 1946 · S/N 7AC-3960 N85227Seesholtz Bros Inc · Bloomsburg, PABuilt 1946 · S/N 7AC-3961 N85229Fowler Bradley · Madisonville, KYBuilt 1946 · S/N 7AC-3963 N85234Decker Kenneth W · Ottawa, OHBuilt 1946 · S/N 7AC-3968 N85244Liljenberg Gary W · Broolyn, OHBuilt 1946 · S/N 7AC-3978 N85247Free Richard D · Clearwater, KSBuilt 1946 · S/N 7AC-3981 N85248Rishovd Thomas A II · Elk River, MNBuilt 1946 · S/N 7AC-3982 N85251Baeder Ryan M · West Bloomfield, MIBuilt 1946 · S/N 7AC-3985 N85252Murphy Marcus P · Williamson, GABuilt 1946 · S/N 7AC-3986 N85254Orback Michael J · Loveland, COBuilt 1946 · S/N 7AC-3988 N85255Berkley William H Jr · Montgomery, TXBuilt 1946 · S/N 7AC-3989 N85259Jeffryes Richard B · Creswell, ORBuilt 1946 · S/N 7AC-3993 N85262Winchell Larry · Salem, NJBuilt 1946 · S/N 7AC-3997 N85265Southard Ron L · Lincoln, DEBuilt 1946 · S/N 7AC-4000 N85276Wildy David D · Manila, ARBuilt 1946 · S/N 7AC-4011 N85277Perry Jack S · New Auburn, WIBuilt 1946 · S/N 7AC-4015 N85278Dendy Dwight E · Caledonia, ILBuilt 1946 · S/N 7AC-4016 N85279Larue Mark C · Leander, TXBuilt 1946 · S/N 7AC-4017 N85281Weinhandl Lee A · Mandan, NDBuilt 1946 · S/N 7AC-4019 N85284Nebraska Antique Airplane Preservation Inc · Wynot, NEBuilt 1946 · S/N 7AC-4022 N85286Houndy Aviation LLC · Suffolk, VABuilt 1946 · S/N 7AC4024 N85288Vincent Raymond A · Plymouth, MIBuilt 1946 · S/N 7AC-4026 N85290Mcgee Stacy Marie · Portola, CABuilt 1946 · S/N 7AC-4028 N85291Phelps Lawrence D · Vinton, IABuilt 1946 · S/N 7AC-4029 N85292Short David J · Warrensburg, MOS/N 7AC-4030 N85293Willis Nelson W · Lebanon, TNBuilt 1946 · S/N 7AC-4031 N85294Burch Daniel C · Osceola, WIBuilt 1946 · S/N 7AC4032 N85301Desjarlais Kaleb · Anchorage, AKBuilt 1946 · S/N 7AC-4039 N85302Green Dwayne C · Santa Rosa, CABuilt 1946 · S/N 7AC-4040 N85308Travland Lewis H · Alpine, TXBuilt 1946 · S/N 7AC-4046 N85312Townsley Michael F · Deep River, IABuilt 1946 · S/N 7AC-4051 N85313Howell Nicholas A · Englewood, COBuilt 1946 · S/N 7AC-4052 N85314Parobek Edward G · Cincinnati, OHBuilt 1946 · S/N 7AC-4053 N85317Adamko Victor W · Riley, MIBuilt 1946 · S/N 7AC-4056 N85329Bahmann Frank · Dade City, FLBuilt 1946 · S/N 7AC-4068 N85331King William A · North Java, NYBuilt 1946 · S/N 7AC-4070 N85335Zimmerman Arnold A · Ava, MOBuilt 1946 · S/N 7AC-4074 N85337Port Townsend Aero Museum · Port Townsend, WAS/N 7AC-4076 N85338Minor J Mark · Rockledge, FLBuilt 1946 · S/N 7AC-4077 N85344Krog Donald C · Somerville, NJBuilt 1946 · S/N 7AC-4084 N85349Paine Oliverb III · Fulton, NYBuilt 1946 · S/N 7AC-4089

Back to Aeronca 7AC