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.

N38422Cline David R · Maryville, TNBuilt 1941 · S/N 5-972 N38425Schirmer Brandon · Batesville, TXBuilt 1941 · S/N 5976 N38498Hinckley David D · Belton, TXBuilt 1941 · S/N 5-984 N38579Vaughan Larry S · Amarillo, TXBuilt 1999 · S/N 5-997 N38584Soulek Joyce · Lake Andes, SDS/N 5-1002 N38590Moser Robert H · Prescott Valley, AZBuilt 1941 · S/N 5-1010 N38593Nevarrow Leon · Spring Valley, CAS/N 5-1013 N386331941 Historical Aircraft Group Museum DBA · Geneseo, NYS/N 5-1016 N38634Engler Eric M DBA · Cass City, MIBuilt 1941 · S/N 5-1018 N38640Mccutchan Anthony L · Collinsville, OKBuilt 1941 · S/N 5-1025 N38643Dykstra Dennis D · Marion, SDS/N 5-1028 N38645Wright Cecil A · Sanford, FLS/N 5-1030 N38646Murphree David A · Lake Saint Louis, MOBuilt 1941 · S/N 5-1031 N38647Neidert Melvin E · Ulysses, KSBuilt 1941 · S/N 5-1032 N38648Beranek Jim · Cottage Grove, ORBuilt 1941 · S/N 5-1033 N38660Southern Ohio Tractor LLC · Hillsboro, OHBuilt 1941 · S/N 5-1049 N38697Klosterman Aviation LLC · Celina, OHS/N 51056 N38698Worldwide Technical Services Inc · Bulger, PABuilt 1941 · S/N 5-1055 N38707Nixon David W · Portland, ORBuilt 1941 · S/N 5-1063 N38712Thistlethwaite Edward A Jr · Sunset, LABuilt 1941 · S/N 51068 N38719Ford Brendon S · Weimar, TXS/N 5-1074 N38872Fletcher Flying Service 419 LLC · Labelle, FLBuilt 1941 · S/N 5-1094 N38874Bolan Steven A · Phoenix, AZBuilt 1941 · S/N 51097 N38888Kirkendall Clinton I · Arlington, WABuilt 1941 · S/N 5-1088 N38889Rich Aircraft Services LLC · Brush Prairie, WAS/N 5-1086 N397PAStelzle Scott A · Templeton, CABuilt 1940 · S/N 5-397 N40678Saville David · North Royalton, OHBuilt 1941 · S/N 5-1116 N40683Helseth Keith A · Kirksville, MOBuilt 1941 · S/N 51113 N40685Pierce James C · Tallahassee, FLBuilt 1941 · S/N 51117 N40700Nelson Krista K · Cedar Falls, IABuilt 1941 · S/N 5-1132 N40713Engler William O · Filion, MIBuilt 1941 · S/N 5-1147 N40723Beaudry Charles F · Graham, NCS/N 5-1154 N40727Aerial Sign North · Lakewood, NJS/N 5-1159 N40791Porter David E · Woodstock, GAS/N 5-1168 N40795Greycat Aviation LLC · Chesapeake, VABuilt 1941 · S/N 5-1180 N40867Stells Building Renovation And Management Inc · Lino Lakes, MNBuilt 1941 · S/N 51172 N40870Braska Aviation LLC · Caro, MIBuilt 1941 · S/N 5-1175 N40877Cochrane Timothy A · Chippewa Lake, OHS/N 5-1182 N40885Burns Joyce A · Sparta, MOBuilt 1941 · S/N 51194 N40888Uhl Chmiel John Wyatt · Wausau, WIBuilt 1941 · S/N 5-1198 N40895Kraus Russell E · Albemarle, NCS/N 5-1190 N40896Red Oak Flying Club · Cabot, ARBuilt 1941 · S/N 5-1197 N41051Haynes Thomas E · Avon Park, FLS/N 5-1242 N41052Tippett Charles S Jr · Warrenton, VABuilt 1941 · S/N 5-1243 N41141Winit Matthew Clark · Woodland, WABuilt 1941 · S/N 5-1314 N41156Ruach Ministry · Dover, DEBuilt 1941 · S/N 5-1252 N41181Ryan Cynthia L · Anchorage, AKBuilt 1941 · S/N 5-1269 N41186Flannery Bruce F · Gladstone, MIS/N 5-1287 N41236Van Wagner Aerial Media LLC · Hollywood, FLBuilt 1941 · S/N 5-1290 N41334Registration Pending · Saint Louis, MORegistration pendingS/N 5-1321

Back to Piper J5A