Skip to content

Registered aircraft · 268

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

N30455Davidge William B · Winlock, WABuilt 1940 · S/N 5-198 N30508Byars Guy F · Goshen, OHBuilt 1940 · S/N 5-204 N30520Warner Walter M Jr · Willow, AKS/N 5-213 N30622Money Aerial Media LLC · San Diego, CABuilt 1940 · S/N 5-223 N30648Bongard Fred · Torrance, CABuilt 1940 · S/N 5-227 N30658Mcmahan Jerry · Watson, ARBuilt 1940 · S/N 5-228 N30679Inman Michael D · Raeford, NCBuilt 1940 · S/N 5-234 N30681Miller Lowell R · Budd Lake, NJBuilt 1940 · S/N 5-235 N30690Melchiorre Joseph G · Lewes, DEBuilt 1940 · S/N 5238 N30704Martini Alan F · Boulder, MTBuilt 1940 · S/N 5-240 N30705Gaya Shawn A · Wonder Lake, ILBuilt 1940 · S/N 5-241 N30768Sheldon Jeffrey C · Hastings, NYBuilt 1940 · S/N 5253 N30773Nc30773 LLC · Fishers, INBuilt 1940 · S/N 5-254 N30795Atmospheric Vehicle & Spacecraft Flt Exploration · Rch Palos Vrd, CAS/N 5-261 N30821Kramer Peter W · Copper Center, AKBuilt 1940 · S/N 5-262 N30848Graham Mt Ranch Inc · Broadus, MTBuilt 1940 · S/N 5-267 N30849Christensen Craig H · Webster, MNBuilt 1940 · S/N 5-268 N30879Nelson Edward T · Silver Springs, FLS/N 5-274 N30897Jones Ralph E · Oldwick, NJBuilt 1940 · S/N 5-279 N30916Sowders Darwin G · Robinson, TXBuilt 1940 · S/N 5-283 N30924Bliss Jacob W · Spokane, WABuilt 1940 · S/N 5-285 N31000Fahy Thomas E · Carabaset Vly, MEBuilt 1940 · S/N 5-294 N31020Harvey Christopher Johnryan · Port Leyden, NYBuilt 1940 · S/N 5-300 N31025Lupei Donald E Trustee · Yorkville, ILBuilt 1940 · S/N 5-301 N31038Neely Brody R · Fairbanks, AKBuilt 1940 · S/N 5-304 N31057Rendel James L · Rock Hill, SCS/N 5-306 N31071Wilkins Raymond E · Osceola, IABuilt 1940 · S/N 5-305 N31125I Fly Enterprise · Lexington, NCBuilt 1940 · S/N 5315 N31165Hackenburg Jess P · Montoursville, PAS/N 5322 N3121BOxley Kevin L · Huntington, INS/N 5-314 N31289Hall M Richard · Aliquippa, PAS/N 5-1478 N32515Leonard Danny C · Fort Worth, TXS/N 5-332 N32572Buell Robert A · Punta Gorda, FLBuilt 1940 · S/N 5336 N32578James Stanley J · Williamson, GABuilt 1940 · S/N 5-339 N32607Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1940 · S/N 5-344 N32608Smith Kevin F · Sherman, TXBuilt 1940 · S/N 5-347 N32686Fortney Deborah S · Union City, CABuilt 1940 · S/N 5374 N32788Soden Laurence L · Fairbanks, AKBuilt 1940 · S/N 5-384 N32791Nc32791 LLC · Colleyville, TXBuilt 1940 · S/N 5-385 N32792Spear Mike J · Sandpoint, IDBuilt 1940 · S/N 5-386 N32887Groskurth Walter I · Mankato, MNBuilt 1940 · S/N 5-393 N32892R&L Air Service LLC · Yatesville, GABuilt 1940 · S/N 5399 N32899Carter James W · Pflugerville, TXBuilt 1949 · S/N 5408 N32985Woodward Christopher L · Manchester, TNBuilt 1940 · S/N 5-410 N32986Smith Lane W · White Salmon, WABuilt 1940 · S/N 5-424 N32989Wiggins Cory L · Oak Grove, LAS/N 5-412 N32996Blythe Joseph L · Rockwall, TXBuilt 1940 · S/N 5-420 N33029Taylor William L · Fairview, ORBuilt 1940 · S/N 5-430 N33063Kirschke John K · Seneca Falls, NYBuilt 1946 · S/N 5-443 N33078Horan Mark E · Windsor Locks, CTBuilt 1940 · S/N 5-426

Back to Piper J5A