Skip to content

Registered aircraft · 488

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

N3052FHofer Belik Colleen J · Sawyer, NDBuilt 1966 · S/N 18257152 N3053FBirkhold Craig Alan · Napoleon, OHBuilt 1966 · S/N 18257153 N3054FAirlaska LLC · Gustavus, AKS/N 18257154 N3061FTaber Deane W · Weirsdale, FLBuilt 1966 · S/N 18257161 N3062FJohnson Sean D Trustee · Fresno, CABuilt 1966 · S/N 18257162 N3063FT J Croach Llp · Post Falls, IDS/N 18257163 N3065FHinds Frank E · San Angelo, TXBuilt 1966 · S/N 18257165 N3068FLehrman Walter M · Reedley, CABuilt 1966 · S/N 18257168 N3069FBlaine Barry A · Campbell, CABuilt 1966 · S/N 18257169 N3071FRees Ryan G · Loa, UTS/N 18257171 N3073FLuther Arnold D · Las Vegas, NVBuilt 1966 · S/N 18257173 N3075FTurpen Kraig Aaron · Fredericksburg, TXBuilt 1966 · S/N 18257175 N3077FBlake Jason E · Shreveport, LABuilt 1966 · S/N 18257177 N3079FMackay Chadd P · Spokane Valley, WABuilt 1966 · S/N 18257179 N3081FHenion John D · Trumansburg, NYBuilt 1966 · S/N 18257181 N3082FHoffman Allen C · Anchorage, AKS/N 18257102 N3083FFree Richard D · Clearwater, KSBuilt 1966 · S/N 18257183 N3086FKellair Inc · Wilmington, DEBuilt 1966 · S/N 18257186 N3087FCascio John T · Deland, FLBuilt 1966 · S/N 18257187 N3088FDoepker James E · Kalispell, MTBuilt 1966 · S/N 18257188 N3090FAero Missions Inc · Birmingham, ALS/N 18257190 N3092FJungemann Jon D · Victor, MTBuilt 1966 · S/N 18257192 N3095FGroebner David · Red Wing, MNBuilt 1966 · S/N 18257195 N3096FMcdowell Samuel D · Clovis, CABuilt 1966 · S/N 18257196 N3100FBurger Todd Richard · Helena, MTS/N 18257200 N3102FWhitfield Timothy D · Fairfield, NCBuilt 1966 · S/N 18257202 N3104FFlorida Armstron Boring LLC · Coeur D Alene, IDBuilt 1966 · S/N 18257204 N3109FHeligray LLC · Kalispell, MTS/N 18257209 N3110FVillalobos Isaac M · Lake Havasu City, AZBuilt 1966 · S/N 18257214 N3111FShaw Construction Inc · Hillsboro, OHBuilt 1966 · S/N 18257211 N3115FTritec Air LLC · Tower, MNS/N 18257215 N3117FBrya Troy · Roscommon, MIBuilt 1966 · S/N 18257217 N3118FReining Jonathan W Trustee · Piedmont, CABuilt 1966 · S/N 18257218 N3119FAbsolute Fencing LLC · Granger, WABuilt 1966 · S/N 18257219 N3120FLengyel Roger · Santa Fe, NMBuilt 1966 · S/N 18257220 N3121FLily Chris H · Ocala, FLBuilt 1966 · S/N 18257221 N3124FTrue Aviators LLC · Kiowa, KSBuilt 1966 · S/N 18257224 N3125FHall Aircraft LLC · Kenai, AKS/N 18257225 N3127FN3127f Aviation LLC · Charlotte, NCBuilt 1966 · S/N 18257227 N3128FSwartzendruber Rodney S · Bay Port, MIBuilt 1966 · S/N 18257228 N3130FRoxy Aviation LLC · Bristol, RIBuilt 1966 · S/N 18257230 N3136FMurdock Lloyd W · Princeton, KYBuilt 1966 · S/N 18257236 N3137FJbm Endeavors LLC · Chewalah, WABuilt 1966 · S/N 18257237 N3140FWilliams Thomas G · Richland Center, WIBuilt 1966 · S/N 18257240 N3141FDoerr John · Sandy, ORBuilt 1966 · S/N 18257241 N3146FMeyer Jackson · Soldotna, AKBuilt 1966 · S/N 18257246 N3151FBentley Nicholas Klausing · Reading, PABuilt 1966 · S/N 18257251 N3152FJk Aviation LLC · Warden, WABuilt 1966 · S/N 18257252 N3155FHansen Jeremy · Burlington, COBuilt 1966 · S/N 18257255 N3158FTw Enterprises Inc · Naperville, ILBuilt 1966 · S/N 18257258

Back to Cessna 182J