Skip to content

Piper PA-31-310

Registered aircraft · 128

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

N100JRLumland Properties LLC · Winchester, VABuilt 1969 · S/N 31-599 N100NESanborn Map Co Inc · Colorado Springs, COS/N 31-7712022 N100RTRanch 100 LLC · Fort Pierce, FLS/N 31-808 N101YBCowan Lance E · Watonga, OKBuilt 1969 · S/N 31-406 N111PKScruggs Ken · Galloway, OHBuilt 1974 · S/N 31-7401246 N116GWMajestic Airlines Inc DBA · Lynden, WABuilt 1970 · S/N 31-662 N11UTMax Aviation LLC · Venice, FLBuilt 1967 · S/N 31-116 N123KW123 LLC · Allentown, PABuilt 1968 · S/N 31-198 N129BBLawson Michael · Englewood, TNBuilt 1969 · S/N 31-481 N135RJKontz Gary Lee · Canby, MNBuilt 1967 · S/N 31-52 N143KYClark Michael B · Montgomery, TXBuilt 1974 · S/N 31-7401255 N179ECKibler Inc · Wilmington, DEBuilt 1972 · S/N 31-839 N1851APlacer County Sheriffs Department · Auburn, CABuilt 1977 · S/N 31-7812030 N190TATuck Aerial Surveys Inc · Big Stone Gap, VABuilt 1980 · S/N 31-8012040 N191TASanborn Map Company Inc · Colorado Springs, COBuilt 1974 · S/N 31-7401230 N199DSIsland Wings Inc · Fort Lauderdale, FLBuilt 1973 · S/N 31-7400980 N203AMInternational Jets Inc · Gig Harbor, WABuilt 1979 · S/N 31-7912037 N24KAAllison Kenneth T · Etowah, NCBuilt 1968 · S/N 31-298 N25GSMorris Jeffrey Thomas · Lake Delton, WIBuilt 1968 · S/N 31-239 N271MCSunshine Aero Industries Inc · Crestview, FLBuilt 1967 · S/N 31-175 N27275Island Wings Inc · Fort Lauderdale, FLBuilt 1977 · S/N 31-7712066 N27349Valley Airways Inc · Scottsbluff, NEBuilt 1977 · S/N 31-7712087 N27567Plecenik William J · Erwinna, PABuilt 1978 · S/N 31-7812054 N27850Presby Aire LLC · Berlin, NHBuilt 1978 · S/N 31-7912024 N278RCSanborn Map Company Inc · Colorado Springs, COBuilt 1978 · S/N 31-7912018 N27987Alaska Air Taxi LLC · Anchorage, AKBuilt 1979 · S/N 31-7912054 N29872Mijoba Nadesha · Raleigh, NCBuilt 1972 · S/N 31-7300932 N2WMAir Resources Helicopters Inc · Salt Lake City, UTBuilt 1973 · S/N 31-7300975 N30DFDae Aviation Enterprises Corp · Gilford, NHBuilt 1974 · S/N 31-7401263 N310PGMid-South Bulk Services Inc · West Memphis, ARS/N 31-7512051 N3176HG B T S LLC · Yatesville, GAS/N 31-7300913 N31FFSparky Holdings LLC · Orlando, FLS/N 31-7612021 N3530BGlobal Avionics LLC · Downey, CABuilt 1979 · S/N 31-7912075 N3539UBechara Nizar E · Columbia, MDBuilt 1979 · S/N 31-7912120 N3545ZGrande Skyclub Inc · Merritt Island, FLBuilt 1979 · S/N 31-8012015 N3551CRegistered aircraftAssigned, pending cancellationS/N 31-8012019 N3555KPerman Edward O Jr · Rainbow City, ALBuilt 1980 · S/N 31-8012037 N3556XWest Bend Air Inc · West Bend, WIBuilt 1980 · S/N 31-8012042 N3586XPops Aviation Inc · Spartanburg, SCBuilt 1980 · S/N 31-8012070 N38TCInternational Albatros Holdings Corp · Cottonwood, AZBuilt 1967 · S/N 31-96 N3949WAero Craft Specialties LLC · Natchitoches, LAS/N 31-211 N400SHogan Aviation LLC · Marlton, NJBuilt 1977 · S/N 31-7712083 N4077NChilds Meray · Huntingdon Valley, PAS/N 31-8112027 N4102ZValley Airways Inc · Scottsbluff, NEBuilt 1981 · S/N 31-8212009 N412TMFlying J Aviation LLC · Sargent, NES/N 31-510 N424PAviation Co LLC · Kaneohe, HIBuilt 1974 · S/N 31-7401222 N44RLCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1973 · S/N 31-7401217 N4506NCarsey Rick D · Fowler, CAS/N 31-8112009 N47698Mcgregor Daniel A · Denali Park, AKBuilt 1968 · S/N 31-153 N478APValiair Limited Co Trustee · Casper, WYBuilt 1974 · S/N 31-7400993

Back to Piper PA-31-310