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.

N84181Purcell David S · Chandler, AZBuilt 1946 · S/N 7AC-2869 N84184Waterman David N DBA · Amery, WIBuilt 1946 · S/N 7AC-2872 N84198Jack Jeremiah Russell · Napa, CABuilt 1946 · S/N 7AC-2886 N84203Harter Michael R · Greenfield, INS/N 7AC-2894 N84206Sale Reported · West Richland, WASale reportedBuilt 1946 · S/N 7AC-2897 N84215Hardy Randall B · Argyle, TXBuilt 1946 · S/N 7AC-2906 N84218Feeney Francis Kevin · Spencer, NYBuilt 1946 · S/N 7AC-2909 N84222Ornelaz Bernice R · San Jose, CABuilt 1946 · S/N 7AC-2913 N84228Marshall Donald R · Cape Girardeau, MOBuilt 1946 · S/N 7AC-2919 N84230Yuri Flyers LLC · Kalamazoo, MIBuilt 1946 · S/N 7AC-2922 N84232Koehler Steven W · New Braunfels, TXBuilt 1946 · S/N 7AC-2924 N84238Simmons Rita B · Saint George, MEBuilt 1946 · S/N 7AC-2930 N84241Kuhn Darrell G · Irma, WIBuilt 1946 · S/N 7AC-2933 N84242Steck Paul D · Pelham, NHBuilt 1946 · S/N 7AC-2934 N84246Light Flight Balloons Inc · Bel Air, MDBuilt 1946 · S/N 7AC-2938 N84252Calk Mark C · Troy, ALBuilt 1946 · S/N 7AC-2944 N84254Middleton Steven H · Monroe, NCBuilt 1946 · S/N 7AC-2946 N84255Black James W · Kenly, NCS/N 7AC-2947 N84268Zvada Stephen P · Wadsworth, OHBuilt 1946 · S/N 7AC-2958 N84269Super Cub Flyers Inc · Tower, MNBuilt 1946 · S/N 7AC-2963 N84273Olympic Flight Museum · Olympia, WABuilt 1946 · S/N 7AC-2965 N84276Farnham Aviation Services LLC · Ames, IAS/N 7AC-2969 N84281Clarke Casey D Trustee · Gorham, NHBuilt 1946 · S/N 7AC-2975 N84286Steffens Gerald J · Seymour, WIBuilt 1946 · S/N 7AC-2980 N84290Henley Clint A · Manchester, TNBuilt 1946 · S/N 7AC-2984 N84292Farrell Arlene D · Schroon Lake, NYFirst renewal noticeBuilt 1946 · S/N 7AC-2986 N84295Sharpe Becky L · Neenah, WIBuilt 1946 · S/N 7AC-2989 N84296Spuza Dan D · Sanger, TXBuilt 1946 · S/N 7AC-2990 N84303Center State Aircraft LLC · Dover, DEBuilt 1946 · S/N 7AC-3000 N84304Ennis Shannon E · Chesapeake, VABuilt 1946 · S/N 7AC-2999 N84306Petes Flight Inc · La Porte, INBuilt 1946 · S/N 7AC-3001 N84310Porter Kelton B · Homer, AKBuilt 1946 · S/N 7AC-3004 N84312Goodman Ronald A · Dos Palos, CABuilt 1946 · S/N 7AC-3007 N84314Crooke Michael J · Charlotte, NCBuilt 1946 · S/N 7AC-3009 N84318Unertl Mark H · Waupaca, WIBuilt 1946 · S/N 7AC-3018 N84319Connell Flying Service Inc · Decorah, IABuilt 1946 · S/N 7AC-3013 N84320Falls Dennis A · Olathe, KSBuilt 1946 · S/N 7AC-3014 N84321Hintz Courtney N · San Antonio, TXBuilt 1946 · S/N 7AC-3015 N84325Machen Scott T · Tehachapi, CABuilt 1946 · S/N 7AC-3019 N84328Womack David B · Hurst, TXBuilt 1946 · S/N 7AC-3025 N84357Mctaggart Briar C · Adelanto, CAS/N 7AC-3051 N84360Jackson Jon T · Chester, MDBuilt 1946 · S/N 7AC-3054 N84362Logan Stephen E · Gilliam, LAS/N 7AC-3057 N84373Mccullough Jacob D · Lockhart, TXBuilt 1946 · S/N 7AC-3068 N84374Watson Bobby · Hoxie, ARBuilt 1946 · S/N 7AC-3064 N84389Coxbill Clifford E · Okeechobee, FLBuilt 1946 · S/N 7AC-3086 N84399French Richard A · Newport, NCS/N 7AC-3094 N84407Pyrrhuloxias LLC · Tallahassee, FLS/N 7AC-3108 N84411Registered aircraftBuilt 1946 · S/N 7AC-3104 N84417Favell John P · East Bridgewater, MABuilt 1946 · S/N 7AC-3111

Back to Aeronca 7AC