Skip to content

Registered aircraft · 52

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

N10202Tall Towers Ag Service Inc · Page, NDS/N 1 N10210Mid Continent Aircraft Corp · Hayti, MOBuilt 1939 · S/N 10 N10211Valley Air Service Ltd · Colusa, CABuilt 1959 · S/N 11 N10215Trissell Flying Service Inc · Clarksville, TXBuilt 1960 · S/N 15 N10218Porter Wade R · Chico, CABuilt 1959 · S/N 18 N10247Ferrspray Aerial Application LLC · Marengo, ILBuilt 1960 · S/N 47 N10250Adcock Colton L · Dustin, OKBuilt 1960 · S/N 50 N10253Sipos Richard · Homosassa, FLBuilt 1960 · S/N 53 N10254Trissell Flying Service Inc · Clarksville, TXBuilt 1960 · S/N 54 N10256Triple F Flying Inc · Benton, PAS/N 56 N10287Ripley James Jefferson III · Frederick, OKS/N 87 N10294Miller Andy · Marana, AZS/N 94 N10298Coen Aerial Spraying LLC · Wiley, COBuilt 1962 · S/N 98 N164JAOber John A · Candor, NYBuilt 1962 · S/N 277 N331YAirplane Services Inc · Jay, FLS/N 206 N407YHendrickson Gary A · Chico, CABuilt 1963 · S/N 217 N460YRuiz Segundo Garcia · Ponce, PRBuilt 1962 · S/N 151 N464YTonner Daniel J · Conrad, IABuilt 1962 · S/N 110 N4778TContinental Title Trust LLC · Wichita, KSBuilt 1963 · S/N 220 N478YFerr Spray Aerial Application LLC · Marengo, ILBuilt 1962 · S/N 123 N479YGustin Aviation Inc · Lewiston, IDBuilt 1962 · S/N 124 N481YKyle E Rich Inc · Sumner, IABuilt 1962 · S/N 126 N496YZumwalt B Joseph · Sheldon, ILBuilt 1962 · S/N 153 N503YRegenald Michaud Aviation LLC · Willows, CABuilt 1965 · S/N 353 N513YBell Robert A Jr · Scotland Neck, NCBuilt 1962 · S/N 145 N515YMidwest Flying Service Inc · Elgin, NEBuilt 1962 · S/N 147 N519YSummers Mark E · Tuckerman, ARBuilt 1962 · S/N 156 N522YAdcock Colton L · Dustin, OKBuilt 1962 · S/N 159 N524YSouthwind Aviatin Inc · Maryville, TNBuilt 1962 · S/N 161 N552YFarm Ag Enterprises LLC · Buckeye, AZS/N 223 N591YWaterbury Craig A · El Paso, TXS/N 182 N601YSouth Delta Aviation Inc · Fayetteville, ARBuilt 1963 · S/N 226 N608UHall William B · Vincentown, NJBuilt 1965 · S/N 337 N613ULarson Lynn Robert · Casselton, NDBuilt 1965 · S/N 341 N616UBarse William P · Hampstead, MDBuilt 1965 · S/N 344 N633USmith David C · Brewster, WABuilt 1965 · S/N 369 N63WGrubbs Terry L · Gregory, SDS/N 3 N640URegenald Michaud Aviation LLC · Willows, CABuilt 1965 · S/N 376 N645YBarse William P · Hampstead, MDBuilt 1963 · S/N 234 N651YPhillips Carlton T · Walnut Ridge, ARBuilt 1964 · S/N 260 N659UChandler Will W · Texarkana, TXBuilt 1966 · S/N 395 N660UMid Continent Aircraft Corp · Hayti, MOBuilt 1966 · S/N 396 N661YTriple F Flying Inc · Benton, PAS/N 204 N664UMurphy Airport Inc · Amsterdam, NYBuilt 1966 · S/N 400 N696YKutschera Theodore · Callicoon, NYBuilt 1964 · S/N 247 N705YBadgley Aviation Services LLC · Stanley, NDS/N 315 N714YButte County Mosquito And Vector Control District · Oroville, CABuilt 1964 · S/N 276 N718YWood James A · Madera, CABuilt 1964 · S/N 280 N719YPhilipp Dean · Thief River Falls, MNBuilt 1964 · S/N 281 N735YTriple F Flying Inc · Benton, PABuilt 1964 · S/N 295

Back to Grumman G-164