Skip to content

Grumman Acft ENG Cor-Schweizer G-164A

Registered aircraft · 150

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

N118JDJacobson Luke W · Reno, NVS/N 863 N127FCBurghduff Aviation LLC · Ludlow, SDS/N 1393 N29GWRegistration Pending · Tyler, MNRegistration pendingBuilt 1975 · S/N 1564 N4241Ham Orlando DBA · Opdyke, ILBuilt 1972 · S/N 1011 N4369Lewis Flying & Maint Svc Inc · Morse, LABuilt 1973 · S/N 1045 N4450Registered aircraftS/N 1048 N4508Page Marion E · Clio, SCBuilt 1973 · S/N 1050 N4536Mid Continent Aircraft Corp · Hayti, MOBuilt 1973 · S/N 1053 N4591Kramr David J · Lissie, TXBuilt 1973 · S/N 1066 N4623Breum Sean M · Stanwood, WABuilt 1973 · S/N 1087 N4630Jones Aviation Inc · Biggs, CABuilt 1973 · S/N 1176 N4698Hershey Flying Service Inc · David City, NES/N 1081 N48374Ag Cat Applicators LLC · Avoca, TXBuilt 1976 · S/N 1619 N48377Ag Spraying LLC · Bonner Springs, KSBuilt 1975 · S/N 1541 N48383Jones James M Jr · Monroe, LABuilt 1976 · S/N 1623 N48402Jones Ken · Grenada, MSFirst renewal noticeBuilt 1976 · S/N 1630 N48403Nielsen Richard D · Crystal Beach, TXBuilt 1976 · S/N 1631 N48405Northwood Aero Service · Northwood, NDS/N 1632 N48442Mid Continent Aircraft Corp · Hayti, MOBuilt 1976 · S/N 1646 N48468Tumbleweed Leasing LLC · Tacoma, WABuilt 1976 · S/N 1649 N48473Palouse Ag Leasing LLC · Moscow, IDBuilt 1976 · S/N 1654 N48489Price William B · Lamar, SCBuilt 1976 · S/N 1651 N48491Hartwig Lonnie · Edgeley, NDBuilt 1976 · S/N 1653 N48524Mamuzich Robert J DBA · Deming, NMBuilt 1976 · S/N 1661 N48555Milnor Agair Inc · Milnor, NDBuilt 1976 · S/N 1671 N48556Lewis Flying & Maintenance Service · Morse, LABuilt 1976 · S/N 1638 N48575Registered aircraftBuilt 1976 · S/N 1672 N48582Triple F Flying Inc · Benton, PABuilt 1976 · S/N 1674 N48613Crop-Aid Aerial Service LLC · Hillsboro, OHBuilt 1976 · S/N 1682 N4863Eagle Air Service LLC · Greenfield, INBuilt 1972 · S/N 1016 N48635Ag Aviation Service Inc · Elkhorn, WIBuilt 1976 · S/N 1684 N5083Kramr David · Eagle Lake, TXBuilt 1973 · S/N 1115 N5149Rock Creek Leasing LLC · Sapulpa, OKBuilt 1973 · S/N 1123 N5236Porter Flying Service Inc · Chico, CAS/N 1130 N5249Petersen Conrad H · Kenmare, NDBuilt 1973 · S/N 1131 N5380Tall Towers Aviation Inc · Page, NDFirst renewal noticeBuilt 1973 · S/N 1144 N5395Avag Inc · Richvale, CABuilt 1973 · S/N 1149 N5396Hershey Flying Service · David City, NEBuilt 1973 · S/N 1150 N5449Precision Ag Air LLC · Pendleton, INBuilt 1973 · S/N 1159 N5450Growers Air Service · Woodland, CAS/N 1160 N5470Atlantic Wings LLC · New Bern, NCBuilt 1973 · S/N 1166 N5474Hershey Flying Service Inc · David City, NES/N 1172 N567JCChorman Spraying LLC · Milton, DEBuilt 1974 · S/N 1340 N6620QDowntown Airport Inc · Vineland, NJBuilt 1976 · S/N 1693 N6622QGasper Air Spray Inc · Crookston, MNS/N 1689 N6680QHershey Flying Service · David City, NEBuilt 1977 · S/N 1699 N6716QSale Reported · Pelkie, MISale reported, pending cancellationBuilt 1977 · S/N 1710 N6717QAlaska Air Service LLC · Brookings, ORS/N 1711 N6741QPalmer Ag Air · Novelty, MOS/N 1714 N6761QHershey Flying Service Inc · David City, NEBuilt 1974 · S/N 1352

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