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.

N26797Three Doc'S #2 LLC · Fort Lauderdale, FLBuilt 1940 · S/N 4907 N26802Powers Harry R II · London, OHS/N 4-909 N26809Johnson Joyce C · Cumberland, MDBuilt 1940 · S/N 4-911 N26816Messerer Jonathan D · Duluth, MNFirst renewal noticeBuilt 1940 · S/N 4-913 N26912Rockdale Flying Tigers Inc · Rockdale, TXBuilt 1940 · S/N 4-978 N26914Dent William M · Winston Salem, NCBuilt 1940 · S/N 4-939 N26920Deuce Coupe Aviation LLC · Columbia City, INBuilt 1940 · S/N 4-962 N26940Epley Kennith W · Ladonia, TXBuilt 1940 · S/N 4-966 N26995Mckay Franklin D · Rockport, TXBuilt 1940 · S/N 4-986 N27025Daphna Inc · Middletown, DEBuilt 1940 · S/N 4-997 N270313 Point Aviation LLC · Saint Louis, MOBuilt 1940 · S/N 4-998 N27051Geisler Mark C · Dallas, TXS/N 4-1002 N27069Briard Ashley · Frazee, MNBuilt 1940 · S/N 4-1006 N27078Martin Ronald P · Tehachapi, CABuilt 1940 · S/N 4-1009 N27083Guilfoyle Glenn · Van Hornesville, NYBuilt 1940 · S/N 4-1013 N27099Koepl Steven W · Post Falls, IDBuilt 1940 · S/N 4-1018 N27834Smith Ronald M · Brawley, CABuilt 1940 · S/N 4-1052 N27836Zigmont David E · Brodhead, WIBuilt 1940 · S/N 4-1055 N27844Montgomery Darrell R · Dayton, OHBuilt 1940 · S/N 4-1064 N27849James Edward Adam · Strongsville, OHS/N 4-1069 N27857Cain Jeffrey J · Denver, COBuilt 1940 · S/N 4-1077 N27858Lust Gary L · Iowa City, IABuilt 1940 · S/N 4-1078 N27868Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1940 · S/N 41089 N27873Lenning Zacariah D · Fort Wayne, INBuilt 1940 · S/N 4-1098 N27887Lawrence Glenn R · Rochester, MABuilt 1940 · S/N 41112 N27892Herrington Jimmy Jr · Rayville, LAS/N 41119 N27894Fisher Christopher J · Nora, ILBuilt 1940 · S/N 4-1116 N27899Merrick Connor D · Wendell, IDS/N 41122 N28209Shea Timothy M · Pearland, TXBuilt 1940 · S/N 4-1135 N28232Woodstock Pilots Club Inc · Linville, VABuilt 1940 · S/N 4-1154 N28233Riley Glenn R · Mexico, MOBuilt 1952 · S/N 4-1156 N3011CMatthews Franklin L · Mc Alpin, FLFirst renewal noticeS/N 4-571 N30340Schultz Clarence H · Elgin, MNBuilt 1940 · S/N 4-1169 N30342Beugli David M · Astoria, ORBuilt 1940 · S/N 4-1170 N30343Jenkins Michael D · Rigby, IDBuilt 1940 · S/N 41171 N30348Mulder Darryl J · Galesburg, MIS/N 4-1176 N30403Besch Thomas M · West Sand Lake, NYBuilt 1940 · S/N 4-1182 N30410J4 Coupe Inc · Jacksonville, FLBuilt 1940 · S/N 41192 N3042Potter Everett A · Lansford, NDS/N 4-1190 N30429Nance David B · Quinton, VAS/N 4-1221 N30432Alexander John H · Sandwich, MABuilt 1940 · S/N 4-1212 N30434Gugisberg Mark R · Longville, MNBuilt 1955 · S/N 4-1220 N30435Davis Judith A · David City, NEBuilt 1940 · S/N 4-1219 N30808Newberry Daniel W · Kevil, KYFirst renewal noticeS/N 4-1242 N30971Hill Kevin J · Aurora, MNBuilt 1940 · S/N 4-1249 N30975Turner Larry · Fallon, NVBuilt 1940 · S/N 4-1248 N30985Rose Carl Warrent · Westmoreland, TNBuilt 1940 · S/N 4-1266 N30986Lundy William C · Shaker Heights, OHS/N 4-1264 N30992Goheen Gordon C · Battle Ground, WAS/N 4-1270 N30995Kirk Kevin J · Pulaski, PABuilt 1940 · S/N 4-1269

Back to Piper J4A