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.

N35610Cox John E · Tucson, AZBuilt 1941 · S/N 5-704 N35613Letourmeau Jaffe B · Olympia, WABuilt 1941 · S/N 5-706 N35620Baker Ryan · Memphis, TNBuilt 1941 · S/N 5-714 N35622Bailey Carlton D Jr · Huntington, WVBuilt 1941 · S/N 5-715 N35624Watson Joshua J · Wilton, CAS/N 5-717 N35688Colvin Clu Dusting DBA · Big Cabin, OKBuilt 1941 · S/N 5-732 N35697Haldeman Enterprises LLC · Vancouver, WABuilt 1941 · S/N 5-725 N35721Bakken Al J · Belgrade, MTBuilt 1941 · S/N 5-762 N35745Smith Robert D · Roanoke, TXS/N 5-747 N35762Aerial Sign North Inc · Lakewood, NJBuilt 1941 · S/N 5-753 N35764Routh Gary L · Lebanon, TNBuilt 1941 · S/N 5-758 N35784Jackson James C · Hickory, PAS/N 5-765 N35786American Airpower Heritage Flying Mu · Dallas, TXBuilt 1941 · S/N 5-772 N35793Mcenery Brian T · Elmendorf, TXBuilt 1941 · S/N 5-770 N35811Scott Barry R · Florence, ALBuilt 1941 · S/N 5-773 N35819Erickson Mark D · Valley Springs, SDS/N 5-781 N35822Mcrobie Roger L · Maryville, TNBuilt 1941 · S/N 5-786 N35827Watkins Lawrence A · San Jose, CABuilt 1941 · S/N 5-798 N35862Rustad Scott K · Minot, NDBuilt 1941 · S/N 5801 N35927Fielding David J · Scarborough, MEBuilt 1941 · S/N 5-815 N35931Kelley Joseph W · Helena, MTBuilt 1941 · S/N 5821 N3762ULeipzig Andrew E · Ethridge, TNBuilt 1941 · S/N 5-678 N37641Messerer Jonathan D · Duluth, MNBuilt 1955 · S/N 5-178 N37959Collins Dennis L · Richland, WABuilt 1941 · S/N 5-839 N37961Gerwig Joseph L · Sutton, AKBuilt 1941 · S/N 5-832 N37964Reffett John S · Eagle River, AKBuilt 1941 · S/N 5-831 N38028Mason Michael S · Sequim, WABuilt 1941 · S/N 5-840 N38030Port Townsend Aero Museum · Port Townsend, WABuilt 1941 · S/N 5-838 N38041Palmer Ronald E Trustee · Hopkinton, NHBuilt 1941 · S/N 5-841 N38045William B Roark · Silverdale, WABuilt 1941 · S/N 5-861 N38048Thiel Roger N · Washington, DCBuilt 1941 · S/N 5-854 N38055Stewart Emerson C · Waynesville, OHBuilt 1941 · S/N 5-870 N38070Aas LLC · Ovid, MIBuilt 1941 · S/N 5-857 N38130Table Rock Aviation LLC · Lenoir, NCBuilt 1941 · S/N 5-882 N38131Rivera Ar · Nevada City, CABuilt 1941 · S/N 5874 N38139Armstrong David D · Mora, MNBuilt 1941 · S/N 5-883 N38184Yocum Daniel R · Boise, IDS/N 5-885 N38238Homolka James D · Ellsworth, KSBuilt 1941 · S/N 5-907 N38239Flemming Richard E · Kinsman, OHBuilt 1941 · S/N 5-908 N38244Munroe Consulting Inc · Ocala, FLBuilt 1941 · S/N 5-915 N38245Foster Gifford L · Torrington, WYBuilt 1941 · S/N 5916 N38297Parra Macarena · Taylorsville, CAS/N 5-936 N38395Buyak David W · New Hartford, CTBuilt 1941 · S/N 5945 N38399Registered aircraftBuilt 1941 · S/N 5949 N38402Horst Aviation LLC · New Holland, PABuilt 1941 · S/N 5-952 N38405Stavolone Daniel P · Maynard, MABuilt 1941 · S/N 5-956 N38408Pearson Luke D · Anchorage, AKBuilt 1941 · S/N 5-959 N38415Kibler John A · Mt Airy, MDBuilt 1941 · S/N 5966 N38418Caldwell Gregg P · Desert Hot Springs, CAS/N 5-968 N38420Cowie Leland K · Jonesburg, MOBuilt 1941 · S/N 5-970

Back to Piper J5A