Skip to content

Registered aircraft · 127

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

N108RHBashaw Nathan R · Salem, NYBuilt 1940 · S/N 5958 N12190Cirrus Sr22t 9120 Inc Trustee · Wilmington, DEBuilt 1940 · S/N 5805 N1406NShirley Tyler A · Dalton, GABuilt 1947 · S/N 22929 N21583Batte Randall · Forest, MSBuilt 1938 · S/N 2436 N21661Bracewell Brent E · Zebulon, GABuilt 1938 · S/N 2549 N21828Holt Arlin J · Waterford, MEBuilt 1938 · S/N 2613 N2239YSale Reported · Lakeland, FLSale reportedS/N 5536 N22934Sonex Aircraft LLC · Oshkosh, WIBuilt 1939 · S/N 2834 N23209Mitchell Asher · Senoia, GABuilt 1939 · S/N 2985 N23345Faulkner Ronnie L · Royal, ARBuilt 1939 · S/N 3089 N2364KEngler William O · Filion, MIBuilt 1939 · S/N 3108 N24614King-Mameli Laurie · Thomaston, GABuilt 1939 · S/N 3300 N25032Nelson Bruce · Lutz, FLBuilt 1939 · S/N 3611 N25822Duke Jimmy · Isola, MSS/N 3777 N25850Morey Airplane Co Inc · Middleton, WIBuilt 1939 · S/N 3796 N25986Douglas R Herlihy LLC · Goldendale, WABuilt 1939 · S/N 3934 N26053Duck Donald · Edwardsburg, MIBuilt 1939 · S/N 3991 N26173Beaver Perry L · Vienna, OHBuilt 1940 · S/N 4100 N26858Ferreira James M · Dixon, CAS/N 4225 N27079Mincer Robert C · Middlesex, NYBuilt 1940 · S/N 4342 N27132Osborne Brian D · Shoreline, WABuilt 1940 · S/N 4380 N27974Crossroads Farms Inc · Aurora, NES/N 4486 N28148North Central Marketing Inc · Cranston, RIBuilt 1940 · S/N 4615 N29042Stevann Farms Ltd · De Witt, IABuilt 1940 · S/N 6013 N30272James Rick L · Fort Wayne, INBuilt 1940 · S/N 4751 N30459Dowd Darin R · Frisco, TXBuilt 1940 · S/N 4845 N30875Emmerson James E · Fort Scott, KSBuilt 1940 · S/N 5168 N30906Vesely Edward A · Houston, TXBuilt 1940 · S/N 5191 N31017Hicks Paul G · Lizton, INBuilt 1962 · S/N 5257 N31086Cabigas John V · Yuba City, CABuilt 1940 · S/N 5314 N31118Smith Walter E Jr · Villa Ric A, GABuilt 1940 · S/N 5336 N32671Ricca Gregory F · Jonesboro, ARS/N 5530 N32737Baker Ronald D · Scranton, KSBuilt 1940 · S/N 5569 N32758Sides Fred W · Medina, TXBuilt 1940 · S/N 5593 N32857Henley Charles D · New London, NCBuilt 1940 · S/N 5665 N32918Comanche Warbirds Inc · Houston, TXBuilt 1949 · S/N 5709 N32946Williams Robert M · Red Hook, NYBuilt 1940 · S/N 5730 N33141Tarakji Mohamad H · Van Nuys, CABuilt 1940 · S/N 5859 N33204Crc Air Assets LLC · Houston, TXS/N 5910 N33227Cranwill Joseph H · Chatham, ILBuilt 1940 · S/N 5902 N33229Bowers Curt E · Jennings, LABuilt 1940 · S/N 5903 N33233Red Oak Airpark Flying Club · Cabot, ARS/N 5947 N33236Smith Ernest C · Cato, NYBuilt 1940 · S/N 5911 N33240Weber Stephen J · Hastings, MNBuilt 1940 · S/N 5915 N33256Kourtis Vintage Aviation LLC · Owasso, OKBuilt 1940 · S/N 5930 N33438Roholt Philip C · Canton, OHBuilt 1940 · S/N 5943 N33442Chinlund Jeffrey B · Greenville, NCBuilt 1940 · S/N 5957 N33453Piper Gary S · Hendersonville, TNBuilt 1940 · S/N 5962 N33461Bennett Robert M · Felton, DEBuilt 1940 · S/N 5970 N33465Mcclintock Matthew Patrick · Oscoda, MIBuilt 1940 · S/N 5976

Back to Piper J3F-65