Skip to content

Registered aircraft · 1,805

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

N8184BPalouse Aviation Holdings LLC · Moscow, IDBuilt 1957 · S/N 29984 N8186BMid-Atlantic Aircraft Leasing LLC · Wilmington, DEBuilt 1957 · S/N 29986 N8187BWithers Hurchel W · Stone Mountain, GABuilt 1957 · S/N 29987 N8192BAll Sports Aviation LLC · Sandpoint, IDBuilt 1957 · S/N 29992 N8194BRegistration Pending · Gold Hill, ORRegistration pendingS/N 29994 N8197BDaughtrey Kevin E · Arcadia, FLBuilt 1957 · S/N 29997 N8199BVitek August J · Granger, TXBuilt 1957 · S/N 29999 N8205BHarrison Joseph T · Pensacola Beach, FLBuilt 1957 · S/N 36005 N8208BWidincamp Steve F · Dahlonega, GABuilt 1957 · S/N 36008 N8210BGibson-Craig-Carmichael Anita Yvonne · Blacksburg, VABuilt 1957 · S/N 36010 N8211BHayfield Technical Services LLC · Tahlequah, OKS/N 36011 N8212BSeven Delta Whiskey Club · Brush Prairie, WABuilt 1957 · S/N 36012 N8216BBrezina Chad M · Whitewright, TXBuilt 1957 · S/N 36016 N8217BRoll George N · Freeport, FLBuilt 1957 · S/N 36017 N8219VGreenman Lisa J · Chesterton, INBuilt 1956 · S/N 29884 N8220BTurner Travis Joseph · Chetek, WIS/N 36020 N8221BMayberry Jonathan J · Lake Stevens, WABuilt 1957 · S/N 36021 N8225BConner Mark Wes · Thomasville, NCBuilt 1957 · S/N 36025 N8226BPerez Emanuel A · Calistoga, CABuilt 1957 · S/N 36026 N8227BSegovia Nicholas A · Mooresville, NCBuilt 1957 · S/N 36027 N8229BPittman Rex A · Haskell, TXBuilt 1957 · S/N 36029 N8230BGrieff Jorden A · Rome, GAS/N 36030 N8231BRegistration Pending · Wilmington, DERegistration pendingBuilt 1957 · S/N 36031 N8234BCook Christopher L · Mt Juliet, TNBuilt 1957 · S/N 36034 N8241BBalint Jozef · Fort Worth, TXBuilt 1956 · S/N 36041 N8242BLibby Robert E · Windham, MEBuilt 1957 · S/N 36042 N8246BBoyer Christopher · Bozeman, MTBuilt 1957 · S/N 36046 N8247BDoughty Robert W · Casa Grande, AZBuilt 1957 · S/N 36047 N8250BMortenson Daniel R Trustee · Newhall, CABuilt 1957 · S/N 36050 N8256BHanes Ronald J · Bowling Green, KYBuilt 1957 · S/N 36056 N8258BConway Michael J · Vero Beach, FLBuilt 1957 · S/N 36058 N8260BMatyas Joseph J Jr · Drums, PABuilt 1957 · S/N 36060 N8261BDarbro Joel K · Elk City, KSBuilt 1957 · S/N 36061 N8263BWalton Josh A · Copan, OKBuilt 1957 · S/N 36063 N8264BMcclure Jason L · Hutchinson, KSBuilt 1957 · S/N 36064 N8266BHickson Benjamin J · Melbourne, FLS/N 36066 N8273BBlue Ribbon Aviation LLC · Oakland, MDS/N 36073 N8275BVixie James G · Milton Freewater, ORBuilt 1957 · S/N 36075 N8276BHermens Stanley G · Wallowa, ORS/N 36076 N8277BRyder Clifford J · Massapequa, NYBuilt 1957 · S/N 36077 N8280BSea Coast Aviation LLC · Conway, SCBuilt 1957 · S/N 36080 N8282BAmyx Hiram R · Liberty, TXBuilt 1957 · S/N 36082 N8289BGodfrey Brian T · Waupaca, WIBuilt 1957 · S/N 36089 N8290BSchooman Clarence G · Marion, TXBuilt 1957 · S/N 36090 N8292BEagle Eye Aerial Imaging LLC · Chagrin Falls, OHS/N 36092 N8295BSkywriters Inc · Ferndale, WABuilt 1957 · S/N 36095 N8297BSchler Joseph B · Reno, NVBuilt 1957 · S/N 36097 N8299BJohnston Keith G · Honolulu, HIBuilt 1951 · S/N 36099 N8300BMonger Kenneth R · Bella Vista, ARBuilt 1957 · S/N 36100 N8303BBack Jason M · Poolville, TXBuilt 1957 · S/N 36103

Back to Cessna 172