Skip to content

Registered aircraft · 22

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

N21831Roberson Carlton L · Williamson, GABuilt 1938 · S/N 2608 N22894Elnitski Jeffrey J · Bellefonte, PAS/N 2802 N22986212 Investments LLC · Collinsville, OKS/N 2887 N23101Lark Enterprises LLC · Mitchell, SDBuilt 1939 · S/N 2883 N23165Irwin Luther J · Tucson, AZBuilt 1939 · S/N 2951 N23226Lindstrom John A · Hammond, WIBuilt 1939 · S/N 2992 N23252Ttnh LLC · Wilmington, DEBuilt 1939 · S/N 3016 N232PBBrandt Terry R · Hood River, ORS/N 3011 N23410Dyrstad Mary S · Hampshire, ILBuilt 1966 · S/N 3142 N235PRussell Robert · Worthington, OHRegistration revokedBuilt 1939 · S/N 3179 N24778Pike Timothy B · Odessa, FLBuilt 1984 · S/N 3440 N24853Rennie John Mason · New Smyrna Beach, FLS/N 3491 N24992Depoy Lowell · Salem, INBuilt 1939 · S/N 3590 N25052Hayhurst Shane R · Winfield, PABuilt 1939 · S/N 3624 N25708Lamm Christine L · Wernersville, PABuilt 1939 · S/N 3673 N25755Graham Randall S · Mendota Heights, MNBuilt 1939 · S/N 3711 N25835Etheredge William T IV · Texas City, TXBuilt 1939 · S/N 3785 N25977Kilburn Terry L · Edinboro, PABuilt 1939 · S/N 3920 N26811Jacobs James A · Lakeview, MIBuilt 1940 · S/N 4191 N26846Pollard Jim · Montrose, MIBuilt 1939 · S/N 4224 N28162Farris Timothy M · Raleigh, NCBuilt 1940 · S/N 4623 N37430Sbandi John L · New London, NCS/N 3338

Back to Piper J3F-50