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.

N83241Kay Michael A · Peru, INBuilt 1946 · S/N 7AC-1903 N83244Howe Mark E · Lake Stevens, WABuilt 1946 · S/N 7AC-1906 N83247Owens Russell D · Lake Forest, CAS/N 7AC-1911 N83248Search And Rescue Inc · Swatara, MNBuilt 1946 · S/N 7AC-1914 N83250Bradley James M DBA · Fort White, FLBuilt 1946 · S/N 7AC-1913 N83251Wilkerson Mark A · Madison, INS/N 7AC1915 N83261Maki Fred E · Baltimore, OHBuilt 1946 · S/N 7AC-1925 N83264Johnston Daniel T · Cambridge, OHBuilt 1946 · S/N 7AC-1928 N83267Wright Robert A · Raeford, NCBuilt 1946 · S/N 7AC1931 N83276Cook Timothy L · Oklahoma City, OKBuilt 1946 · S/N 7AC-1940 N83277Bessett Daniel · Lowell, ORBuilt 1946 · S/N 7AC-1941 N83279Brinkerhoff Arthur J · Granbury, TXS/N 7AC1943 N83282Orton Edson · Memphis, MORegistration revokedBuilt 1946 · S/N 7AC1949 N83289Mcnicoll Steven P · Depere, WIBuilt 1946 · S/N 7AC-1956 N83291Rh Resources LLC · Baker, FLBuilt 1946 · S/N 7AC-1959 N83293Weatherford Dennis W · West Plains, MOBuilt 1946 · S/N 7AC-1960 N83295Steffey Charles S · Raleigh, NCBuilt 1946 · S/N 7AC-1962 N83300Dennis John Mark L · Paola, KSS/N 7AC-1967 N83303Rackley Steven P · Livermore, CABuilt 1946 · S/N 7AC-1970 N83304Lorenz Brian J Trustee · Ballwin, MOBuilt 1946 · S/N 7AC-1971 N83308Clinton Richard C · Fair Oaks, CABuilt 1946 · S/N 7AC-1975 N83309Del Martin Lp · Spring, TXS/N 7AC-1976 N83311Ballard Alexander Jr · Conneaut Lake, PAS/N 7AC-2034 N83314Hampton Michael D · Marshfield, MOBuilt 1946 · S/N 7AC-1979 N83317Hughes Michael C · Wasilla, AKS/N 7AC-1982 N83320Lynn Lonnie A · Jesup, GABuilt 1946 · S/N 7AC-1987 N83321Lovern Steven B · Newton, NCBuilt 1946 · S/N 7AC-1988 N83322Mister Jonathan · Roaring Spring, PABuilt 1946 · S/N 7AC-1989 N83323Kijowski Thomas C · Freeport, PABuilt 1946 · S/N 7AC-1990 N83327Olear Inc · Evansville, INBuilt 1946 · S/N 7AC-1994 N83333Chipman Jeff M · Rising Sun, INBuilt 1946 · S/N 7AC-2000 N83336Pease Gordon W · Hampden, MEFirst renewal noticeBuilt 1946 · S/N 7AC-2003 N83340Brekhus Susan Marie Wissler · Tenino, WABuilt 1946 · S/N 7AC-2007 N83341Herridge Douglas E · Tacoma, WABuilt 1946 · S/N 7AC-2008 N83342Cummins Michael V · Modesto, CAS/N 7AC-2009 N83352Deckard Audie T · Independence, ORBuilt 1946 · S/N 7AC-2019 N83355Krueger Steven A · Merrill, WIBuilt 1946 · S/N 7AC-2022 N83360Sankey Paul F · Colusa, CABuilt 1946 · S/N 7AC-2027 N83363Van Bergen Mark S · Soquel, CABuilt 1946 · S/N 7AC-2030 N83366Texas Warbirds LLC · Lewes, DEBuilt 1946 · S/N 7AC-2033 N83369Bellamy John-Mark · Freeville, NYS/N 7AC-2036 N83385Nelson William J · Mahnomen, MNBuilt 1946 · S/N 7AC-2052 N83388Grubs Jon P · White Bear Lake, MNBuilt 1946 · S/N 7AC-2055 N83389Snyder Michael Scott · Erie, COS/N 7AC-2056 N83393Jasinski Jack J · Necedah, WIBuilt 1946 · S/N 7AC-2060 N83399Latimer Francis E · Washingtonville, NYBuilt 1946 · S/N 7AC-2066 N83401Macario Mark A · Weirsdale, FLBuilt 1946 · S/N 7AC-2068 N83405Banner Bernard C Jr Trustee · Lawrenceburg, INS/N 7AC-2072 N83407Travis Johnathan M · Griffin, GABuilt 1946 · S/N 7AC2075 N83409David P St George · Ithaca, NYBuilt 1946 · S/N 7AC-2076

Back to Aeronca 7AC