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.

N83031Par 21 LLC · Ripon, WIBuilt 1946 · S/N 7AC-1687 N83032Vintage Flying Club · Ankeny, IAS/N 7AC-1688 N83034Mccarley Billy B · Gatesville, TXBuilt 1946 · S/N 7AC-1690 N83042Beams Stephen J · Jericho, VTS/N 7AC-1697 N83046Merrell Shane F · Shelby, ALBuilt 1946 · S/N 7AC-1702 N83048Hamilton James C · Ann Arbor, MIBuilt 1946 · S/N 7AC-1704 N83058Rice David C · Murphys, CABuilt 1946 · S/N 7AC-1714 N83059Young Frederick E · Yuba City, CABuilt 1946 · S/N 7AC-1715 N83062White Eagle II LLC · Asheville, NCS/N 7AC-1718 N83065Peck Michael O · Seguin, TXBuilt 1946 · S/N 7AC-1721 N83067Bohnert Anthony W · Houston, TXBuilt 1946 · S/N 7AC-1723 N83074Green Stephen · Fayette City, PABuilt 1946 · S/N 7AC-1732 N83075Howe Adam J · Shaftsbury, VTBuilt 1946 · S/N 7AC-1728 N83082Olson Owen B · Jamestown, NDBuilt 1946 · S/N 7AC-1738 N83092Baxter Gail L · Rock Hill, SCBuilt 1946 · S/N 7AC-1749 N83096Burraston Lloyd D · North Salt Lake, UTBuilt 1946 · S/N 7AC-1753 N83098Leonardi William J · Manorville, NYBuilt 1946 · S/N 7AC-1755 N83101Jones Duane R · New Carlisle, OHBuilt 1946 · S/N 7AC-1758 N83102Hetherington Releigh · Panama, OKS/N 7AC-1759 N83114Screws Elisha J · Owens Cross Roads, ALBuilt 1946 · S/N 7AC-1772 N83119Ricard John E · Albany, MNS/N 7AC-1777 N83120Schoetimer Thomas C · Greensburg, INBuilt 1946 · S/N 7AC-1778 N83123Gibson Scott W · Little York, ILBuilt 1946 · S/N 7AC-1781 N83141Vx Aircraft Services LLC · Batesville, ARBuilt 1946 · S/N 7AC-1802 N83143Cimprich Joseph P · Camden, OHBuilt 1946 · S/N 7AC-1804 N83147Clardy E Dennis · Mountain View, ARBuilt 1946 · S/N 7AC-1808 N83152Rowe Henry G · Mexico, NYBuilt 1946 · S/N 7AC-1813 N83163Whipple Kenneth G · Nyssa, ORBuilt 1946 · S/N 7AC-1824 N83167Ayers Mark T · Whitney, TXBuilt 1946 · S/N 7AC-1828 N83168Madsen Theodore W · Gillette, WYBuilt 1946 · S/N 7AC-1829 N83169Hopkins Scott D · Wasilla, AKBuilt 1946 · S/N 7AC-1830 N83173Fenwick Scott Andrew · Kill Devil Hills, NCBuilt 1946 · S/N 7AC-1835 N83174Lepanto Crop Service Inc · Lepanto, ARBuilt 1946 · S/N 7AC-1836 N83175Honaker Shawn · Sellersburg, INBuilt 1946 · S/N 7AC-1834 N83185Ruhl Timothy E · Magnolia, TXBuilt 1946 · S/N 7AC-1846 N83189Campbell Charles Melvin · Dallas, NCBuilt 1946 · S/N 7AC-1850 N83192Miller William Alan · Williamson, GABuilt 1946 · S/N 7AC-1853 N83199Andrews Willard R · Windham, MES/N 7AC-1860 N83200Rbj Ranchwest LLC · Elroy, WIS/N 7AC-1861 N83201Mcbroom Ray E · Conroe, TXBuilt 1946 · S/N 7AC-1862 N83204Grimes Kenneth · Charlotte, NCS/N 7AC-1865 N83215Smiley Neil G · Clover, VABuilt 1946 · S/N 7AC-1876 N83216Lewis Peter D · Starksboro, VTBuilt 1946 · S/N 7AC-1877 N83217Wtflying Club LLC · Hanover, PABuilt 1946 · S/N 7AC-1878 N83219Dawes Thomas R · Bemus Point, NYBuilt 1946 · S/N 7AC-1880 N83226High Plains Aviation LLC · Caro, MIBuilt 1946 · S/N 7AC-1887 N83227Klosterman Aviation LLC · Celina, OHS/N 7AC-1889 N83228Weiss Elliott · Fresno, TXBuilt 1946 · S/N 7AC-1888 N83234Mattson Douglas R · Ironwood, MIBuilt 1946 · S/N 7AC-1898 N83239Vaughan Glenn M · Beavercreek, OHBuilt 1946 · S/N 7AC-1904

Back to Aeronca 7AC