Skip to content

Registered aircraft · 97

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

N17VGPerman Thomas E · Jupiter, FLBuilt 1948 · S/N 17-97 N222SKArnold Sarah Diane · Benton, TNBuilt 1948 · S/N 17-75 N4149HDietrich Walter C · Hastings, FLBuilt 1966 · S/N 15-32 N4154HKloke Joseph W · South Elgin, ILS/N 17-1 N4331HPierce Gilbert H · Germantown, TNBuilt 1948 · S/N 15-118 N4377HJones Rick R · Greenville, NCBuilt 1948 · S/N 15-163 N4582HAnderson Irvin A · Chandler, AZBuilt 1948 · S/N 17-7 N4584HScootair LLC · Alburgh, VTBuilt 1948 · S/N 17-9 N4586HWinston Eric D · Canby, ORS/N 17-2 N4587HJohnson Steven Donald · Pardeeville, WIBuilt 1948 · S/N 17-3 N4590HSchwartz Kenneth G · Lincoln, CABuilt 1948 · S/N 17-4 N4592HSessoms Aero LLC · Vero Beach, FLS/N 17-6 N4594HLund John G · Cadillac, MIBuilt 1948 · S/N 17-12 N4595HBranagh Charles · Clay, NYBuilt 1948 · S/N 17-13 N4596HAzevedo Manuel J · Modesto, CABuilt 1948 · S/N 17-14 N4600HWilson William H · Iron Station, NCBuilt 1948 · S/N 17-17 N4601HDaniel Quinton L · Vicksburg, MIBuilt 1948 · S/N 17-18 N4605HFenstermacher Robert B · Telford, PABuilt 1948 · S/N 17-21 N4610HDuck Donald E · Edwardsburg, MIBuilt 1948 · S/N 17-27 N4612HHudgin James P · Murfreesboro, TNBuilt 1948 · S/N 17-29 N4615HStahl John R · Union Dale, PABuilt 1948 · S/N 1732 N4616HMoore Thomas R · North Bay, NYBuilt 1948 · S/N 17-33 N4617HRegistered aircraftBuilt 1948 · S/N 17-34 N4618HMeadows Joseph T · Charleston, TNBuilt 1948 · S/N 17-35 N4619HFaulkner Ronnie L · Cocoa, FLBuilt 1948 · S/N 17-36 N4621HRegistration Pending · Havensville, KSRegistration pendingBuilt 1948 · S/N 17-37 N4623HMckinney James V · Yucaipa, CABuilt 1948 · S/N 17-39 N4627HMartin Devon R · Memphis, MOBuilt 1948 · S/N 17-42 N4628HTube Forming And Machine Inc · Glennie, MIBuilt 1948 · S/N 17-43 N4629HSzczesniak Robert · Jensen Beach, FLBuilt 1948 · S/N 17-44 N4631HMiller Nevin D · Naples, IDS/N 17-46 N4633HBoya John D · Indian Lake, NYBuilt 1948 · S/N 17-49 N4635HMckinley Scott E · Spokane Valley, WABuilt 1948 · S/N 17-50 N4639HBarnstormers Holdings Inc · Sugar Grove, ILBuilt 1948 · S/N 17-52 N4642HSessions James W · Sebastian, FLBuilt 1948 · S/N 17-54 N4643HPatrick Matthew · Cincinnati, OHBuilt 1948 · S/N 17-55 N4647HMeyer William M · Chicago, ILBuilt 1948 · S/N 17-59 N4660HBarnes Michael S · Kamiah, IDBuilt 1948 · S/N 17-67 N4661HMurray Edward K · Fallbrook, CABuilt 1948 · S/N 17-68 N4664HMurphy Terrence W III · Belmont, NHBuilt 1948 · S/N 17-69 N4666HToland Lance P · Griffin, GABuilt 1948 · S/N 17-71 N4675HMichael Anna B · Port Orange, FLBuilt 1948 · S/N 15-374 N4676HClay Lawrence A · Ellsworth, NHBuilt 1948 · S/N 17-77 N4678HStevens Cole J · Coeur D Alene, IDS/N 17-79 N4681HBohrman Robert C · New Berlin, WIBuilt 1948 · S/N 17-80 N4682HN4682h Inc · Jacksonville, FLBuilt 1948 · S/N 17-81 N4685HMann Thomas A · Ford, WABuilt 1946 · S/N 17-84 N4686HEckels Shaun R · Pickerington, OHBuilt 1948 · S/N 17-83 N4688HChouinard Christopher P · Friday Harbor, WAS/N 17-86 N4692HFerguson James L Jr · New Cambria, KSBuilt 1948 · S/N 17-90

Back to Piper PA-17