Skip to content

Registered aircraft · 423

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

N8308SThun John C · Concrete, WABuilt 1965 · S/N 18256408 N8310SBabovic Slobodan · Elm Grove, WIBuilt 1965 · S/N 18256410 N8312SSky Aviation Holdings LLC · Pompano Beach, FLBuilt 1965 · S/N 18256412 N8324SWhat Next? LLC · Fallon, NVBuilt 1965 · S/N 18256424 N8329SWhite Plane LLC · Forest Lake, MNBuilt 1965 · S/N 18256429 N8332SFlyit LLC · Camas, WABuilt 1965 · S/N 18256432 N8334SRecord John W · Apison, TNS/N 18256434 N8336SGroff Bradley Gene · Kingston, OKBuilt 1965 · S/N 18256436 N8342SSkydive Northstar LLC · Mankato, MNBuilt 1965 · S/N 18256442 N8343SMcgowan Jon G · Northfield, MABuilt 1965 · S/N 18256443 N8344SDouble Nickel Recycling LLC · Perryville, MOS/N 18256444 N8345SOlsen H Peter Jr · Fallon, NVBuilt 1965 · S/N 18256445 N8347SShaffer Dyke T · Santa Rosa, CABuilt 1965 · S/N 18256447 N8350SRegistration Pending · Wheatland, CARegistration pendingBuilt 1965 · S/N 18256450 N8352SMacwilliamson Roger · Hollister, CABuilt 1965 · S/N 18256452 N8354SNorthrop Kimberlei A · Spokane, WABuilt 1965 · S/N 18256454 N8355SFayette Hawks Flying Club Inc · Somerville, TNBuilt 1965 · S/N 18256455 N8356SHirlinger Saylor John Trustee · Stevenson Ranch, CABuilt 1965 · S/N 18256456 N8358SStewart Bryan P · Carson City, NVBuilt 1965 · S/N 18256458 N8363SHellie Andrew Bryant · College Place, WAS/N 18256463 N8368SKangas Gary J · Fairbanks, AKBuilt 1965 · S/N 18256468 N8370SBerti Robert Cord · Wilton, CABuilt 1965 · S/N 18256470 N8371SLamm Matthew S · Morristown, NJS/N 18256471 N8373SBart Bruno Paul · Monterey, CABuilt 1965 · S/N 18256473 N8375SAero Glide Corporation · Sedona, AZBuilt 1965 · S/N 18256475 N8378SGulley Ronald L · Boise, IDBuilt 1965 · S/N 18256478 N8379SAir Dakota Flite Inc · Hettinger, NDBuilt 1965 · S/N 18256479 N8382SFitzwater Richard B · Athol, IDBuilt 1965 · S/N 18256482 N8386SDavis Lawrence R · Kent, OHS/N 18256486 N8388SRose Mary R · Portland, ORBuilt 1965 · S/N 18256488 N8389SGriffith Kevin D · Lakeview, MIBuilt 1965 · S/N 18256489 N8392SCooksey Dustin J · Strasburg, COBuilt 1965 · S/N 18256492 N8393SMast Aviation LLC · Roseburg, ORBuilt 1965 · S/N 18256493 N8396SRegistration Pending · Livingston, MTRegistration pendingBuilt 1965 · S/N 18256496 N8398SRoberts Rickey J · Kamiah, IDBuilt 1965 · S/N 18256498 N8399SDenver Aviation Inc · Westminster, COS/N 18256499 N8406SSkydive Central New York LLC · Weedsport, NYBuilt 1965 · S/N 18256506 N8407SRottinghaus Charles A · Waterloo, IABuilt 1965 · S/N 18256507 N8409SKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1965 · S/N 18256509 N8412SWaldron Roger H · Santa Barbara, CABuilt 1965 · S/N 18256512 N8413SFlying Condors Inc · Templeton, CABuilt 1965 · S/N 18256513 N8416SSnow Ryan L · Hyrum, UTBuilt 1965 · S/N 18256516 N8418SSwanson Scott R · Sulphur Springs, TXBuilt 1965 · S/N 18256518 N8420SBrackett Scott S · Kingman, AZS/N 18256520 N8422SPhoenix Innovations Inc · Scappoose, ORBuilt 1965 · S/N 18256522 N8423SPatton Steven R · Wayne, OHBuilt 1965 · S/N 18256523 N8424SSkylane V LLC · Santa Rosa, CABuilt 1965 · S/N 18256524 N8425SDennehey Donald J Jr · Prior Lake, MNBuilt 1965 · S/N 18256525 N8429SComm William C · Mulino, ORBuilt 1965 · S/N 18256529 N8430SPeterson Todd · El Dorado, KSBuilt 1966 · S/N 18256530

Back to Cessna 182H