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.

N47MMNorstar Aviation LLC · Farmingdale, NYBuilt 1977 · S/N 31-7812036 N500QSanborn Map Co Inc · Colorado Springs, COBuilt 1973 · S/N 31-7300934 N508YLally Michael M · Miami, FLBuilt 1969 · S/N 31-452 N510CCAwmr LLC · Conroe, TXBuilt 1978 · S/N 31-7812127 N5179CPersonal Air Transportation Inc · Wilmington, DES/N 31-7401252 N521AWUrban Equipment LLC · Vineland, NJBuilt 1971 · S/N 31-765 N52394Aero Missions LLC · Zeeland, MIBuilt 1973 · S/N 31-7401207 N52437Alabama Law Enforement Agency · Montgomery, ALBuilt 1981 · S/N 31-8112039 N540PSteenrod Kenneth A · Parsons, KSS/N 31-65 N555VSMcgregor Daniel A · Denali Park, AKBuilt 1971 · S/N 31-791 N59870Talkeetna Aero Services Inc · Anchorage, AKS/N 31-7612071 N59984Alpha Whiskey 1 LLC · Brandon, MSBuilt 1975 · S/N 31-7512042 N5CQDlc Aviation LLC · Lakeland, GABuilt 1973 · S/N 31-7400977 N5CTBws Industries LLC · Lake Forest, CAS/N 31-8312015 N5FGCicioni Aviation Inc · Hazleton, PAS/N 31-7912080 N5LLInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 31-7812041 N61430Arias Aviation Inc · Wilmington, DEBuilt 1974 · S/N 31-7401242 N61470White Jerald W DBA · Jackson, TNBuilt 1974 · S/N 31-7401262 N61490Wings Of Hope Inc · Chesterfield, MOBuilt 1975 · S/N 31-7512004 N620WFSocal Air LLC · Cheyenne, WYBuilt 1967 · S/N 31-17 N624MEPetry Christopher M · Frankfort, ILFirst renewal noticeBuilt 1969 · S/N 31-624 N63693Budd Aircraft Enterprises Inc · Chesterfield, MOBuilt 1977 · S/N 31-7712025 N6475LTerra Flight Aerial Imaging Inc · Spring, TXBuilt 1969 · S/N 31-436 N65MRAtarah LLC · Tucson, AZBuilt 1968 · S/N 31-347 N6620LMc Gregor Daniel A · Denali Park, AKBuilt 1969 · S/N 31-554 N669CWPrecision Air Inc · Nelson Lagoon, AKBuilt 1969 · S/N 31-514 N6719LAwmr LLC · Conroe, TXBuilt 1969 · S/N 31-615 N6762LSummit Aviation LLC · Sun Valley, IDBuilt 1970 · S/N 31-664 N700GLPitcock Aviation LLC · Tompkinsville, KYBuilt 1967 · S/N 31-83 N7045KBarrow Abby Renee · Hankamer, TXS/N 31-173 N7069DSo Many Trees LLC · Hanover, NHBuilt 1978 · S/N 31-7812081 N7086ZAlli Cat Aire LLC · Rehoboth Beach, DES/N 31-7812083 N70ZRusyniak Anthony J · Syracuse, NYBuilt 1968 · S/N 31-357 N711JWMohammadi Roya · Northridge, CAS/N 31-7712084 N7139CGv Air Inc · Medford, ORBuilt 1969 · S/N 31-553 N719PFuhr David · Wabasso, MNBuilt 1968 · S/N 31-272 N72FAJones Donald T Jr · Barrigada, GUBuilt 1977 · S/N 31-7812023 N7426LWright Air Service Inc · Fairbanks, AKBuilt 1972 · S/N 31-812 N7432LStandard Air LLC · West Linn, ORBuilt 1972 · S/N 31-820 N7434LIsland Wings Inc · Fort Lauderdale, FLBuilt 1972 · S/N 31-822 N7445LKnight Flyer Inc · Clarkston, MIBuilt 1972 · S/N 31-838 N748NPBelle Island Management LLC · Fort Lauderdale, FLBuilt 1969 · S/N 31474 N7553LSayers James B · Edison, OHFirst renewal noticeBuilt 1972 · S/N 31-7300936 N7599LAviation Pursuits Inc · Carrollton, GABuilt 1974 · S/N 31-7400988 N768PEMts Inc · Middletown, DEBuilt 1977 · S/N 31-7712037 N770JFSams J Mark · Franklin, OHFirst renewal noticeS/N 31-7712069 N777SCInternational Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 31-596 N782DEBoard Susan W · Moundsville, WVBuilt 1968 · S/N 31-224 N79AKGlobal Aircraft Trust Inc · Cheyenne, WYBuilt 1969 · S/N 31-472 N7JVGreer Air Inc · Saint Cloud, FLBuilt 1971 · S/N 31-789

Back to Piper PA-31-310