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.

N1044TSnyder Otho J · Underwood, NDS/N 5-628 N105FVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1940 · S/N 5-477 N1941CEuroaviation Inc Trustee · KematenS/N 5868 N21579Ollison Lewis E · Warrensburg, MOBuilt 1955 · S/N 5-789 N254EBE B Ranch · Broadus, MTBuilt 1940 · S/N 5193 N2583BManning James E · Puryear, TNBuilt 1941 · S/N 5-705 N26876Western Antique Aeroplane & Automobile Museum · Hood River, ORS/N 5-3 N26946Kramer Peter W · Copper Center, AKBuilt 1940 · S/N 5-16 N26953Tribley Brooke E · Magnolia, TXBuilt 1940 · S/N 5-9 N26987Dornseif Daniel K · Oviedo, FLBuilt 1940 · S/N 5-15 N27053Hill Jeffry J Jr · Woodstock, ILBuilt 1940 · S/N 5-20 N27059Confederate Air Inc · Tillar, ARS/N 5-22 N27070Bagley Paul S · Cumming, GABuilt 1940 · S/N 5-23 N270JSAubin Carol · Bangs, TXBuilt 1940 · S/N 5-18 N27106Clements Marcelaine A D · Edgerton, WIBuilt 1940 · S/N 527 N27129Rodenberg James D · Wolf Point, MTBuilt 1940 · S/N 5-31 N27159Murray Craig P · Hagaman, NYBuilt 1940 · S/N 5-38 N27171Reyn/Craft Wildside Aviation LLC · Athens, ILS/N 5-39 N27198South Central Ozarks Flying Group LLC · Willow Springs, MOBuilt 1940 · S/N 5-45 N2753TGarretson Mark W · Victoria, TXS/N 5-1213 N27905Bashaw Pete H · Camas, WABuilt 1940 · S/N 5-48 N27915Gruner Carl O · El Cajon, CAS/N 5-53 N27943Nedwick Lars I · Girdwood, AKS/N 5-62 N27972Miller Rondo T · Coon Rapids, MNBuilt 1940 · S/N 5-69 N27980Donnelly Brian J · Norwood, NYBuilt 1940 · S/N 5-80 N27999Bradshaw William D · Mc Bee, SCBuilt 1940 · S/N 5-78 N28046Mcquown Todd J · Montgomery, TXBuilt 1940 · S/N 5-90 N28050Griggs Gerald W · Goddard, KSBuilt 1940 · S/N 5-88 N28063Strauss Kenneth W · Vashon, WABuilt 1940 · S/N 5-89 N28080Mages James G · Jordan, MNS/N 5-95 N28083Cheshire Daric · Portland, ORBuilt 1940 · S/N 5-99 N28084Clark Christopher W · Fallon, NVBuilt 1940 · S/N 5-98 N28104Aubin Carol M · Bangs, TXS/N 5-107 N28123Webster Bart · Rexburg, IDBuilt 1940 · S/N 5-109 N28124Schelde Brian L · Marble Falls, TXBuilt 1940 · S/N 5-110 N28125N28125 LLC · Wilmington, DEBuilt 1940 · S/N 5-111 N28143Powell Kenneth W · Ann Arbor, MIBuilt 1940 · S/N 5-116 N28144Maloy Toby · Albuquerque, NMS/N 5-117 N28153Dance Brett A · Bentonville, ARBuilt 1940 · S/N 5-124 N28161Van Wagner Aerial Media LLC · Hollywood, FLBuilt 1940 · S/N 5-122 N28180Copithorne Richard J · West Paris, MEBuilt 1940 · S/N 5-131 N28245Howe Norman E · Wausau, WIBuilt 1940 · S/N 5-164 N28248Potter Paul · Lopez Island, WABuilt 1940 · S/N 5-156 N2966CJames Neil · Scott City, KSS/N 5-804 N30270Luminair Inc · Ashland, ORBuilt 1940 · S/N 5-162 N30279Smith Daniel Bruce · Boonville, NCBuilt 1940 · S/N 5163 N30312Phillips Philip J · Monticello, MNBuilt 1940 · S/N 5-169 N30354Jaggers Wesley · Tupelo, MSS/N 5179 N30368Forsberg Danny J · Iron Ridge, WIBuilt 1940 · S/N 5-183 N30379Grant General J · Commerce Township, MIBuilt 1940 · S/N 5-184

Back to Piper J5A