Skip to content

Registered aircraft · 104

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

N4218VCub Club Inc · Sayville, NYFirst renewal noticeS/N 15314 N42340Shepard Gregory W · Fort Myers, FLS/N 14590 N42585Engel Stephen J · Plymouth, INBuilt 1945 · S/N 14866 N42669Isaacs Bradley J · Dahlonega, GABuilt 1945 · S/N 14963 N42959Dickerson Vernon B · Louisburg, NCS/N 15318 N45769Dyrstad William M · Hampshire, ILS/N 5565 N48303Carroll Michael J · Athol, IDBuilt 1946 · S/N 18534 N4999AMiller Jay Mark · Grantsville, MDBuilt 1946 · S/N 5288 N50364Kriegsman Transfer Co · Pekin, ILBuilt 1943 · S/N 10300 N51539Van Wagner Aerial Media LLC · Pembroke Pines, FLBuilt 1943 · S/N 10491 N6134HKron Howard H DBA · Clara City, MNBuilt 1946 · S/N 19299 N6535HAerial Sign North Inc · Lakewood, NJBuilt 1946 · S/N 19722 N6565HAnderson Michael J · Hilmar, CABuilt 1946 · S/N 19757 N6711HFieguth Walter J · Fresno, CABuilt 1946 · S/N 19925 N69098Plaskett Mark G · King City, CAS/N 45-4905 N70267Evans Michael J · Rowlett, TXBuilt 1946 · S/N 17248 N70299Cross Thomas Ad · Yacolt, WABuilt 1946 · S/N 17494 N70555Hecht Waldo E · Vassar, MIBuilt 1946 · S/N 17564 N70777Skywagon Aero LLC · Wilmington, DEBuilt 1946 · S/N 17797 N70935Steed James · Bryant, ARBuilt 1946 · S/N 17959 N72281Fallis John S · Lafayette, LAS/N 3830 N7291HDavis David H · Chugiak, AKBuilt 1946 · S/N 20550 N7322HAviation Services Inc · Barre, VTBuilt 1946 · S/N 20582 N7365HExcelsior Aviation 2 LLC · Lewes, DES/N 20626 N755MAMills Air Service Inc · Marstons Mills, MAS/N 15785 N75777Bronson Dale P · Bargersville, INS/N 1 N77540Kormanyos Steven J Jr · Brasher Falls, NYS/N 22030 N77596Sauer Rodney · Carpio, NDBuilt 1946 · S/N 22087 N858EMThompson Andrew M · Larimore, NDS/N 213C N8688Fabbri John A · Oneida, TNBuilt 1940 · S/N 5245 N87210Bfr Racing Inc · Monticello, ARS/N 6664 N87834Chase 13 LLC · Wilmington, DES/N 15264 N88133Godbold Robert L · Apex, NCBuilt 1946 · S/N 15750 N88222Blake Douglas G · Selma, INS/N 15839 N88383Harden David A · Brookfield, OHBuilt 1946 · S/N 16001 N88548Newburg Dale E · Rhome, TXBuilt 1946 · S/N 16173 N88587Tucker Anthony W · Brazoria, TXBuilt 1946 · S/N 16213 N88599Trumbull Thomas A Trustee · Leland, MIBuilt 1943 · S/N 16225 N92273Gates Steven S · Midlothian, TXBuilt 1946 · S/N 16734 N98002Dusin Tom L · Cypress, TXBuilt 1946 · S/N 18132 N98035Lefevre James N · Florence, WIBuilt 1946 · S/N 18182 N98090Williams Richard Edwin · Seaford, DES/N 18244 N98216Komara Aaron · Fayetteville, TNBuilt 1946 · S/N 18379 N9822NNorsic Michael M · Parma, OHBuilt 1946 · S/N 18387 N98303Estes Jack · Memphis, TNBuilt 1946 · S/N 18462 N98390Command Aire LLC · Sitka, AKBuilt 1946 · S/N 18574 N98452Moore David T · Fayetteville, ARBuilt 1946 · S/N 18643 N98479Mays Kevin E · West Liberty, KYS/N 18680 N98565Zarinnia Jonathan C · Delavan, WIS/N 18784 N98572Cleveland Brian G · Modesto, CABuilt 1946 · S/N 18791

Back to Piper J-3