Skip to content

Registered aircraft · 784

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

N2167GBtp Inc · Missoula, MTBuilt 1958 · S/N 51467 N2170GPrince Ben · Lincoln, MTBuilt 1958 · S/N 51470 N2170PGmr Leasing LLC · Lincoln, DES/N 34152 N2173GGrizzly Air Service Inc · Paris, TXBuilt 1958 · S/N 51473 N2175GStem John T · Marlin, TXBuilt 1958 · S/N 51475 N2176GWhite Robert G · Damascus, ORBuilt 1958 · S/N 51476 N2177GSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 51477 N2179GAdonai International Ministries · Marine, ILBuilt 1958 · S/N 51479 N217CCWhite Hildery P Jr · Glendale, AZBuilt 1958 · S/N 51478 N2180GGibson John M · Tiki Island, TXBuilt 1959 · S/N 51480 N2181GJohnson Sandra L · Eagle River, AKBuilt 1958 · S/N 51481 N2182GCm Roberts LLC · Stratford, OKS/N 51482 N2183GBrinkman Jonathan D · Billings, MTS/N 51483 N2187GRegistered aircraftBuilt 1958 · S/N 51487 N2188GDisastermarks LLC · Miami, FLBuilt 1958 · S/N 51488 N2190GScapegoat Aviation LLC · Choteau, MTBuilt 1958 · S/N 51490 N2192GWood Kyle A · Soldotna, AKBuilt 1958 · S/N 51492 N2194GMeyer Wayne G · Bozeman, MTBuilt 1958 · S/N 51494 N2197GBreshears Jason N · Cameron, MOBuilt 1958 · S/N 51497 N2198GAirstar Aviation Inc · Chester, SCBuilt 1958 · S/N 51498 N2199GEmery Craig A · Wasilla, AKBuilt 1958 · S/N 51499 N2200GCarey Alan W · Fallon, NVBuilt 1958 · S/N 51500 N2203GBartek John · Glenwood Springs, COBuilt 1958 · S/N 51503 N2204GSweet Matt · Galt, CAS/N 51504 N2207GTatro Christopher A · Madras, ORBuilt 1958 · S/N 51507 N2208GAskerli Auto LLC · Kalispell, MTBuilt 1958 · S/N 51508 N2211GKoepplin Ricky G · Missoula, MTBuilt 1958 · S/N 51511 N2213GAnzion Susan K · Nerstrand, MNBuilt 1958 · S/N 51513 N2214GGanfield Roger A · Guernsey, WYBuilt 1958 · S/N 51514 N221BGroeneweg Art A · Laclede, IDBuilt 1957 · S/N 34298 N2222GCaswell Matthew N · Lubbock, TXBuilt 1958 · S/N 51522 N2223GS & M Partnership · Jasper, TXBuilt 1958 · S/N 51523 N2228GHalo Halo LLC · Milwaukie, ORS/N 51528 N2231GKelly Richard · Ogdensburg, NYS/N 51531 N2232GBigler Mark · Topeka, KSS/N 51532 N2233GA F Flyers LLC · American Falls, IDBuilt 1958 · S/N 51533 N2234GBaldwin Trevor K · Owasso, OKBuilt 1958 · S/N 51534 N2237GSmith Caleb · Beggs, OKBuilt 1958 · S/N 51537 N2239GPotter Cleve J · Fresno, CABuilt 1958 · S/N 51539 N2242GNelson Mark · Fairbanks, AKBuilt 1958 · S/N 51542 N2245GSkyair Express LLC · Overton, NVS/N 51545 N2249GDelph Timothy M · Wasilla, AKBuilt 1958 · S/N 51549 N2251GValentine Terence S · Glennallen, AKBuilt 1958 · S/N 51551 N2252GRutter Eric R · Anchorage, AKBuilt 1958 · S/N 51552 N2254GSorrels Robert S · Starkville, MSBuilt 1958 · S/N 51554 N2275KSutton Aircraft Salvage LLC · Palmer, AKS/N 51163 N22CRegistered aircraftBuilt 1958 · S/N 51007 N22DXHawk Daniel G · Cocoa, FLBuilt 1958 · S/N 51442 N2501XRoth Douglas K · Anchorage, AKBuilt 1958 · S/N 51113 N257RRegistered aircraftBuilt 1957 · S/N 34411

Back to Cessna 182A