Skip to content

Registered aircraft · 104

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

N1468NDepoy Lowell K · Salem, INBuilt 1947 · S/N 23001 N16PDMurphy Frank · Quitman, GABuilt 1945 · S/N 14699 N17RBN17rb LLC · Fredericksburg, PABuilt 1946 · S/N 16314 N20156Fazzolare Dennis J · Strabane, PABuilt 1938 · S/N 2233 N20165Newcomer Steven · Loganville, GAS/N 2217 N20206Risker Dale W · Bulger, PAS/N 2006 N20231Gregory Richard L Jr · Houston, TXBuilt 1937 · S/N 2031 N20240War Eagles Air Museum · Santa Teresa, NMS/N 2042 N20257Palmer Flying Service Inc · Manito, ILBuilt 1941 · S/N 2057 N20258Brandt Terry R · Hood River, ORBuilt 1938 · S/N 2058 N20261Vankirk Malcolm R · Frederick, MDBuilt 1938 · S/N 2061 N20833Paetzold Larry E · Brownwood, TXBuilt 1961 · S/N 2133 N21523Monreal Michael E · North Barrington, ILBuilt 1938 · S/N 2361 N2154MTrumbull Thomas A · Leland, MIS/N 20940 N2230MPepper William G · Fayette, MEBuilt 1946 · S/N 21022 N23135Scott Harry Jr Trustee · Walnut Creek, CABuilt 1939 · S/N 2918 N23420Kinnamon Kyle · Eden, MDBuilt 1939 · S/N 3149 N24710Schuetzeberg William C · Lago Vista, TXBuilt 1939 · S/N 3370 N2583ZTaildraggers LLC · Caledonia, ILBuilt 1946 · S/N 18687 N26040Deel David L · Tazewell, VABuilt 1939 · S/N 3982 N27937Chamberlain Paul E · Troup, TXBuilt 1940 · S/N 4458 N2CEWorld Aircraft Inc · Wilmington, DEBuilt 1939 · S/N 3341 N30496Burton Douglas M · Chehalis, WABuilt 1941 · S/N 6627 N30833Tong Ryan P · Freehold, NYBuilt 1940 · S/N 5134 N30859Harter Ryan A · Greenfield, INBuilt 1940 · S/N 5154 N31178Budinich Jason H · Hartford, WIBuilt 1940 · S/N 5388 N3213NRegistered aircraftBuilt 1946 · S/N 22403 N3261NDyer John M · Easley, SCBuilt 1946 · S/N 22451 N32743Bollenback Kenneth · Dunedin, FLBuilt 1940 · S/N 5577 N32852Demmery Daniel D · Port Saint Lucie, FLBuilt 1940 · S/N 5661 N32912Birk W M · Kennedale, TXBuilt 1940 · S/N 5708 N32950Kloss Matthew · Rew, PAS/N 5734 N33026Merritt Michael L · Acworth, GABuilt 1940 · S/N 5784 N33136Flying A Aviation LLC · Archer City, TXBuilt 1940 · S/N 5854 N3360NTelkamp Gary O · Rapid City, SDBuilt 1947 · S/N 22560 N35463Vajdos Robert C Jr · Louise, TXBuilt 1941 · S/N 6368 N35535Goodman Michael K · Brooksville, FLBuilt 1941 · S/N 6440 N3556KFairweather Flying Service LLC · Juneau, AKBuilt 1946 · S/N 22247 N3570KSwickard William E · Kent, WABuilt 1946 · S/N 22261 N3603KSchmieding Michael · Salem, ORBuilt 1946 · S/N 22294 N3623NSyverson Michael B · Waubun, MNBuilt 1947 · S/N 22875 N37951Charlton Robert E · Clarksville, ARRegistration expired, pending cancellationS/N 6745 N38333Sonex Aircraft LLC · Oshkosh, WIBuilt 1941 · S/N 6943 N38456Anderson Timothy L · Fincastle, VABuilt 1941 · S/N 7029 N38748Matthews Franklin L · Mc Alpin, FLBuilt 1941 · S/N 7222 N38798Seltman Jack · Wichita, KSBuilt 1941 · S/N 7275 N38881Bishops Ltd · Virginia Beach, VABuilt 1941 · S/N 7369 N3967BWayman Ian A · Peyton, COBuilt 1943 · S/N 13336 N418LSTrieber Steven M · Eastport, MEBuilt 1948 · S/N 18350 N42023Leclercq Benoit · Saint Cloud, FLBuilt 1942 · S/N 9069

Back to Piper J-3