Skip to content

Grumman Acft ENG Cor-Schweizer G-164B

Registered aircraft · 157

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

N135VAWallace Aviation Inc · Wallace, NEBuilt 1976 · S/N 27B N164APElwood Farms Inc · Levelland, TXBuilt 1977 · S/N 1706 N164TNBuntings Dusting Inc · Berlin, MDBuilt 1978 · S/N 412B N211ERMorgans Flying Service LLC · Morse, LABuilt 1977 · S/N 254B N211JMSanderson Grain Inc · Springlake, TXBuilt 1976 · S/N 69B N342KGAviation Services Of Grady County Inc · Pelham, GABuilt 1977 · S/N 263B N3626GSky Tractor LLC · Hillsboro, NDS/N 718B N36270Gilland Jonathan R · Elkton, TNS/N 734B N41844Todd Greggory S · Ankeny, IAS/N 385B N440ETHoppe Air LLC · Beaman, IABuilt 1977 · S/N 222B N447TAThompson Aero Inc · Amana, IABuilt 1977 · S/N 187B N48348Sug-Air LLC · Lubbock, TXS/N 9B N48372Farrell Drew M · Maryville, MOBuilt 1976 · S/N 12B N48413Bayou Dusters LLC · Moreauville, LABuilt 1976 · S/N 16B N48423Thompson Frank L · Weiser, IDBuilt 1976 · S/N 18B N48436Wakefield John DBA · Cooperstown, NDBuilt 1976 · S/N 78B N48445Mid Continent Aircraft Corp · Hayti, MOBuilt 1976 · S/N 21B N48449Lewis Flying & Maintenance Svc · Morse, LAFirst renewal noticeBuilt 1976 · S/N 23B N48452Jones Aviation Inc · Biggs, CABuilt 1976 · S/N 24B N48455Crawford Aviation Services LLC · Flagstaff, AZBuilt 1976 · S/N 28B N48474Albright Frank E · Elba, ALBuilt 1976 · S/N 32B N48484Jones Aviation Inc · Biggs, CAS/N 43B N48492D C Applicator · Brentwood, CABuilt 1976 · S/N 47B N48494Lewis Flying & Maintenance Svc · Morse, LABuilt 1976 · S/N 48B N48505Koch Richard N · Le Roy, MNBuilt 1976 · S/N 56B N48518Registered aircraftN-number assigned, not yet registeredS/N 61B N48519Buntings Dusting Inc · Berlin, MDBuilt 1976 · S/N 42B N48534Ag Aviation Service Inc · Elkhorn, WIBuilt 1976 · S/N 65B N48542Buntings Dusting Inc · Berlin, MDBuilt 1976 · S/N 66B N48547Magnum Aviation LLC · Goff, KSBuilt 1976 · S/N 70B N48551Hershey Flying Service Inc · David City, NEBuilt 1976 · S/N 71B N48559Fountain Inc · Moscow, IDBuilt 1976 · S/N 73B N48614Red Willow Rescue Inc · Cooperstown, NDBuilt 1976 · S/N 86B N48625Albertson James M · Slocomb, ALBuilt 1976 · S/N 90B N48643Snake River Logistics Inc · Ontario, ORBuilt 1976 · S/N 99B N48655Hershey Flying Service Inc · David City, NES/N 102B N48659Mcclung Aerial Spraying Inc · Big Springs, NEBuilt 1976 · S/N 104B N48664Mid Continent Aircraft Corp · Hayti, MOBuilt 1976 · S/N 105B N48672Schindler Rick M · Neligh, NEBuilt 1976 · S/N 108B N48675Hershey Flying Service Inc · David City, NEBuilt 1976 · S/N 109B N48677Ag Aviation Service Inc · Elkhorn, WIBuilt 1976 · S/N 111B N5048FSky Tractor Ag LLC · Scottsbluff, NES/N 62B N558TJMorgans Flying Service LLC · Morse, LAS/N 458B N573AFWatson Air Farm LLC · Thibodaux, LABuilt 1979 · S/N 573B N5KYCropair Flying Service · Cody, WYBuilt 1978 · S/N 377B N63EAvag Inc · Richvale, CABuilt 1977 · S/N 305B N6500KScott Flying Service Inc · Bono, ARBuilt 1977 · S/N 336B N6509KMeadow Creek Aerial Application Inc · Kelliher, MNBuilt 1977 · S/N 345B N6524KJones Aviation Inc · Biggs, CABuilt 1977 · S/N 352B N6527KHock Gregory G · Culbertson, NES/N 353B

Back to Grumman Acft ENG Cor-Schweizer G-164B