Skip to content

Registered aircraft · 230

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 ('2073333', '207333A')
  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 ('2073333', '207333A')
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.

N764Usda Forest Servic Fepp · Columbia, SCBuilt 1975 · S/N U20602672 N7711DCaldwell Joel A · Kenai, AKBuilt 1976 · S/N U206-03170 N77554U S Department Of The Interior · Boise, IDBuilt 1976 · S/N U20603408 N77CRVolatile Aero Ventures LLC · Boulder City, NVBuilt 1976 · S/N U20603458 N805AJMoyer Aviation Inc · Ulysses, KSS/N 20601769 N8123Q8123q LLC · Olympia, WABuilt 1975 · S/N U20603093 N812WJjc Enterprises Inc · Dillingham, AKBuilt 1975 · S/N U20602770 N8146QOak Gulch LLC · Killdeer, NDBuilt 1975 · S/N U20603097 N8167QCedar Pine Construction Inc · Sturgis, SDBuilt 1975 · S/N U20603099 N8253QTogo Aviation Services LLC · Palmer, AKBuilt 1976 · S/N U20603249 N8255QKavik Aviation Services LLC · Palmer, AKBuilt 1975 · S/N U20603116 N8256QRegistered aircraftBuilt 1975 · S/N U20603117 N82687Boniek Martin J · Mccarthy, AKS/N U20603424 N8273QHelmericks Isaac J · Palmer, AKBuilt 1976 · S/N U20603134 N8281Q9 North LLC · Parker, COBuilt 1976 · S/N U20603142 N8287QAdventist World Aviation · Wilson, NCBuilt 1976 · S/N U20603148 N82LWMuskox Ministries · Fairbanks, AKBuilt 1973 · S/N U20602054 N8300QSafeco Leasing LLC · Port Alsworth, AKBuilt 1976 · S/N U20603161 N831PRThomas Bruce A · Mount Juliet, TNS/N U20603452 N8334QVolatile Aero Ventures LLC · Boulder City, NVS/N U20603195 N8340QFly8ma LLC · Big Lake, AKS/N U20603201 N8345QKatahdin Air Service Inc · Hermon, MEBuilt 1976 · S/N U20603206 N8355QDelta Pacific Northwest LLC · Anchorage, AKS/N U20603216 N8366QBesse Richard L · Wasilla, AKBuilt 1976 · S/N U20603227 N8368QBrown Christopher · Grass Valley, CABuilt 1976 · S/N U20603229 N8370QState Of Alaska Dept Of Fish And Game · Palmer, AKBuilt 1976 · S/N U20603231 N8374Q8374q LLC · Gig Harbor, WABuilt 1976 · S/N U20603235 N8378QAeroworks Of Alaska LLC · Chugiak, AKBuilt 1976 · S/N U20603239 N8386QLe Tourneau University · Longview, TXBuilt 1976 · S/N U20603247 N8394QPacific Union College · Angwin, CABuilt 1976 · S/N U20603255 N8397QSeattle Seaplanes LLC · Seattle, WABuilt 1976 · S/N U20603258 N8405QVan Pelt Matthew · Challis, IDBuilt 1976 · S/N U20603265 N841RQMueller Steven L · Osceola, WIBuilt 1976 · S/N U20603273 N8442QFerguson John W · Edwardsburg, MIBuilt 1976 · S/N U20603301 N8451QRunway Three Aviation LLC · Kalispell, MTBuilt 1976 · S/N U20603309 N8471QIgiugig Lodge LLC · Wasilla, AKBuilt 1976 · S/N U20603329 N8477QShoshone Aviation Services LLC · Missoula, MTBuilt 1976 · S/N U20603335 N8491QDry Bay Holdings LLC · Yakutat, AKBuilt 1976 · S/N U20603349 N8496QWord Forrest R Trustee · New Braunfels, TXBuilt 1976 · S/N U20603354 N8514QAvila Robert A · Lawrence, MABuilt 1976 · S/N U20603371 N8560QLunati Ralph · Mc Alpin, FLBuilt 1976 · S/N U20603416 N8564QEnvii Aviation LLC · Monroe, WABuilt 1976 · S/N U20603420 N8570QTwo O Six Inc · Fort Myers, FLBuilt 1976 · S/N U20603426 N8592QSkyview Aviation Holdings LLC · The Hills, TXBuilt 1976 · S/N U20603448 N8594QParkerson Stan L · Fairbanks, AKBuilt 1976 · S/N U20603450 N8599QForbes Paul J · Anchorage, AKBuilt 1976 · S/N U20603454 N8646QPoe Asphalt Paving Inc · Lewiston, IDBuilt 1976 · S/N U20603462 N8686QWaters & Associates Inc · Bellaire, TXS/N U20603468 N8731QHinlein Erich S · Pelham, MABuilt 1976 · S/N U20603484 N8736QCourtney Aviation LLC · Columbia, CABuilt 1976 · S/N U20603489

Back to Cessna U206F