Skip to content

Registered aircraft · 48

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

N13RNMurphy Dale · Pagosa Springs, COBuilt 1936 · S/N 938 N15965Maxson Lee V · Mesa, AZBuilt 1936 · S/N 509 N15971Sanford Mark · Ithaca, NYS/N 515 N16314Eaa Chapter 626 · El Dorado, ARBuilt 1936 · S/N 547 N16621Stewart Robert J Jr · Erie, PABuilt 1936 · S/N 636 N16651Horst Aviation LLC · New Holland, PABuilt 1936 · S/N 666 N16769Castle Air LLC · Livermore, CABuilt 1936 · S/N 771 N16935Bowe Drew J · Poplar Grove, ILBuilt 1936 · S/N 801 N16971Registration Pending · Ashley, MIRegistration pendingBuilt 1936 · S/N 837 N17220Mcneill Daniel A · Placerville, CABuilt 1936 · S/N 886 N17234Berney John E · Morgan Hill, CABuilt 1936 · S/N 1014 N17247Antique Preservation Assn Greenfield · Greenfield, IABuilt 1937 · S/N 913 N17283Harter Michael R · Greenfield, INBuilt 1937 · S/N 950 N17287Tomasz Steve · Westland, MIBuilt 1937 · S/N 1222 N17540Sweeney Lori · Murray, KYBuilt 1936 · S/N 1040 N17542Griffin Lauriane Trustee · Red Bluff, CABuilt 1936 · S/N 1042 N17549Brown Thomas E · Coalinga, CABuilt 1936 · S/N 1049 N17554Martinez Anthony Nmn · Great Bend, KSS/N 1057 N17569Barry Kevan · Gig Harbor, WAS/N 1069 N17579Bell Lawrence · Caldwell, IDBuilt 1936 · S/N 1079 N17834Rhinebeck Aerodrome Museum · Rhinebeck, NYS/N 1269 N17837Short David J · Warrensburg, MOS/N 1272 N17847Flying M Services Inc · Germansville, PAS/N 1282 N17854Plourde Steve J · Woodstock, ILS/N 1289 N17872Ficklin Robert L · Fairbury, ILBuilt 1937 · S/N 1306 N17876Beicker Dennie L · Hernando, MSS/N 1310 N17910Old Aeroplane Co LLC · Fort Ogden, FLBuilt 1937 · S/N 1510 N19202Jacobs James A · Lakeview, MIBuilt 1937 · S/N 1602 N19213Port Townsend Aero Museum · Port Townsend, WABuilt 1947 · S/N 1613 N19232Decklar Mark R · Grass Valley, CAS/N 1632 N19236Hendrickson Steve L · Lake Stevens, WABuilt 1937 · S/N 1636 N19263Sweeney Aron T · Murray, KYBuilt 1937 · S/N 1663 N19285Wright Thomas L · Clyde, OHBuilt 1937 · S/N 1685 N19502Dexter Fred H · Live Oak, FLBuilt 1937 · S/N 1702 N19510Wagner James E Jr · Peotone, ILBuilt 1937 · S/N 1710 N19511Rare Aircraft Ltd · Faribault, MNBuilt 1937 · S/N 1711 N19518Nichols Charles F Trustee · Baldwin Park, CABuilt 1937 · S/N 1718 N19599White Brian Richard · Concrete, WABuilt 1937 · S/N 1799 N20037Gonzales Donald M · Columbia Station, OHBuilt 1937 · S/N 1837 N20078Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1957 · S/N 1878 N20084Gonzales Donald M · Columbia Station, OHBuilt 1939 · S/N 1884 N20096Higley Rick · Basehor, KSBuilt 1937 · S/N 1896 N20101Carter Curtiss D · Orono, MES/N 1901 N20150Sweeney Andrew H · Murray, KYBuilt 1938 · S/N 1950 N20161Gaskill Leslie David · Ottumwa, IABuilt 1938 · S/N 1961 N37AZFreeman Heritage Collection LLC · Kingsbury, TXS/N 1926 N3WYLeonard Martin D · Aguanga, CAS/N 935 N4108KSmith Andrea M · Ripon, CABuilt 1936 · S/N 1035

Back to Piper J-2