Skip to content

Registered aircraft · 276

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

N108PCRegistered aircraftBuilt 1948 · S/N 16-322 N4000HSmith Clyde R Jr · Lock Haven, PABuilt 1948 · S/N 16-1 N40260Omlid Robert L · Watford City, NDS/N 16-244 N4473YJackson Robert S · Gallatin, TNBuilt 1949 · S/N 16-375 N49PCFoster David W · North Fort Myers, FLS/N 16-194 N49WVOleary Timothy M · Aliquippa, PABuilt 1949 · S/N 16-723 N5206HMccallum Michael C · Delta, COBuilt 1949 · S/N 16-7 N5208HSweet Richard S · Prior Lake, MNBuilt 1949 · S/N 16-10 N5209HCook James F · Portland, ORBuilt 1949 · S/N 16-11 N5214HVagabond Flight Corporation · Decatur, ILBuilt 1949 · S/N 16-15 N5215HDavis Ted E · Brodhead, WIBuilt 1949 · S/N 16-17 N5216HWatkins John W · Somers, CTBuilt 1944 · S/N 16-18 N5222HDavidson Gerald W · Okatie, SCBuilt 1949 · S/N 16-24 N5223HSzorek Evelyn Personal Representative · Fairbanks, AKBuilt 1949 · S/N 16-25 N5226HJockos Sleigh LLC · Fort Worth, TXBuilt 1949 · S/N 16-28 N5227HBowman Brent W · Sebewaing, MIS/N 16-31 N5229HCahoon Theodore J · Erie, COBuilt 1949 · S/N 16-33 N5230HSeneca Aeronautical Services LLC · Wilmington, DES/N 16-34 N5235HMoore Jeffrey D · Cleveland, NYBuilt 1949 · S/N 16-39 N5240HSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1949 · S/N 16-44 N5242HJohnson Steven D · Oklahoma City, OKBuilt 1949 · S/N 16-46 N5243HKirk Douglas R · Benzonia, MIBuilt 1949 · S/N 16-47 N5250HPhilyaw Dale A · Lafayette, INBuilt 1949 · S/N 16-54 N5253HBerry Milo A · Clarinda, IABuilt 1949 · S/N 16-57 N5255HNorth Anthony · Rockwood, MEBuilt 1949 · S/N 16-59 N5258HFrenzel Carl O · Midlothian, TXBuilt 1949 · S/N 16-62 N5261HTurner Edward J III · Mokena, ILBuilt 1949 · S/N 16-65 N5263HWelch I Jay · Concrete, WABuilt 1949 · S/N 16-67 N5264HRaichl Andrej L · Astoria, ORBuilt 1949 · S/N 16-68 N5265HHarper Clayton E · Seabrook, TXBuilt 1949 · S/N 16-69 N5266HFritz Flying Service Inc · Lincoln, NES/N 16-70 N5276HYagcioglu Deniz S · Eatonton, GABuilt 1949 · S/N 16-80 N5277HTurner Edward J III · Mokena, ILBuilt 1949 · S/N 16-81 N5279HHarris Joe Paul Trustee · Goldsby, OKBuilt 1949 · S/N 16-83 N5284HCampbell Peter R · Edgewater, FLS/N 16-89 N5292HHartmann Lucas A · Barrington, ILBuilt 1949 · S/N 16-96 N5293HPierce Stephan · Graham, TXBuilt 1949 · S/N 16-97 N5294HWingo John W Jr · Washington, DCBuilt 1949 · S/N 16-98 N5300HStanton David R · Washougal, WABuilt 1949 · S/N 16-111 N5304HMyakka Head Aviation LLC DBA · Bradenton, FLBuilt 1949 · S/N 16-108 N5305HMarlatt Daniel L · Susanville, CAS/N 16-109 N5306HWroe Daniel C · Denton, MDBuilt 1949 · S/N 16-110 N5309HZeis Patrick J · Albany, MNBuilt 1949 · S/N 16-114 N5313HRizzo Joseph A · Akron, NYBuilt 1949 · S/N 16-118 N5316HGade Dale A · Antioch, ILBuilt 1949 · S/N 16-121 N5318HZefting Brett M · Bellingham, WABuilt 1949 · S/N 16-123 N5320HMiller Lorin D · Colo, IAS/N 16-125 N5321HNurge Richard J · Gilroy, CAS/N 16-126 N5325HAdams William Carter · Macon, GAS/N 16-130 N5326HVan Zant Timothy L · Nenana, AKBuilt 1949 · S/N 16-131

Back to Piper PA-16