Skip to content

Registered aircraft · 175

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 ('2110106')
  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 ('2110106')
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.

N10188Maggio Rocco M · Waupaca, WIBuilt 1947 · S/N 7BCM-4 N10450Grantham George F · Covington, LABuilt 1947 · S/N 7BCM-97 N10456Registered aircraftBuilt 1956 · S/N 7BCM-432 N10493Jarnagin William E · Brandon, FLBuilt 1956 · S/N 7BCM341 N10500Brauer Michael V · Ozark, ALBuilt 1956 · S/N 47-1183 N10504Short David · Warrensburg, MOBuilt 1956 · S/N 47-1120 N10520Eiteuner Mark P · Saint Helen, MIBuilt 1947 · S/N 47-1106 N10ANSouth Dakota Hist Avn Preservation & Educ Soc Inc · Canistota, SDBuilt 1947 · S/N 7BCM-445 N1127NPiercy Ronalds · Moses Lake, WAS/N 7BCM-88 N1189ERobert William F II · Rose Hill, KSBuilt 1946 · S/N 7BCM-4746 N119TXJulicher Mark R · Bulverde, TXBuilt 1947 · S/N 7BCM-343 N1316VKaufman Keith R · Reading, PABuilt 1947 · S/N 7BCM-446 N1326EFlies Like A Champ LLC · Powell Butte, ORS/N 7AC-4887 N1389ESpirit Of Rocky Mount LLC · Nashville, NCBuilt 1946 · S/N 7AC-4950 N139ANarus J J II · Georgetown, TNBuilt 1947 · S/N 7BCM129 N1413EHeinke Nils A · Elkins, WVBuilt 1946 · S/N 7AC-4976 N1616ELundquist Brian · Ankeny, IABuilt 1946 · S/N 7AC-5181 N1719MJohnson David H · Jasper, GAS/N 7BCM-73 N1798EStewarts Aircraft Service Inc · Waynesville, OHBuilt 1946 · S/N 7AC-5365 N1864M172 Fayette Inc · La Grange, TXBuilt 1955 · S/N 7BCM-328 N2035ACilley Sherburn C · South Royalton, VTBuilt 1947 · S/N 7BCM-246 N2036ACunningham David B · Hillsboro, ILBuilt 1947 · S/N 7BCM-248 N2048EHamilton Donis B · Paragould, ARBuilt 1946 · S/N 7AC-5618 N2086APlanes Of Fame Air Museum · Chino, CABuilt 1947 · S/N 47-1258A N2147EJ&Ks Spruce Specimens LLC · Alexandria, MNS/N 7AC-5718 N2162EMiddletown LLC · Chandler, AZBuilt 1946 · S/N 7AC-5730 N220JKHiggins Bradley J · Yerington, NVS/N 47-1171 N2222ECowels Richard L · Plainwell, MIBuilt 1946 · S/N 7AC-5796 N2292SBall Thomas R · Westlake, ORS/N 7BCM-32 N2390YStrong James R · Williamsville, NYS/N 7BCM-477 N2416YHalford William T · Hernando, MSBuilt 1956 · S/N 7BCM-90 N2498CClark William · Easton, MOS/N 7BCM-240 N249MMBishop Harold · Bonners Ferry, IDBuilt 1946 · S/N 7AC-2877 N2501BGoodrich Jeffrey W · Slaton, TXS/N 7BCM-315 N2502BVink Jason M · Palmer, AKS/N 47-1170 N2506BRunway Champ LLC · Edwardsville, ILBuilt 1947 · S/N 47-1135 N2508BMiller David S · Mount Sterling, KYS/N 47-937 N2523EWeimer Adam Jr · Fort Morgan, COBuilt 1946 · S/N 7AC-6105 N2553BAdirondack Air LLC · Wilmington, DES/N 7BCM-353 N2556BPierson Janice R Trustee · Scio, ORS/N 7BCM-485 N2558EHabedank Mark P · Twin Valley, MNBuilt 1946 · S/N 7AC-6141 N2563ESill David E · New Era, MIBuilt 1946 · S/N 7AC-6146 N2576EOlear Inc · Evansville, INBuilt 1946 · S/N 7AC-6159 N26336Agl Aero LLC · Mckinney, TXS/N 7BCM-247 N2703CArvidson Donna E · Brighton, MIS/N 7BCM-345 N2709ANorth Carolina Aviation Museum And Hall Of Fame · Asheboro, NCBuilt 1947 · S/N 7BCM-161 N2710AMakely Abraham M · Culpeper, VABuilt 1947 · S/N 7BCM-281 N2713AAlpha Enterprises Inc · Lercester, NCBuilt 1947 · S/N 7BCM-338 N2750EStuart M Davis Inc · Rice, WAS/N 7AC6331 N2777CSteiner Richard D · Butler, PABuilt 1956 · S/N 7BCM-119

Back to Aeronca 7BCM