Skip to content

Registered aircraft · 1,177

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

N1000YBarkhimer James C · Iraan, TXBuilt 1954 · S/N 30999 N1027XHarper Shawn · Bayfield, COBuilt 1954 · S/N 31205 N102CDrain Alan K · Columbus, MTS/N 30501 N1044SHubbell Wallis E · Tucson, AZS/N 52829 N106UMiha LLC · Dover, DEBuilt 1956 · S/N 32325 N108EENorthwood Services Inc · Skwentna, AKBuilt 1956 · S/N 32505 N10GCBanks Keith Allen · Salisbury, MDBuilt 1953 · S/N 30159 N10URXtiri LLC · St George, UTBuilt 1955 · S/N 32184 N111WFArnold Frank W · Senoia, GABuilt 1954 · S/N 31243 N1171TCurrier Dustan A L · Fairbanks, AKS/N 30363 N1180BAom Aircraft LLC · Wilmington, DEBuilt 1953 · S/N 30115 N1189RM9 180 LLC · Delhi, LAS/N 30698 N121FHamilton Wayne J · Mesa, AZBuilt 1956 · S/N 32353 N131ELantz Herman D · Saint Clairsville, OHBuilt 1955 · S/N 31806 N13NPEvans Randall B Trustee · Fallon, NVBuilt 1954 · S/N 31225 N1406MHeisler Jon S · Auburn, WABuilt 1954 · S/N 30851 N144JHTrachtenberg Dennis J · San Diego, CAS/N 31059 N146YBayer Peter D · Naperville, ILBuilt 1955 · S/N 32098 N1508CHutchings Alan J · Clewiston, FLBuilt 1953 · S/N 30208 N1509CHammerquist Blake T · Benicia, CABuilt 1954 · S/N 30882 N1511CBouton Vern H · Fairbanks, AKBuilt 1953 · S/N 30211 N1512CMolek Jon · Warren, OHBuilt 1953 · S/N 30212 N1513CSteffen Thomas E · Decatur, TXBuilt 1953 · S/N 30213 N1515CMountain Taildraggers LLC · Aspen, COBuilt 1953 · S/N 30215 N1516CSpotorno John Alan · Redwood City, CABuilt 1953 · S/N 30216 N1519CMinor Edward H · Gordon, NES/N 30219 N1521CMacdougall Glen H · Salisbury, MAS/N 30221 N1522CKruse Adam L · Weiser, IDBuilt 1953 · S/N 30222 N1529CBellows Paul F · Vancouver, WABuilt 1953 · S/N 30229 N1530CParker Scott E · Herald, CABuilt 1953 · S/N 30230 N1537CWbs Coatings Inc · Grand Junction, COBuilt 1953 · S/N 30237 N1545CGet Happy Adventures LLC · Leawood, KSBuilt 1953 · S/N 30245 N1546CToney William M II · Gig Harbor, WABuilt 1953 · S/N 30246 N1548CRoy Flying Service LLC · Lettsworth, LABuilt 1953 · S/N 30248 N1549CDavidson Ron · Newfolden, MNBuilt 1953 · S/N 30249 N1550CGlidden Timothy J · Millinocket, MEBuilt 1953 · S/N 30250 N1554CTaggart Brent W · Hydro, OKBuilt 1953 · S/N 30254 N1559CHardee David B · Smyrna, TNBuilt 1953 · S/N 30259 N155DD M C Aviation LLC · Jennings, LABuilt 1954 · S/N 30701 N1561CDoncat LLC · Shelby, MTS/N 30261 N1564CGeisert Carl E · Chandler, AZBuilt 1953 · S/N 30264 N1565CGarrett Carter L · Soldotna, AKS/N 30265 N156JMTrechak Ashley L · Shafter, CABuilt 1956 · S/N 32360 N1575CMeierotto Martin A · Two Rivers, AKBuilt 1953 · S/N 30275 N1577CDunn William A · Dedham, MES/N 30277 N1578CImhof Air LLC · Ferndale, WABuilt 1953 · S/N 30278 N157STogo Aviation Services LLC · Palmer, AKBuilt 1955 · S/N 31840 N1581CFitzgerald Kenneth J · Millwood, WABuilt 1953 · S/N 30281 N1584CHaakenson John R · Sterling, AKBuilt 1953 · S/N 30284 N1585CHamilton Mark W · Durango, COBuilt 1953 · S/N 30285

Back to Cessna 180