Skip to content

Registered aircraft · 513

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

N9746APetey LLC · Bozeman, MTBuilt 1950 · S/N 19207 N9748AJuhl Amanda · Centennial, COBuilt 1950 · S/N 19209 N9751APerla Guido F · Vashon, WABuilt 1950 · S/N 19212 N9753AFowler Flyers Inc · Fowler, COS/N 19214 N9759ALove John W Jr · Los Lunas, NMBuilt 1950 · S/N 19220 N9760AK & S Aviation Adventures LLC · Toms River, NJS/N 19221 N9763ARoman Financial Inc · Monroe, WABuilt 1950 · S/N 19224 N9768ABeachy Benjamin D · Whittington, ILBuilt 1950 · S/N 19409 N9769AGernetzke Jill R · Kingman, AZBuilt 1950 · S/N 19230 N9770ANathan David L DBA · Fullerton, NEBuilt 1950 · S/N 19231 N9772AKerns Stanley M · Berryville, VABuilt 1950 · S/N 19233 N9773AHoch Lance M · New Plymouth, IDFirst renewal noticeBuilt 1950 · S/N 19234 N9774AKuykendall Wayne · Waxahachie, TXBuilt 1950 · S/N 19235 N9775ATcb Flies LLC · Brooklyn, NYS/N 19236 N9776AMoritz Randal L · Emily, MNBuilt 1950 · S/N 19237 N9777ABuxton Gretchen C · Spooner, WIBuilt 1950 · S/N 19238 N9778ACurrie Jason M · Kennard, TXBuilt 1950 · S/N 19239 N9781ATate Amanda T · Fairbanks, AKS/N 19242 N9793ACoulter Robert · South Bend, INBuilt 1950 · S/N 19254 N9794ABurlace Thomas J III · Aurora, COBuilt 1950 · S/N 19255 N9795APatterson Roland O · Semmes, ALS/N 19256 N9798ARupert Yuri · Lillian, ALFirst renewal noticeBuilt 1950 · S/N 19259 N9905AHottois Scott A · Whittemore, MIS/N 19265 N9907AHuff Steven D · Lake Havasu City, AZBuilt 1950 · S/N 19267 N9908AKelly Larry E · Currie, NCBuilt 1950 · S/N 19268 N9910ABach Jeremy · Camp Verde, AZS/N 19270 N9911ADaniels Bayce D · Anthony, NMS/N 19271 N9912AEvans Alfred M Jr · Kingston, OKBuilt 1950 · S/N 19272 N9915AAbel Elliot A · Terre Haute, INBuilt 1950 · S/N 19275 N9921AAllen Air Ltd · Wray, COBuilt 1950 · S/N 19281 N9922AWilliamson Cordy M · Darlington, SCS/N 19282 N9926AOlmsted Ronald A · Barnstead, NHFirst renewal noticeBuilt 1950 · S/N 19286 N9927ABrian Jake K · Sumner, ILBuilt 1950 · S/N 19287 N9929ACavner Hudson · Palmer, AKBuilt 1950 · S/N 19289 N9930ASmith David J · Duluth, MNBuilt 1950 · S/N 19290 N9931ARowland Brett D · Wichita, KSBuilt 1950 · S/N 19291 N9933ATravelair Inc · Ocala, FLBuilt 1950 · S/N 19411 N9935AMichael Monte E · Axtell, TXBuilt 1950 · S/N 19413 N9937AInternational Air Services Inc Trustee · Carson City, NVBuilt 1950 · S/N 19297 N9943ASipple Ronald W Jr · Gardner, KSBuilt 1950 · S/N 19303 N9948AHoatson Larry · Yucaipa, CABuilt 1950 · S/N 19308 N9950AHilbert Lee D · Hampton, NJBuilt 1950 · S/N 19310 N9954ANolen Donald F · Plano, TXBuilt 1950 · S/N 19314 N9955ANelson Harry J · West Bend, WIBuilt 1950 · S/N 19315 N9957ADunn Ward A · Columbia, SCBuilt 1950 · S/N 19317 N9958AChase Kevin J · Anchorage, AKFirst renewal noticeBuilt 1950 · S/N 19318 N9959ANelson Jayson A Trustee · Caldwell, IDBuilt 1950 · S/N 19319 N9965ARobertson Francis E · Hibbing, MNBuilt 1950 · S/N 19325 N9968APickett Steven M · Odenville, ALBuilt 1950 · S/N 19328 N9969ARegistration Pending · Frostproof, FLRegistration pendingBuilt 1950 · S/N 19628

Back to Cessna 170A