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.

N84423Snyder David · Port Saint Lucie, FLBuilt 1946 · S/N 7AC-3121 N84427Wieman Dianne L · Marion, TXFirst renewal noticeBuilt 1946 · S/N 7AC-3124 N84428Warner James B Jr · Lincoln, NEBuilt 1946 · S/N 7AC-3128 N84430Huizenga Larry O · Minot, NDBuilt 1946 · S/N 7AC-3127 N84431Petrie Robert J · Eagleville, TNBuilt 1946 · S/N 7AC-3134 N84433Willis James Roger · Belleview, FLBuilt 1954 · S/N 7AC-3131 N84447Ford Irby M · Pflugerville, TXBuilt 1946 · S/N 7AC-3141 N84450Beem Keith B · Clifton Park, NYS/N 7AC-3147 N84453Yennaco James F · Pepperell, MABuilt 1946 · S/N 7AC-3155 N84458Petty Edwin · Clanton, ALBuilt 1946 · S/N 7AC-3153 N84469Johnson Vernon C · Caledonia, NYBuilt 1946 · S/N 7AC-3165 N84480Champagne Richard W · Amelia Court House, VABuilt 1946 · S/N 7AC-3182 N84482Ghafouri Mohsen · Murrieta, CABuilt 1946 · S/N 7AC-3179 N84483Moore Eugene K · Portsmouth, OHBuilt 1946 · S/N 7AC-3181 N84485Nelson Jerry Leroy · Bronson, MIBuilt 1946 · S/N 7AC-3187 N84498Wald Leo F · Haines, AKBuilt 1946 · S/N 7AC-3198 N84499Buehler Andrew C · Eatonville, WAS/N 7AC3195 N84504Ebert Larry · Ashton, ILBuilt 1946 · S/N 7AC-3206 N84506Jjbk LLC · Bancroft, NEBuilt 1946 · S/N 7AC-3207 N84517Knutson Wayne R · Tioga, NDBuilt 1946 · S/N 7AC-3215 N84520Hagedorn Matthew J · Prineville, ORBuilt 1946 · S/N 7AC-3225 N84522Peak Development Group Ubo · Gallatin Gateway, MTBuilt 1946 · S/N 7AC-3221 N84525Augustin Caleb J · Madison, ALBuilt 1946 · S/N 7AC-3226 N84534Inman Dentis · Whiteville, TNBuilt 1946 · S/N 7AC-3233 N84538Raser Gary D · Birdsboro, PABuilt 1946 · S/N 7AC-3241 N84539Harry Thomas C · Boiling Springs, PABuilt 1946 · S/N 7AC-3236 N84542Jones Duane R · New Carlisle, OHBuilt 1946 · S/N 3243 N84545Miller Cheryl B · Goode, VABuilt 1946 · S/N 7AC-3239 N8454CJohn Linda M · Heathsville, VAS/N 7AC-3261 N84550Huber Jacob P · Blue Earth, MNBuilt 1946 · S/N 7AC-3252 N84553Szewczyk Vincent F · Boonville, NYBuilt 1946 · S/N 7AC-3256 N84554Mostad James A · Minot, NDBuilt 1946 · S/N 7AC-3254 N84555Sandland Patrick W · Wasilla, AKS/N 7AC-3264 N84556Jeffryes Richard B · Creswell, ORBuilt 1946 · S/N 7AC-3253 N84557Schwichtenberg David A · Jordan, MNBuilt 1946 · S/N 7AC-3265 N84564Havener Hunter W · Chittenango, NYBuilt 1946 · S/N 7AC-3268 N84565Delaney Kevin P · Germantown, TNBuilt 1946 · S/N 7AC-3267 N84572Hartley Roger L · Moatsville, WVBuilt 1946 · S/N 7AC-3281 N84583Garcia Cabral Carlos N · Venetia, PABuilt 1946 · S/N 7AC-3286 N84589Simpson Eugene W · Mount Gilead, NCBuilt 1946 · S/N 7AC-3294 N84591Parkes Kenneth J · Middleburgh, NYBuilt 1946 · S/N 7AC-3297 N84597Neal Craig L · Melissa, TXBuilt 1946 · S/N 7AC-3302 N84605Sauter Allen · Bismarck, NDBuilt 1946 · S/N 7AC-3318 N84606Gregory Robert H · Glenwood, MNBuilt 1946 · S/N 7AC-3317 N84608Artlip James R · Wake Forest, NCBuilt 1946 · S/N 7AC-3319 N84609Danielson David · Hibbing, MNBuilt 1946 · S/N 7AC-3316 N84610Boatright Michael L · Live Oak, FLBuilt 1946 · S/N 7AC-3306 N84614Lokken Myron L · Madison, WIBuilt 1946 · S/N 7AC-3325 N84616Greenbrier Aviation LLC · Sevierville, TNBuilt 1946 · S/N 7AC-3322 N84618Cowley James B · Sulphur Springs, TXBuilt 1946 · S/N 7AC-3327

Back to Aeronca 7AC