Skip to content

Registered aircraft · 303

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

N3011JGonzalez Jose E · Arecibo, PRBuilt 1965 · S/N 15061111 N3012JTubens Robert Neal · Benton City, WABuilt 1965 · S/N 15061112 N3014JDodd Ethen D · Jack, ALBuilt 1965 · S/N 15061114 N3015JWest Aviation LLC · Astoria, ORBuilt 1965 · S/N 15061115 N3017JColeman John C · Mc Alpin, FLBuilt 1965 · S/N 15061117 N3018JHargraves Richard N · Clarksville, ARS/N 15061118 N3019JRhinelander Flying Service Inc · Rhinelander, WIBuilt 1965 · S/N 15061119 N3021JDuffy William B · Denton, TXBuilt 1965 · S/N 15061121 N3026JRoberts James D Trustee · Omaha, NEBuilt 1965 · S/N 15061126 N3029JSorrells Brandon L · Yuma, AZBuilt 1965 · S/N 15061129 N3037JMello Ben · Bainbridge Island, WAS/N 15061137 N3038JPauls Flying Service LLC · Dundee, MSBuilt 1965 · S/N 15061138 N3040JCrabtree Steven B · Canyon, TXBuilt 1965 · S/N 15061140 N3042JHutchison Robert T · Big Lake, AKBuilt 1965 · S/N 15061142 N3046JDyer David A · White Hills, AZBuilt 1965 · S/N 15061146 N3048JBrown Theodore L Jr · Fort Worth, TXBuilt 1965 · S/N 15061148 N3049JRound Engine Aero · Nashville, MIBuilt 1965 · S/N 15061149 N3056JRegistration Pending · Jackson, MIRegistration pendingBuilt 1965 · S/N 15061156 N3057JGaines Von J · Hendersonville, TNBuilt 1965 · S/N 15061157 N3063JGo Around LLC · Boyceville, WIBuilt 1965 · S/N 15061163 N3066JWeyer Terry J · Edgewater, FLBuilt 1965 · S/N 15061166 N3068JWave Soaring Adventures Inc · Lake Tapps, WABuilt 1965 · S/N 15061168 N3069JBergman Owen E · Monmouth, ORBuilt 1965 · S/N 15061169 N3070JCascade Soaring Society · East Wenatchee, WABuilt 1965 · S/N 15061170 N3071JHaas James D · Frisco, TXBuilt 1965 · S/N 15061171 N3072JNavanugraha Piya · Hemet, CABuilt 1965 · S/N 15061172 N3073JFilter Keith F Jr · Lake Havasu City, AZBuilt 1965 · S/N 15061173 N3076JMortgage Experts LLC · Homestead, FLBuilt 1965 · S/N 15061176 N3079JAdvantage Aviation Services LLC · South Saint Paul, MNBuilt 1965 · S/N 15061179 N3080JShafovaloff Thomas E · Scottsboro, ALBuilt 1965 · S/N 15061180 N3082JLandrum Craig · Vinita, OKS/N 15061182 N3084JDorn Caleb · Bossier City, LABuilt 1965 · S/N 15061184 N3088JKelsey James R · La Plata, MOBuilt 1965 · S/N 15061188 N3091JThrom Donald R · Parachute, COS/N 15061191 N3096JAero Foundation Inc · Ventura, CABuilt 1965 · S/N 15061196 N3097JFlat Lake Air LLC · Eagle River, AKBuilt 1965 · S/N 15061197 N3098JDorman David L · Garfield, MNS/N 15061198 N3099JRegistered aircraftSale reported, pending cancellationBuilt 1965 · S/N 15061199 N31EREmbry Riddle Aeronautical Univ Inc · Prescott, AZBuilt 1964 · S/N 15061072 N3500JCattaraugus Flying Club Inc · West Seneca, NYBuilt 1965 · S/N 15061200 N3503JBusiness As Usual LLC · Spartanburg, SCBuilt 1965 · S/N 15061203 N3507JLorentzen David P · Montrose, COS/N 15061207 N3510JThiel Arleta J · Independence, ORBuilt 1965 · S/N 15061210 N3511JMott William R · Beach Lake, PABuilt 1965 · S/N 15061211 N3516JMitchell Clarence E · Las Cruces, NMBuilt 1965 · S/N 15061216 N3520JHart Robert J · Clarksville, MDBuilt 1965 · S/N 15061220 N3521JGoldbeck Kenneth J · Moreland, GABuilt 1965 · S/N 15061221 N3522JMontgomery Robert L · Port Angeles, WABuilt 1965 · S/N 15061222 N3524JRobinson Jimmy T · Cohutta, GABuilt 1965 · S/N 15061224 N3527JBurth Michael A · Verona, NYBuilt 1965 · S/N 15061227

Back to Cessna 150E