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.

N2529ESpofford Roger L · Luck, WIBuilt 1946 · S/N 7AC-6111 N2540EBaker Steven D · Wonewoc, WIS/N 7AC-6122 N2541EOkeefe William G · Grand Forks, NDBuilt 1946 · S/N 7AC-6123 N2547EFour Seven Echo LLC · Lenexa, KSBuilt 1947 · S/N 7AC6129 N2555EMartino John F · Kingston, NYBuilt 1946 · S/N 7AC-6138 N2562ENewell Robert J Jr · Belleville, MIBuilt 1946 · S/N 7AC-6145 N2567ELinder Arnold P · Grand Rapids, MNBuilt 1946 · S/N 7AC-6150 N2568EMackes Michael D · Gardnerville, NVBuilt 1946 · S/N 7AC-6151 N2572E2572e LLC · Newport, MEBuilt 1946 · S/N 7AC-6155 N2573EGalipeau John M · Standish, MEBuilt 1946 · S/N 7AC-6157 N2575EAlley Terry R · Augusta, KSBuilt 1946 · S/N 7AC-6158 N2578ENoles Greyson O · Willow Spring, NCBuilt 1946 · S/N 7AC-6161 N2588EMaynard Gary Michael · Princeton, NCS/N 7AC-6171 N2591EStrom Gordon B Jr · Paris, TXBuilt 1946 · S/N 7AC-6173 N2593EIdeus Dwain P · Round Rock, TXBuilt 1946 · S/N 7AC-6175 N2597EKepler Mark D · Camano Island, WABuilt 1946 · S/N 7AC-6179 N2599EPechon Sean C · Castle Rock, COS/N 7AC-6181 N259WFletcher Wayne M · Benson, AZBuilt 1946 · S/N 7AC-2972 N25NCDoyle Frank A · Ft Worth, TXBuilt 1946 · S/N 7AC-4933 N2600EAntonell George F · Warren, OHBuilt 1946 · S/N 7AC-6182 N2603EVan Hoosen Ronald L · Goldsby, OKBuilt 1946 · S/N 7AC-6185 N2604FFeroldi Jack R · Longwood, FLS/N 7AC-6186 N2606EUnerti Mark H · Waupaca, WIBuilt 1946 · S/N 7AC-6189 N2607EMcnamara Bridget · Alexandria, VAS/N 7AC-6190 N2611EJones Brenda S · Livingston, TXBuilt 1946 · S/N 7AC-6193 N2618EFranks Orlan H · Conroe, TXBuilt 1946 · S/N 7AC-6200 N2620EWatterson David A · Cypress, TXBuilt 1946 · S/N 7AC-6202 N2621EMcnutt William D · Castalian Springs, TNBuilt 1946 · S/N 7AC-6203 N2627ESweet James M · Eagan, MNBuilt 1946 · S/N 7AC-6209 N2632EMaggio Rocco · Waupaca, WIBuilt 1946 · S/N 7AC-6214 N2633EPetersburg Brian K · Decorah, IABuilt 1946 · S/N 7AC-6215 N2643EBailis David · Bethlehem, PABuilt 1946 · S/N 7AC-6225 N2645EAlbright John A · Richmond, INBuilt 1946 · S/N 7AC-6227 N2647EPierce Richard C · Kernersville, NCBuilt 1946 · S/N 7AC6229 N2651EQualitair LLC Trustee · MichelstadtS/N 7AC-6233 N2656EJoyce Jeffrey S · Carmel, INBuilt 1946 · S/N 7AC-6238 N2660EProestakis Mijali N · Cypress, TXBuilt 1946 · S/N 7AC-6242 N2661ERegistration Pending · Bunnell, FLRegistration pendingS/N 7AC-6243 N2666ESchleifer Douglas E · Columbus, OHBuilt 1946 · S/N 7AC-6248 N2670EEdwards Mark S · Ratliff City, OKBuilt 1946 · S/N 7AC-6250 N2672ESmith Frank E · Indianola, IABuilt 1946 · S/N 7AC-6252 N2677ETodd Michael E · Yelm, WABuilt 1946 · S/N 7AC-6257 N2679EKupka John J · Okeechobee, FLBuilt 1946 · S/N 7AC-6259 N267ACBarber Victor L · Blanket, TXBuilt 1946 · S/N 7AC6561 N267SASmith Fred · Houlka, MSBuilt 1946 · S/N 7AC-6107 N2685EGarner Glenwood Jr · Newport, NCBuilt 1946 · S/N 7AC-6266 N2687EAm Flite Inc · Valley, NEBuilt 1946 · S/N 7AC-6267 N2688EGawthrop Keirn R · Westfield, INBuilt 1946 · S/N 7AC-6268 N2692ENorris Ken DBA · Sumner, TXBuilt 1946 · S/N 7AC-6272 N2700ECarter Michael J · Belvidere, ILBuilt 1946 · S/N 7AC-6280

Back to Aeronca 7AC