Skip to content

Registered aircraft · 406

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

N2575GAltes Matt · Mount Shasta, CABuilt 1959 · S/N 51875 N2579GMcglachlin Brandon E · Moundridge, KSBuilt 1959 · S/N 51879 N2580GLei Puahi Inc · Klamath Falls, ORBuilt 1959 · S/N 51880 N2583GN2583g LLC · Madison, KSBuilt 1959 · S/N 51883 N2585GWilkinson Benjamin M · Anchorage, AKS/N 51885 N2589GPreisse Gene L Jr · Akron, OHBuilt 1959 · S/N 51889 N2592GLeft Heading LLC · Herriman, UTBuilt 1959 · S/N 51892 N2593GIntelinair Geospatial LLC · Indianapolis, INBuilt 1958 · S/N 51893 N2596GThomas Carlton L · Center, COBuilt 1959 · S/N 51896 N2600GBad Company Aviation LLC · Peachtree Corners, GABuilt 1959 · S/N 51900 N2602GConran Joshua · Belmont, MIBuilt 1959 · S/N 51902 N2604GBlessing Christopher B · Houston, DEBuilt 1959 · S/N 51904 N2605GInnes Stephen L · Bentonville, ARBuilt 1959 · S/N 51905 N2607GJensen Rodney · Aptos, CABuilt 1959 · S/N 51907 N2617GGandiaga Philip J · Buhl, IDBuilt 1959 · S/N 51917 N2618GEagle Mountain International Church Inc · Newark, TXBuilt 1959 · S/N 51918 N2620GBas Part Sales LLC · Greeley, COS/N 51920 N2621GAdamic David J · Cedar Hills, UTBuilt 1959 · S/N 51921 N2622GKaplan Steven M · North Monmouth, MES/N 51922 N2623GHubbard James D · Jacksonville, TXBuilt 1959 · S/N 51923 N2624GVietnam Helicopters · Concord, CABuilt 1959 · S/N 51924 N2630GMarvil Sean · El Prado, NMS/N 51930 N2631GMac Neil David M · Clarkston, WABuilt 1959 · S/N 51931 N2632GHuey James M · Fulton, MOFirst renewal noticeBuilt 1959 · S/N 51932 N2635GStockton Finance Inc · New Braunfels, TXBuilt 1959 · S/N 51935 N2636GHousken George E · Gardnerville, NVFirst renewal noticeBuilt 1959 · S/N 51936 N2637GSalisbury Jonathan T · Seabeck, WABuilt 1959 · S/N 51937 N2638GEvans Steven H · Hattiesburg, MSBuilt 1959 · S/N 51938 N2639GHusted Dean T · Hicksville, OHBuilt 1959 · S/N 51934 N263DWWarren David T · Mobile, ALBuilt 1959 · S/N 51970 N2642GWillis Andrew B · Wasilla, AKBuilt 1959 · S/N 51942 N2643GBorland Gregg A · Elkhart Lake, WIBuilt 1959 · S/N 51943 N2645GMurdoch Kyle · Burns, WYBuilt 1959 · S/N 51945 N2647GAllen Steven L · Thatcher, AZBuilt 1959 · S/N 51947 N2649GSwanson Gregory N · Meridian, IDS/N 51949 N2650GNewkirk Kevin J · Manhattan, KSS/N 51950 N2653GDevine Christopher C · Eagle River, AKBuilt 1959 · S/N 51953 N2655GBeachy Benjamin D · Whittington, ILBuilt 1959 · S/N 51955 N2658GSauer Roger A · Glenburn, NDBuilt 1959 · S/N 51958 N2659GMarmon David J · Great Falls, MTBuilt 1959 · S/N 51959 N2660GFruge Cory · Egan, LABuilt 1959 · S/N 51960 N2662GWhitman Monty · Pagosa Springs, COBuilt 1959 · S/N 51962 N2666GForward Logistics LLC · New Castle, VAFirst renewal noticeBuilt 1959 · S/N 51966 N2667GTundra Aviation Inc · Casselton, NDS/N 51967 N2668GGospel Ministries International · Mc Donald, TNBuilt 1959 · S/N 51968 N2672GPhillips Douglas S · Gloversville, NYBuilt 1959 · S/N 51972 N2673GChapman Chad · San Antonio, TXBuilt 1959 · S/N 51973 N2676GHolland Ross D · Guymon, OKBuilt 1959 · S/N 51976 N2677GPeterson Barbara A · Cheney, KSBuilt 1959 · S/N 51977 N2680GTodd Larry D · Wasilla, AKBuilt 1959 · S/N 51980

Back to Cessna 182B