Skip to content

Registered aircraft · 380

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

N3228YFawley John M · Wisconsin Rapids, WIBuilt 1962 · S/N 18254228 N3230YCosta Flying Service Inc · Painted Post, NYS/N 18254230 N3232YWise Frederick W · Windsor, PABuilt 1962 · S/N 18254232 N3233YShepperson Ranch Co · Midwest, WYBuilt 1962 · S/N 18254233 N3234YGrefsrud Travis · Pelican Rapids, MNBuilt 1962 · S/N 18254234 N3237YCopper Mountain Assets · Winthrop, WABuilt 1962 · S/N 18254237 N3239YHarper Mark A · Winston Salem, NCBuilt 1962 · S/N 18254239 N3241YNull James A III · Live Oak, TXBuilt 1962 · S/N 18254241 N3242YShadow Air LLC · Norfork, ARS/N 18254242 N3244YCutrell William J · Mc Donald, TNBuilt 1962 · S/N 18254244 N3250YEonm182 LLC · El Paso, TXBuilt 1962 · S/N 18254250 N3251YCarlson Andrew J · Ashville, NYBuilt 1962 · S/N 18254251 N3256YCowden Mark T · Kerrville, TXBuilt 1962 · S/N 18254256 N3257YGilbert Donald L Jr · Ligonier, PABuilt 1962 · S/N 18254257 N3258YByra Paula A · Pagosa Springs, COS/N 18254258 N3259YGrantham William Edward · Doerun, GAS/N 18254259 N3260YOneal Gary · Springdale, ARBuilt 1962 · S/N 18254260 N3271YWoodbury Ivan D · Bowling Green, OHBuilt 1962 · S/N 18254271 N3272YOlsen Chris M · Othello, WAS/N 18254272 N3277YLapinsky Richard G · Los Lunas, NMBuilt 1962 · S/N 18254277 N3284YMonnin Cass C · East Wenatchee, WAS/N 18254284 N3289YHasselbring Ted S · Nashville, TNBuilt 1962 · S/N 18254289 N3293YKiedinger John D · Burleson, TXS/N 18254293 N3295YReid Brian M · Boise, IDS/N 18254295 N3296YBeckord Aaron P · Tacoma, WABuilt 1962 · S/N 18254296 N3297YMust Dash Rides Flying Club LLC · Raleigh, NCBuilt 1962 · S/N 18254297 N3300YRaulston Electric LLC · Bagwell, TXBuilt 1962 · S/N 18254300 N3302YFoster James R · Mcpherson, KSBuilt 1962 · S/N 18254302 N3303YWoolery David W Jr DBA · Lathrop, MOBuilt 1962 · S/N 18254303 N3305YWolfe Randall S · Wasilla, AKBuilt 1962 · S/N 18254305 N3306YSaunders Craig · Spring Hill, FLBuilt 1962 · S/N 18254306 N3309YRuschak Donald A · Charleroi, PABuilt 1962 · S/N 18254309 N3310YRegistration Pending · Fayetteville, ARRegistration pendingS/N 18254310 N3311YChavez Rafael J · Santa Fe, NMBuilt 1962 · S/N 18254311 N3313YCosta Flying Service Inc · Painted Post, NYS/N 18254313 N3314YSimas Filomeno M · Grover Beach, CABuilt 1962 · S/N 18254314 N3322YFostair Inc · Ovid, NYS/N 18254322 N3323YMiellerie LLC · Bridgeport, TXBuilt 1962 · S/N 18254323 N3324YVoge Michael · Chino Hills, CABuilt 1962 · S/N 18254324 N332JRAdair Lawrence L Jr · Fountain Run, KYBuilt 1961 · S/N 18253722 N3330YTighe Joseph E · Kingsland, TXBuilt 1962 · S/N 18254330 N3333YDeville Charles D · Clinton, LABuilt 1962 · S/N 18254333 N3334YHarless Richard K · Battle Mountain, NVBuilt 1962 · S/N 18254334 N3340YMckinney Sandra C · Williamsburg, OHBuilt 1962 · S/N 18254340 N3346YVantrease Jerold L · Homer, AKBuilt 1962 · S/N 18254346 N3347YMccoy Mark B · Honea Path, SCBuilt 1962 · S/N 18254347 N3348YBlue Sky Flyers Inc · Punta Gorda, FLBuilt 1962 · S/N 18254348 N3354YFelkins Roger C · Hillsboro, ALBuilt 1962 · S/N 18254354 N3360YFoote Jerry O · Unadilla, NYBuilt 1962 · S/N 18254360 N3364YSpeth Peter P · Peru, INBuilt 1962 · S/N 18254364

Back to Cessna 182E