Skip to content

Registered aircraft · 3,190

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

N100Bene Mary D · Ketchum, OKBuilt 1940 · S/N 5334 N10036Roberts Bruce D · New London, PABuilt 1944 · S/N 11906 N10440Johnson Jeffry L · Eufaula, OKBuilt 1958 · S/N 8439 N1049Soplata Walter C · Collierville, TNBuilt 1942 · S/N 8453 N10492Bateman Randy · Lindale, TXBuilt 1956 · S/N 45-4913 N104QSiegel George H · Reading, PABuilt 1940 · S/N 5335 N10510Jack Browns Seaplane Base Inc · Winter Haven, FLBuilt 1956 · S/N 45-4942A N10650Santorelly Aviation · Glen Saint Mary, FLS/N 10650 N10674Urbahn John A · Saratoga Springs, NYS/N 20168 N1071NWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1944 · S/N 13284 N10817Nance David B · Quinton, VAS/N 16727 N1082GBrito Juan L · El Paso, TXS/N 14087 N10XSWittman Flying Service · Ripon, WIBuilt 1946 · S/N 22366 N110RRGalloway Landings LLC · Caledonia, MIBuilt 1946 · S/N 19659 N110TCKerzen Properties LLC · Fayetteville, ARBuilt 1946 · S/N 15790 N11190Claire Aviation Inc · Wilmington, DES/N 43-507 N1129VCarolina Flying Machines LLC · Davidson, NCS/N 13956 N112RBLowers Jamesson B II · Little Hocking, OHBuilt 1941 · S/N 6205 N113MLCastello Branco Pablo · Montclair, NJBuilt 1947 · S/N 23086 N113WWSpitfire Aviation Inc · Wilmington, DEBuilt 1946 · S/N 14681 N1141VHampton Flying Services LLC · Portsmouth, NHBuilt 1943 · S/N 10490 N1174GAustin James M · Fort Worth, TXS/N 9829 N1176GCounts Jett T · East Palatka, FLS/N 15745 N11814Prusa Daniel J · Morgantown, WVBuilt 1946 · S/N 23048 N118VRAlliance Aircraft Sales Inc · Pierre, SDBuilt 1946 · S/N 22095 N119CGGreeley Barton M Jr · Coudersport, PABuilt 1946 · S/N 19824 N11GDPiccolo Marc · Alexandria, VABuilt 1945 · S/N 14847 N11MKMckenney Robert N · Schertz, TXBuilt 1946 · S/N 15748 N11PVJones Richard · Azalea, ORBuilt 1941 · S/N 7618 N1205PNewman Judith · Hood River, ORBuilt 1946 · S/N 17630 N1215NMcclure Mark R · Prescott, WIBuilt 1943 · S/N 10226 N12173Batchelor Terry W · Edwardsburg, MIS/N 18184 N1227NEgmond Aircraft LLC · Lewes, DEBuilt 1945 · S/N 13800 N122JTSpivey Harold E · Thomaston, GABuilt 1946 · S/N 15558 N123BWWiplinger Robert D · Inver Grove Hts, MNBuilt 1946 · S/N 17264 N123RWWiplinger Robert D · Inver Grove Hts, MNBuilt 1946 · S/N 15580 N1273VBlue Sky Properties Inc · Gainesville, FLBuilt 1945 · S/N 13998 N127JPSharair LLC · Thomasville, GABuilt 1946 · S/N 20770 N128BLHoudek Dennis E · Roseburg, ORBuilt 1947 · S/N 7569 N128MEPaddock Matthew M · Elkhorn, WIBuilt 1945 · S/N 14023 N1326NLemmon Richard W · Rhome, TXS/N 13476 N133RSBootcamp Helicopters LLC · Middletown, DEBuilt 1946 · S/N 16296 N1353MHyatt Philip D · Gadsden, ALBuilt 1942 · S/N 9913 N13LEStine Donny E Jr · Poplar Grove, ILS/N 17571 N1401NRegistration Pending · Carrollton, GARegistration pendingBuilt 1947 · S/N 22925 N1401VHayes Christopher C · Park Rapids, MNS/N 10771 N1402NBauman Scott H · Long Valley, SDBuilt 1947 · S/N 22926 N1403NLambert Karl S · Foley, ALS/N 22927 N1404NBrewer Tony · Lubbock, TXBuilt 1947 · S/N 22898 N1406VRegistration Pending · Wilmington, DERegistration pendingBuilt 1944 · S/N 12891

Back to Piper J3C-65