Skip to content

Registered aircraft · 179

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

N10UGraber Paul E · Brooksville, MSBuilt 1940 · S/N 4231 N20284Schulz Gerald · Appleton, WIBuilt 1938 · S/N 2084 N21604Delgaizo Damian A · Andover, NJBuilt 1938 · S/N 2450 N21659Ramin Jeanette J · Houston, TXBuilt 1938 · S/N 2552 N22707Seppala Matthew T · Hortonville, WIBuilt 1938 · S/N 2680 N22884Meinen Albert D · Troy, ILBuilt 1939 · S/N 2794 N22918Treadway Timothy G · Burton, TXBuilt 1939 · S/N 2815 N22958Primary Flight Control LLC · Fleming Island, FLBuilt 1939 · S/N 2855 N23132Bent James L Jr DBA · Palatine Bridge, NYBuilt 1939 · S/N 2906 N24740Dreger Jeffrey W · Poplar Grove, ILBuilt 1939 · S/N 3413 N24797Wyatt Greg L · Summerville, GABuilt 1939 · S/N 3446 N24869Dejong Arie H · Maricopa, AZBuilt 1931 · S/N 3510 N25863Philips Joe C · Bryan, TXBuilt 1939 · S/N 3825 N25880Rother Earle W III · Sunnyvale, CABuilt 1939 · S/N 3833 N25894Old Style Aircraft LLC · Ellsinore, MOBuilt 1939 · S/N 3750 N25927Cuddie Robert R · Marble Falls, TXBuilt 1939 · S/N 3873 N25994Myrick Richard L · Williamson, GABuilt 1939 · S/N 3952 N26058Clifton Ronald L · Circleville, OHBuilt 1941 · S/N 6612 N26170Figure I Foundation · Los Angeles, CABuilt 1940 · S/N 4102 N26189Vanderbeek Robert K · Plainfield, ILBuilt 1940 · S/N 4108 N26197Roberts Bruce D · New London, PABuilt 1941 · S/N 7076 N26719Orlandi Properties LLC · Blairstown, NJBuilt 1940 · S/N 4140 N26810Whiting Mark D · Champaign, ILBuilt 1940 · S/N 4190 N26841Flying A Aviation LLC · Archer City, TXBuilt 1940 · S/N 4210 N26856Reed David A Trustee · Pinedale, WYBuilt 1940 · S/N 4221 N27024Machida Steven · Homer, AKBuilt 1940 · S/N 4332 N27049Lewis Joseph Burton · Walnut Cove, NCBuilt 1940 · S/N 4323 N27089Kansas Air LLC · Linn, KSS/N 4298 N27092Hawk Robert S · Argyle, TXBuilt 1940 · S/N 4350 N27120Albertson James M · Westville, FLS/N 4385 N27135Barr Myron · Spanaway, WABuilt 1940 · S/N 4377 N27154Heekin Michael P · Hummelstown, PABuilt 1940 · S/N 4399 N27923Goebel William R · Rhome, TXBuilt 1940 · S/N 4451 N27998Macginnis Thomas L · Ludlow, VTBuilt 1940 · S/N 4496 N28019Siegel Joanne R · Reading, PABuilt 1940 · S/N 4519 N28042Sas Aviation LLC · Carroll, OHBuilt 1940 · S/N 4542 N28107Cross Mark J · Nokesville, VABuilt 1940 · S/N 4583 N28118Nightingale Patrick R · Lakewood, CABuilt 1940 · S/N 4594 N28132Hesse Roy A · Stacy, MNS/N 4606 N28146Young James W · Talking Rock, GABuilt 1940 · S/N 4611 N28281Bc And B LLC · Lino Lakes, MNBuilt 1940 · S/N 4670 N302CBGordon David W · Saint Louis, MOBuilt 1940 · S/N 4104 N30329Vetter Brent E · Helena, MTBuilt 1940 · S/N 4794 N30358Ash James L · Whitefield, NHS/N 4808 N30372Gleason Rhett C · Timmonsville, SCBuilt 1940 · S/N 4908 N30472Hendrix Steven Roy · Bakersfield, CAS/N 4859 N30497Nyboer Paul H · Hamilton, MIBuilt 1940 · S/N 4876 N30519Ericson Steven P · Lancaster, CABuilt 1940 · S/N 4891 N30558Cardan Aircraft Services Inc · Red Bluff, CAS/N 4928 N30589Heichel Philip D · Marquette, MIS/N 4957

Back to Piper J3L-65