Skip to content

Registered aircraft · 103

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

N107YYBeezhold Terence J · Lake Stevens, WABuilt 1956 · S/N 35266 N11220Southern Arkansas University Tech · Camden, ARBuilt 1957 · S/N 38037 N112HRFlexer Howard · Monterey Park, CAS/N 35217 N115CKSchmick Kenneth R · Fond Du Lac, WIS/N 35281 N116BGGood Bill T · Temecula, CABuilt 1955 · S/N 35116 N153RJones Jeremy R · Lampasas, TXS/N 35020 N191RAnderson Harold E · Phoenix, AZBuilt 1955 · S/N 35229 N1956Sturges George S Jr · Bakersfield, CABuilt 1956 · S/N 35337 N196RLunsford Joel T · Jasper, TXBuilt 1955 · S/N 35049 N200LEAeromarine Holdings LLC · Waukesha, WIBuilt 1979 · S/N 310R1842 N215AMurphy Dan A · Two Harbors, MNBuilt 1954 · S/N 35013 N223HWatson James E Jr · Victor, COBuilt 1956 · S/N 35385 N2277FEagle Mission LLC · Keystone Heights, FLBuilt 1956 · S/N 35352 N237DWTheis Industrial Leasing Inc · Spivey, KSS/N 35506 N255AOld Aircraft Inc · Lake City, FLBuilt 1956 · S/N 35285 N2602CRrb Aviation LLC · Jasper, TXBuilt 1954 · S/N 35002 N2610CNelson Scott J · Saline, MIBuilt 1954 · S/N 35010 N261REPeterson Randy J · Sonoma, CAS/N 35284 N2638CPickett Joseph C · El Paso, TXBuilt 1955 · S/N 35038 N2642CMuniz Elmer · Port Saint Lucie, FLS/N 35042 N2655CSmith Lionel J · Ironton, MOBuilt 1955 · S/N 35055 N2671CHouchen Chris F · Palmer, AKBuilt 1955 · S/N 35071 N2672CClipper Sky LLC · Las Vegas, NVS/N 35072 N2674CTri County Sprayers Inc · Hamlin, TXBuilt 1955 · S/N 35074 N2689CColvin Clu DBA · Big Cabin, OKS/N 35089 N2695CNovak Peter A · Barrington, ILBuilt 1955 · S/N 35095 N3003DRoach James M · West Bountiful, UTBuilt 1955 · S/N 35203 N3006DWarmkesserl James R · Felton, CABuilt 1955 · S/N 35206 N3020DAllen Gregory L · Lake View, ALBuilt 1955 · S/N 35220 N3025DBanducci Debra L Trustee · Bakersfield, CABuilt 1955 · S/N 35225 N3061DJeppson Edward Mckay Trustee · South Jordan, UTBuilt 1956 · S/N 35261 N3063DCase William M · Klamath Falls, ORBuilt 1956 · S/N 35263 N3064DLebron R Luke · Gulfport, MSS/N 35264 N3069DSmith Gregory E · White Lake, MIBuilt 1956 · S/N 35269 N3091DBella Farms Inc · Hayes Center, NEBuilt 1956 · S/N 35291 N3094DAberdeen Pilots LLC · Boerne, TXBuilt 1956 · S/N 35294 N3095DIrvine William G · Rosamond, CABuilt 1956 · S/N 35295 N310EBWeatherproof Montana LLC · Missoula, MTBuilt 1956 · S/N 35446 N310JTCowan David E · Mount Pleasant, SCBuilt 1956 · S/N 35486 N310LEJones Kent D · St George, UTS/N 35425 N310MMSuhay Richard Trustee · Redlands, CABuilt 1955 · S/N 35213 N310NWatkins Bob H · Huntington Beach, CABuilt 1955 · S/N 35121 N310SGFlorida Flyers Flight Academy Inc · Saint Augustine, FLBuilt 1957 · S/N 35494 N310VRound Trip Lc · Elkhart, KSS/N 35487 N3457BChase Dennis A · Naperville, ILBuilt 1955 · S/N 35032 N353DCulver Marc D · Anchorage, AKBuilt 1956 · S/N 35353 N3607DCusick Christopher J · La Jolla, CABuilt 1956 · S/N 35307 N3616DRobinson Mark V · Vacaville, CABuilt 1956 · S/N 35316 N3618GIndustrial Consulting LLC · Repton, ALBuilt 1956 · S/N 35313 N3631DMortgage Experts LLC · Homestead, FLBuilt 1956 · S/N 35331

Back to Cessna 310