Skip to content

Registered aircraft · 706

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

N2263TUnited States Air Force · Dover Afb, DEBuilt 1977 · S/N R18200014 N2268SPlatinum Air Services LLC · Morgantown, WVS/N R18201317 N2280TRegistered aircraftBuilt 1977 · S/N R18200016 N2281TAvpac Insurance Services Inc · Santa Ana, CABuilt 1977 · S/N R18200017 N2284TKenley Clay · Crockett, TXBuilt 1977 · S/N R18200019 N2285SPlonk Daniel W · Chiefland, FLFirst renewal noticeS/N R18201324 N228HPLance Reid Enterprises LLC · Turlock, CABuilt 1980 · S/N R18201643 N2296TRegistered aircraftS/N R18200021 N2298TT C Rocket LLC · Traverse City, MIBuilt 1977 · S/N R18200023 N2333CAfs Inc · Grants Pass, ORBuilt 1978 · S/N R18200152 N2334CTallahassee Flying Club Inc · Tallahassee, FLBuilt 1978 · S/N R18200153 N233MGFly Safe LLC · Belle Isle, FLBuilt 1980 · S/N R18201541 N2340CWilliam J Davis · Bismarck, NDS/N R18200155 N234RCRonnie G Crider Pa · Clearwater, FLBuilt 1985 · S/N R18202012 N235AZSchlenker David D · Marine St Crx, MNBuilt 1980 · S/N R18201658 N2365CStrolin LLC · Maple Valley, WABuilt 1978 · S/N R18200162 N236AGTroposphere Ventures LLC · Fond Du Lac, WIBuilt 1978 · S/N R18200788 N236RCCarter Rodney D · Artesia, NMBuilt 1983 · S/N R18201963 N2372CMartin Land Improvement Inc · Elk Rapids, MIBuilt 1978 · S/N R18200164 N2373CDs Flight Services LLC · Battle Ground, WABuilt 1978 · S/N R18200165 N2374CJackson Jeffrey D · Elk City, OKBuilt 1978 · S/N R18200166 N2375CEverwind Aviation LLC · Kalispell, MTBuilt 1978 · S/N R18200167 N2379CWest Country Aviation Inc Trustee · Wilmington, DEBuilt 1978 · S/N R18200170 N2385CSt Charles Flying Service Inc · Portage Des Sioux, MOBuilt 1978 · S/N R18200172 N2386CSuiter Thomas D · Earl Park, INBuilt 1978 · S/N R18200173 N2394SSale Reported · Wild Rose, WISale reportedBuilt 1979 · S/N R18201336 N2487SMoody Bible Institute Of Chicago · Spokane Valley, WAS/N R18201344 N253ERFreeman Joshua A · Platteville, COBuilt 1978 · S/N R18200723 N2557SAgri-Flight LLC · Waterford, MIS/N R18201349 N255WFKlapmeier Alan L · Iron River, WIBuilt 1981 · S/N R18201655 N256SAAirview Inc · Ligonier, PABuilt 1983 · S/N R18201967 N2623CDodson International Parts Inc · Rantoul, KSBuilt 1978 · S/N R18200179 N2627CC And T Aviation LLC · Shreveport, LABuilt 1978 · S/N R18200180 N262ALDale County Sheriffs Office · Ozark, ALBuilt 1981 · S/N R18201836 N2631CAndrews John M · Titusville, FLBuilt 1978 · S/N R18200183 N2632CSheldon Benjamin Lloyd · Duck Creek Village, UTBuilt 1978 · S/N R18200184 N2633CWalusz Bernice J · Linden, NJS/N R18200185 N2635CMason Gregory J · Rice Lake, WIBuilt 1978 · S/N R18200186 N2636CSexton David Lee · Barnesville, GABuilt 1978 · S/N R18200187 N2637CSafety In Motion Flight Center Inc · Puyallup, WABuilt 1978 · S/N R18200188 N2639CClear And Seven LLC · Santa Teresa, NMBuilt 1978 · S/N R18200189 N2656CHgta Partners LLC · Grand Rapids, MIBuilt 1978 · S/N R18200196 N2658CMay Jeffrey P · Seligman, AZBuilt 1978 · S/N R18200198 N2665CWindsock Skies LLC · Caldwell, TXBuilt 1978 · S/N R18200201 N2683CGrigg Charles G · Pasco, WABuilt 1978 · S/N R18200211 N268JCShaw Melvin · Annapolis, MDBuilt 1978 · S/N R18200213 N2690CEdwards Zachary · Sylmar, CABuilt 1978 · S/N R18200214 N2692CStewart Chalmous · New London, NCS/N R18200215 N2696CUnited States Air Force · Peterson Afb, COBuilt 1978 · S/N R18200218 N269PBHmw LLC · La Grange, NCBuilt 1978 · S/N R18200546

Back to Cessna R182