Skip to content

Registered aircraft · 125

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

N30996Everts Robert A · Sarasota, FLBuilt 1940 · S/N 41267 N31194Tigert Tommy R · Ovilla, TXBuilt 1940 · S/N 4-1280 N31196Royal Deanna J · Duluth, MNBuilt 1940 · S/N 4-1288 N32591Landon Jeff · Lancaster, CABuilt 1940 · S/N 4-1284 N32595Wilson Michael · Hickory Creek, TXBuilt 1940 · S/N 4-1292 N32597Wilks Thomas M · Wasilla, AKBuilt 1940 · S/N 4-1291 N32598Benson Edward A · San Antonio, TXBuilt 1940 · S/N 4-1293 N32694Clements Cameron J · Beardstown, ILBuilt 1940 · S/N 4-1298 N32698Similly Cyrus A · Hernando, FLS/N 4-1301 N32775Jewell Aviation Inc · Kennett, MOBuilt 1940 · S/N 4-1308 N32879Geisler Mark C · Dallas, TXBuilt 1940 · S/N 4-1314 N32880Cook Mike R · Rye, COBuilt 1940 · S/N 4-1318 N32884Schildberg Gregory M · Casey, IABuilt 1940 · S/N 4-1324 N33193Boze Ken Marco · Palmer, AKFirst renewal noticeBuilt 1940 · S/N 4-1350 N33288Aviation 4031 LLC · Pasadena, TXS/N 4-1360 N33427Bohmer Timothy C · Detroit Lakes, MNBuilt 1940 · S/N 4-1369 N35001Mccall John Lane · Arlington, TXBuilt 1940 · S/N 4-1372 N35005Groskurth Walter I · Mankato, MNBuilt 1940 · S/N 4-1382 N378GFFogle H Daniel III · North Salem, NYS/N 4-1185 N4001HLapiair LLC · Vergennes, VTBuilt 1940 · S/N 41108 N414JFoster Walter T · Terre Haute, INBuilt 1940 · S/N 41299 N47JRegistration Pending · Erwinna, PARegistration pendingBuilt 1939 · S/N 4-765 N60JWalrath Michael J · Indian Lake, NYS/N 4-1256 N6581HCook Mike R · Rye, COBuilt 1939 · S/N 4-831 N770VKlippert Kevin T · El Dorado, ARBuilt 1939 · S/N 4-730

Back to Piper J4A