Skip to content

Registered aircraft · 127

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

N33481Christie Ian A H · Limon, COBuilt 1940 · S/N 5991 N35052Montei Nicholas · Caro, MIBuilt 1940 · S/N 6059 N35067Lassiter Brent · Newport, ARS/N 6075 N35116Biondich Dennis A · Rubicon, WIBuilt 1941 · S/N 6139 N35141Wolfe Eric D · Wilson, NYBuilt 1941 · S/N 6154 N35215Sachs Maurice G · Foristell, MOBuilt 1941 · S/N 6212 N35305Kopaska Kelly J · Guthrie Center, IABuilt 1941 · S/N 6271 N35327Kurtz Daniel · Circleville, OHBuilt 1941 · S/N 6293 N35328Virga LLC · Sharon Springs, KSS/N 6295 N35335Grogan Edward V III · Blasdell, NYBuilt 1941 · S/N 6302 N35447Clark Dana Gibbs Trustee · Arlington, TXS/N 6352 N35448Moreau Raymond L · Slidell, LABuilt 1941 · S/N 6353 N35457Mckeen Charles D · Howard Lake, MNBuilt 1941 · S/N 6362 N35458Eyries LLC · Mankato, MNBuilt 1941 · S/N 6363 N35462Depaso Sean R · Pray, MTBuilt 1941 · S/N 6366 N35484Augustin David J · Murfreesboro, TNS/N 6388 N35494Larrivee Jules P · Kent, WABuilt 1941 · S/N 6397 N35511Hammond William R · Hustonville, KYBuilt 1941 · S/N 6421 N35570Balunek Konrad K · Avon, OHS/N 6476 N35640Rivera Carlos A · Morriston, FLBuilt 1941 · S/N 6496 N35657Martinez Anthony III · Great Bend, KSBuilt 1941 · S/N 6516 N35709Ross David R · Wakeman, OHS/N 6550 N35736Diamond J Farms · Pleasant Grove, CAS/N 6556 N35838Reusch Gerald Walter · Sebring, FLS/N 6608 N35848Semeraro Bart D · Austin, TXS/N 6314 N37666Flying L Aircraft Inc · Fort Denaud, FLFirst renewal noticeS/N 6433 N38091Yanacek Steve J · Meadville, PABuilt 1941 · S/N 6776 N38097Aarestad Potato Co Ltd · Halstad, MNBuilt 1941 · S/N 6785 N38259Miles Andrew W · Colorado Springs, COBuilt 1941 · S/N 6894 N38326Wehrman Michael E · Billings, MTBuilt 1941 · S/N 6933 N38369Ptacek Stephen R · Estes Park, COBuilt 1941 · S/N 6987 N38372Parmoon Joseph A · Albuquerque, NMBuilt 1941 · S/N 6982 N38436Prout Paul D · Eveleth, MNBuilt 1941 · S/N 7005 N38438Sale Reported · Silver City, NMSale reportedBuilt 1941 · S/N 7007 N38475Holloway Hubert L · Warner Robins, GABuilt 1941 · S/N 7047 N38506Hainline Charles H · Friendswood, TXS/N 7075 N38512Bialas Bonnie L · Richland, WABuilt 1941 · S/N 7081 N38519Maltz Lawrence Jay · Georgetown, TXBuilt 1941 · S/N 7088 N38542Liszka Stanley M · Jamestown, PABuilt 1941 · S/N 7110 N38616Scott Robert Gizzie · Johnson City, TNBuilt 1941 · S/N 7148 N38618Giron Lawrence N · Anchorage, AKS/N 7159 N38693Pevey David M · Mcdonough, GABuilt 1941 · S/N 7201 N38737Neal Alan B · Cherry Valley, CAS/N 7208 N38743Adams Eddie · Senath, MOBuilt 1941 · S/N 7220 N38747Frazier Forrest Alan · Augusta, MOBuilt 1941 · S/N 7229 N38755Sikes Robert J · Valdosta, GABuilt 1940 · S/N 7232 N38759Costanza Joseph V · Marlton, NJBuilt 1941 · S/N 7236 N38787Onawa Flying Service · Sioux City, IABuilt 1941 · S/N 7264 N38822Yandik Stephen E · Hudson, NYBuilt 1941 · S/N 7308 N38833Morris Ray O · Ringgold, VAS/N 7320

Back to Piper J3F-65