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.

N122WDyer James E · Brighton, COBuilt 1940 · S/N 4-846 N21696Peterson Cristopher M · Yelm, WAS/N 4-481 N21867Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1938 · S/N 4-410 N22724Moran Peter James · Como, MSBuilt 1938 · S/N 4-431 N22764Rice Allen P · Caldwell, IDS/N 4-451 N22772Wilcox J K · Lakeland, TNBuilt 1939 · S/N 4-456 N22854Ferguson Jean C · Forest, VABuilt 1939 · S/N 4497 N22881Piper Aviation Museum Foundation · Lock Haven, PABuilt 1939 · S/N 4-502 N22960Cleis Richard A · Kihei, HIBuilt 1939 · S/N 4-520 N22966Thomas John L · Port Orange, FLBuilt 1939 · S/N 4-522 N23109Shamrock Aviation LLC · Seabrook, NHBuilt 1939 · S/N 4-532 N23194Alvis Michael DBA · Parkton, NCBuilt 1939 · S/N 4548 N23200Morois Howard J · Green Bay, WIBuilt 1939 · S/N 4-556 N23211Matthews Franklin L · Mc Alpin, FLBuilt 1939 · S/N 4-555 N23255Griebsch James J · Saranac Lake, NYBuilt 1939 · S/N 4569 N23326Russell Michael K · Sprakers, NYBuilt 1939 · S/N 4-585 N23417Komrowski Ronald H · Jupiter, FLBuilt 1939 · S/N 4-611 N24520Mcfetridge Anne S Trustee · Fabius, NYBuilt 1939 · S/N 4-634 N24523Royal David T · Duluth, MNBuilt 1939 · S/N 4-632 N24533Mcdonald Brad C · Swanton, OHBuilt 1939 · S/N 4-636 N24536Byers Steven J · San Diego, CABuilt 1939 · S/N 4-635 N24550Registration Pending · Wasilla, AKRegistration pendingS/N 4-639 N24564Lumland Properties LLC · Winchester, VABuilt 1939 · S/N 4-649 N24571Erickson Karl L · Hope, MES/N 4-648 N24572Brown Michael G · Rogue River, ORBuilt 1939 · S/N 4-652 N24681Horst Aviation LLC · New Holland, PABuilt 1939 · S/N 4683 N24699Bingham Mark D · Lakewood, COS/N 4-690 N24701Corry Thomas F · Rockport, TXS/N 4-687 N24776Hammer Douglas · Sandia, TXBuilt 1939 · S/N 4-718 N24812Balcom George H · Bemus Point, NYS/N 4-731 N24829Mazza Ral James · Plano, TXBuilt 1939 · S/N 4-742 N24844Linex Martin E · Greenville, TXBuilt 1939 · S/N 4-740 N24852Vittorio Frank M · Saginaw, MNBuilt 1939 · S/N 4-743 N24901Eaa Chapter 1580 Inc · Houghton Lake, MIS/N 4-699 N24921High Planes Aviation LLC · Goodland, KSBuilt 1939 · S/N 4-705 N24925Bensinger Group Inc · Meridian, IDBuilt 1939 · S/N 4-762 N24926Quinby Bruce · Kingston, TNBuilt 1939 · S/N 4761 N24929N24929 LLC · Ada, MIBuilt 1939 · S/N 4-763 N24952Case Jeffery R · Camas, WABuilt 1939 · S/N 4-770 N25049Glasser W Dean · Boswell, PABuilt 1939 · S/N 4818 N25753Komin Steve C · Ingleside, ILBuilt 1939 · S/N 4-823 N25844Koblenzer Fredric Matthais · Key Largo, FLBuilt 1939 · S/N 4-826 N26144Jackson Robert L · Leesburg, VABuilt 1940 · S/N 4-843 N26154J4 Cub Partners LLC · Highwood, ILBuilt 1940 · S/N 4-855 N26188Johnson Michael W · Youngsville, LABuilt 1940 · S/N 4865 N26196Schildberg Gregory M · Casey, IABuilt 1940 · S/N 4-872 N26700Harvey Aaron J · New London, WIBuilt 1940 · S/N 4-864 N26716Mottweiler Martin · Dowagiac, MIBuilt 1940 · S/N 4-859 N26730American Airpower Heritage Flying Museum · Dallas, TXS/N 4-870 N26747Sale Reported · Altura, MNSale reported, pending cancellationS/N 4-888

Back to Piper J4A