Skip to content

Registered aircraft · 455

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

N1956LMeisinger Darrell G · Claremore, OKBuilt 1976 · S/N M-1816 N1958LTalamini Paul J · Franklin, MABuilt 1976 · S/N M-1840 N1962LDelacantera Eduardo · New Castle, DEBuilt 1976 · S/N M-1838 N1983LJeffries Susan M · Clover, SCBuilt 1976 · S/N M-1841 N1986LPhillips Alan K · Junction City, ORBuilt 1976 · S/N M-1843 N1988LPortal Planes LLC · Knoxville, TNS/N M-1842 N1989LTriple D LLC · Scotland, PAS/N M-1847 N1998LAyala Gerardo · San Antonio, TXBuilt 1976 · S/N M-1854 N2008TDean John W · Greentown, INBuilt 1978 · S/N M-2061 N2009DSundowner 2009d LLC · La Place, LABuilt 1978 · S/N M-2053 N200RFRushin William J · Greenwood, INBuilt 1973 · S/N M-1457 N2010AMaine Instrument Flight · Augusta, MEBuilt 1978 · S/N M-2066 N2010LTec Consulting LLC · Farmingdale, MEBuilt 1978 · S/N M-2058 N20120Bennett Robert J Jr · Minneapolis, MNBuilt 1978 · S/N M-2071 N2012NAirhawks Flying Clup · Eastsound, WABuilt 1978 · S/N M-2068 N2013NSimply Living LLC · Fort Myers, FLBuilt 1978 · S/N M-2070 N2041LSlik Air LLC · Topeka, KSBuilt 1976 · S/N M-1849 N2043LBrown Dennis · Moncks Corner, SCBuilt 1976 · S/N M-1856 N2048LDp Network LLC · Coconut Creek, FLBuilt 1976 · S/N M-1857 N204PWFreeman Adam J · Long Beach, CABuilt 1976 · S/N M-1844 N2050LMolak Marc E · Austin, TXBuilt 1976 · S/N M-1859 N2054LDillon Roby · Rockport, INBuilt 1976 · S/N M-1860 N2057LWilson Michael Joseph · Los Banos, CABuilt 1976 · S/N M-1861 N2062LJohnson Robert A · Crawfordville, FLBuilt 1976 · S/N M-1863 N2067LShort Final Aviation LLC · Siloam Springs, ARBuilt 1976 · S/N M-1866 N2071BTrulson Gary S · Edgerton, WIBuilt 1978 · S/N M-2099 N20748Registration Pending · Bethesda, MDRegistration pendingBuilt 1978 · S/N M-2077 N2075LThompson Talley · Burgaw, NCS/N M-2081 N2076AThomas George P Jr · Woodstock, VTBuilt 1978 · S/N M-2054 N2077AN2077a LLC · Lewes, DEBuilt 1978 · S/N M-2082 N2077CBudarf James Philip · Graham, TXBuilt 1978 · S/N M-2074 N2101WUtset Anthony · Okeechobee, FLBuilt 1973 · S/N M-1471 N2103WGoold Michael D · Fort Worth, TXBuilt 1973 · S/N M-1450 N2104WMorgan Austin T · Henderson, NVBuilt 1973 · S/N M-1444 N2105WNenow William R · Tulare, CABuilt 1973 · S/N M-1433 N2106WGemma Aviation LLC · Duncan, SCBuilt 1973 · S/N M-1474 N2107WIguana Aviation LLC · Chicago, ILBuilt 1973 · S/N M-1437 N2113WMarschke Corey A · Stevens Point, WIBuilt 1973 · S/N M-1441 N2114WHippensteel Michael J · Newville, PABuilt 1973 · S/N M1449 N2118WWegner John B · Preston, MDBuilt 1973 · S/N M-1491 N2121WSambell Warren D · Arlington, TXBuilt 1973 · S/N M1493 N2122WRegistration Pending · Ubly, MIRegistration pending, pending cancellationS/N M-1495 N2123WSimmons Aeronautical LLC · Springfield, MOBuilt 1973 · S/N M-1496 N2124WSerra Joseph I · Inverness, FLBuilt 1973 · S/N M-1497 N2125WWittmer Daniel J · Tucson, AZBuilt 1973 · S/N M-1499 N2126WFormanek Carl F · Glen Flora, WIBuilt 1974 · S/N M-1502 N2128WDelgado David A · Fallbrook, CABuilt 1973 · S/N M-1504 N2129WDuknic Derek · Magnolia, TXBuilt 1973 · S/N M-1500 N2130WUnusual Attitudes Flying Club Inc · Mount Vernon, MOBuilt 1974 · S/N M-1505 N2131WRussek Rick · Cave Creek, AZBuilt 1974 · S/N M-1506

Back to Beech C23