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.

N888TTRegistered aircraftBuilt 1956 · S/N 32553 N898SWHealy Ronald L · Anchorage, AKBuilt 1955 · S/N 32112 N9002CDutcher Arthur B · Redwood City, CABuilt 1954 · S/N 31050 N9005CAirxl Inc · Billings, MTBuilt 1954 · S/N 31053 N9006CMillionista Investment Hub LLC · Boca Raton, FLS/N 31054 N9008CFogleman Brian L · Stonewall, LABuilt 1954 · S/N 31056 N9009CKyer Barry Patrick · Honey Grove, TXBuilt 1954 · S/N 31057 N9012CClark Gloria L Trustee · Gillette, WYBuilt 1954 · S/N 31060 N9013CMarch David H · Lincoln, CABuilt 1954 · S/N 31061 N9016CLindblom Carl O · Saxon, WIBuilt 1954 · S/N 31064 N9019CHanks Don N · Eagle River, AKBuilt 1954 · S/N 31067 N9022CBarber Theodore C Trustee · Spanish Fork, UTBuilt 1954 · S/N 31070 N9023CAinsworth Warren B · Vestavia Hills, ALBuilt 1954 · S/N 31071 N9024CBaker Lewis E Jr Trustee · Anchorage, AKBuilt 1954 · S/N 31072 N9028CEvans Johnny D I · Wasilla, AKBuilt 1954 · S/N 31076 N9033CPrice Tom Jr · Baker City, ORBuilt 1954 · S/N 31081 N9034CGrizzly Air Service Inc · Paris, TXBuilt 1954 · S/N 31082 N9038CMackay Scott · Spokane Valley, WABuilt 1954 · S/N 31086 N9043CHemphill Holdings LLC · Hemphill, TXBuilt 1954 · S/N 31091 N9046CSherwood David R · Porterville, CABuilt 1955 · S/N 31094 N9049CLanese Matthew N · New Milford, CTBuilt 1954 · S/N 31097 N9062MKissee Dale D Trustee · Chugiak, AKBuilt 1970 · S/N 18052162 N9064ZCarranza Matthew J · Casa Grande, AZBuilt 1956 · S/N 32275 N907FMiller Jonathan L · Anchorage, AKS/N 30647 N9104CPerkins Randy S · Great Falls, MTBuilt 1954 · S/N 31203 N9115THigginbothan Stewart C · Woodbine, GABuilt 1959 · S/N 50615 N9120CFrison Joseph · Milton, WIBuilt 1954 · S/N 31219 N9121CBowser Justin · Colorado Springs, COBuilt 1954 · S/N 31220 N9122CJohnson Joseph S · Eagle River, AKS/N 31221 N9124BRegenold John A · Saint Paul, MNS/N 30670 N9125CHafen Aviation Group LLC · Pasadena, CABuilt 1954 · S/N 31224 N9125TEisberg Keith W · Eagle Creek, ORS/N 32597 N9127CAllen Kevin L · Midland, TXS/N 31226 N9132CKantorowicz Jon C · Great Falls, MTBuilt 1954 · S/N 31231 N9133CPowers Gene Carroll · Kennedale, TXBuilt 1954 · S/N 31232 N9135CLowlo LLC · Salt Lake City, UTBuilt 1954 · S/N 31234 N9136CLanier Scott R · Fairbanks, AKBuilt 1954 · S/N 31235 N9137CKingdom Air Corp · Sutton, AKBuilt 1954 · S/N 31236 N9140RGilliland Allen N · King Salmon, AKBuilt 1960 · S/N 30207 N9141CWeir Jimmy S · Anchorage, AKBuilt 1954 · S/N 31240 N9147CCope Eric E · Angels Camp, CABuilt 1954 · S/N 31246 N9150CAkers Joel W · Anchorage, AKBuilt 1954 · S/N 31249 N9161CLatta Michael D · Auburn, WABuilt 1954 · S/N 31260 N9169CVajdos Robert C Jr · Louise, TXBuilt 1955 · S/N 31268 N9172CBolinger Dean R · Bend, ORBuilt 1954 · S/N 31271 N9175CPaterson Gerald C · Kent, WABuilt 1955 · S/N 31274 N9176CRegistered aircraftRegistration pendingBuilt 1954 · S/N 31275 N9177CMedsger Eric A · Oxford, WIBuilt 1955 · S/N 31276 N9182CMulberry John W · Idaho Falls, IDBuilt 1955 · S/N 31281 N9184CMclean Samuel A · Yelm, WABuilt 1954 · S/N 31283

Back to Cessna 180