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.

N810GCWest Randolph E · Chicago, ILS/N 31-8112036 N811CBRfw Construction Group LLC · Dyersburg, TNBuilt 1974 · S/N 31-7512001 N81RHSpecialty Aviation II LLC · Jupiter, FLBuilt 1972 · S/N 31-7300909 N827HTWings Over Texas Holdings LLC · Denton, TXS/N 31-156 N828BDEchols Mill Aviation LLC · Elberton, GABuilt 1982 · S/N 31-8212017 N830MCArmor Packaging Corp · Piedmont, SCBuilt 1972 · S/N 31-830 N83RAPessoa Guiherme · Winter Garden, FLS/N 31-638 N853CTFaber Aviation LLC · Melbourne, FLBuilt 1969 · S/N 31-614 N85DLDelta Lima Inc · Justice, WVBuilt 1967 · S/N 31-23 N86CMNewman Aviation Services Inc · Tiffin, OHBuilt 1969 · S/N 31-468 N870MHurn Enterprises LLC · Grand Beach, MIS/N 31-151 N87TSRwr Air Inc · Tok, AKBuilt 1973 · S/N 31-7300969 N8RUN8ru LLC · Sedona, AZBuilt 1976 · S/N 31-7612109 N9009YConchas Abel · Boiling Springs, SCBuilt 1967 · S/N 31-14 N9069YAmi Aviation Inc · Monroe, NYBuilt 1967 · S/N 31-99 N911PALee County Port Authority · Fort Myers, FLBuilt 1968 · S/N 31-207 N911SDAviation Trust Company LLC · Oklahoma City, OKBuilt 1973 · S/N 31-7300919 N9131YPiper Aircraft Inc · Vero Beach, FLBuilt 1968 · S/N 31-177 N9247YWest Bend Air Inc · West Bend, WIBuilt 1968 · S/N 31-322 N9287YGallagher James · Wyoming, PABuilt 1969 · S/N 31-380 N9292YWeisend Chad M · Logansport, INBuilt 1969 · S/N 31-387 N92HRSweetsholdings LLC · Lewisville, TXBuilt 1970 · S/N 31-649 N942WDHemdmm Corp · Wilmington, DEBuilt 1968 · S/N 31-333 N95TASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1973 · S/N 31-7300971 N987DSMission Boston D-Day LLC · Parker, COS/N 31-79 N999AWRamakrishna Murali DBA · Citra, FLBuilt 1967 · S/N 3170 N999SXPiper Panther LLC · Lewes, DES/N 31-587 N9ELKcs LLC · Renton, WABuilt 1971 · S/N 31-720

Back to Piper PA-31-310