Skip to content

Registered aircraft · 53

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

N101PEDemarco Eugene J · New Orleans, LABuilt 1944 · S/N 1386 N10BQDunigan Patrick II · Jackson, MIBuilt 1943 · S/N 1327 N13122Alaska Aviation Museum · Anchorage, AKBuilt 1943 · S/N 1312 N1340VClaire Aviation · Wilmington, DEBuilt 1941 · S/N 1228 N135MGOld Crow LLC · Columbus, OHBuilt 1944 · S/N 1389 N141RCompton Steven J · Anchorage, AKBuilt 1944 · S/N 1378 N144SLBank Of Utah Trustee · Salt Lake City, UTS/N 1215 N1595VBlocher Steven W Jr · Moscow, IDS/N 1319 N17481Ball Fred E · College Place, WABuilt 1944 · S/N 1360 N199THarder Michael U · Dillingham, AKBuilt 1941 · S/N 1213 N1ASBeacon West LLC · Hayden Lake, IDBuilt 1941 · S/N 1230 N23456Hangar One Inc · Wilmington, DES/N 1270 N25DFHough Robert M · Windham, NHBuilt 1943 · S/N 1306 N299CNEastern Shore Helicopters Inc · Labelle, FLS/N 1299 N302Alaska Bush Leasing LLC · Anchorage, AKBuilt 1943 · S/N 1294 N33QYanks Air Museum · Baldwin Park, CAS/N 1398 N37186Perry James D · Monroe, WAS/N 1236 N403ERegistration Pending · Rochester, NYRegistration pendingBuilt 1944 · S/N 1300 N414UIronworks Air LLC · Rogers, MNBuilt 1945 · S/N 1427 N41GWNorthern Flyer LLC · Anchorage, AKBuilt 1941 · S/N 1235 N4492NUsibelli Joseph Emil Trustee · Fairbanks, AKS/N 1298 N44DWGrumman Widgeon LLC · Missoula, MTS/N 1381 N45PVGuyton Thomas J · Toledo, OHBuilt 1944 · S/N 1380 N4617NBurgan Grover W · Jacksonville, FLBuilt 1944 · S/N 1364 N47CDickey Tod V · Phoenix, AZS/N 1371 N521YTDelcavu LLC · Dover, DEBuilt 1943 · S/N 1311 N52833Mcbride Kenneth B · San Martin, CAS/N 1374 N540MWTaylor Steven · Riverdale, MIBuilt 1943 · S/N 1324 N54VTRegistered aircraftS/N 1277 N62000Clark Nikita C · Ontario, ORS/N 1292 N62096Lost Aviators Of Pearl Harbor LLC · Bellingham, WABuilt 1944 · S/N 1393 N63350Failing Amanda R · Wasilla, AKBuilt 1944 · S/N 1387 N645DHEarp Kevin · Eagle River, AKS/N 1329 N65914Older Dan L · Bellingham, WABuilt 1944 · S/N 1385 N671DFSturges Patrick M · Silver Springs, FLBuilt 1942 · S/N 1274 N67646Mccormick Robert E · Selah, WABuilt 1943 · S/N 1325 N67867Jmq Inc · Gulf Breeze, FLBuilt 1943 · S/N 1317 N68102Blackbriar Aero LLC · Helena, MTBuilt 1945 · S/N 1351 N69058Pesicka Theodore J · Hermiston, ORBuilt 1943 · S/N 1291 N69067Haggland James R · Fairbanks, AKBuilt 1943 · S/N 1338 N701JGrechman Raymond Clark · Kentfield, CAS/N 1373 N708CMech Nicholas E · Dublin, GAS/N 1313 N744GMarzich Frank M · Rockford, ILBuilt 1944 · S/N 1394 N7491Vanwagnen Brian J · Jackson, MIBuilt 1942 · S/N 1240 N77BDSea & Air Adventures LLC · Wilmington, DEBuilt 1943 · S/N 1343 N78ZSturges Patrick M · Silver Springs, FLBuilt 1941 · S/N 1214 N90727Mees Martin Burke · Eagle River, AKBuilt 1942 · S/N 1334 N91040Airline Maintenance Service Inc · Nashville, TNBuilt 1942 · S/N 1267 N92LTwo Tails LLC · Las Vegas, NVBuilt 1944 · S/N 1372 N9311RHarder Michael U · Dillingham, AKS/N 1340

Back to Grumman G-44