Skip to content

Registered aircraft · 606

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

N233DCMc Aviation Holdings LLC · Miami, FLBuilt 1998 · S/N 18280289 N233KSJean Buford Randall · Lorena, TXBuilt 1998 · S/N 18280145 N233MEEight Ball Flying Club · Van Nuys, CABuilt 2000 · S/N 18280750 N23407S C Skylane LLC · Cumming, GABuilt 1998 · S/N 18280409 N23480Pkp Aviation LLC · Alexandria, VABuilt 1999 · S/N 18280412 N2348SGeorgia Forestry Commission · Macon, GABuilt 1999 · S/N 18280411 N2349RSalser Aviation LLC · Ocala, FLBuilt 1998 · S/N 18280413 N2349XNorris James A · Export, PABuilt 1998 · S/N 18280414 N234MESanfilippo Joseph J · Hollywood, FLBuilt 2000 · S/N 18280751 N23521Aircraft Holdings LLC · Missoula, MTBuilt 1998 · S/N 18280418 N2352BGwyn Farms Inc · Moses Lake, WABuilt 1998 · S/N 18280416 N2352MCloud Cap Technology · Hood River, ORBuilt 1999 · S/N 18280417 N2353KGraff Lars U · Kohler, WIBuilt 1998 · S/N 18280420 N2356EHock Aviation LLC · Stuart, FLBuilt 1999 · S/N 18280423 N2356LCircle B Pipe & Supply LLC · Odessa, TXBuilt 1998 · S/N 18280425 N235HP235hp LLC · Norwood, NCBuilt 1998 · S/N 18280333 N235MERegistered aircraftBuilt 2000 · S/N 18280753 N2362CCelek Brian F · Charleston, SCBuilt 1999 · S/N 18280474 N2362JBauer Bryce · Forestville, CABuilt 1999 · S/N 18280475 N2363S182 Skylane LLC · Loxahatchee, FLS/N 18280478 N23655Redline Aviation LLC · Wilmington, DEBuilt 1998 · S/N 18280378 N2365NDulles Aviation · Bristow, VABuilt 1998 · S/N 18280373 N2366GDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 18280379 N2366MWestbank Fishing LLC · Kiln, MSBuilt 1999 · S/N 18280447 N2366NKohnen Patrick Kennedy · Flagstaff, AZS/N 18280382 N2366YAvco Patrol LLC · Lyndon, KSBuilt 1999 · S/N 18280539 N23676A&E Flying Club Of Los Angeles Inc · Hawthorne, CABuilt 1998 · S/N 18280324 N23677Doering Jim · Arcadia, CABuilt 1998 · S/N 18280389 N2367MPeterson Aviation LLC · Oregon, WIBuilt 1998 · S/N 18280386 N2367X182 Jkp LLC · Fall River, MABuilt 1998 · S/N 18280252 N2368GRegistered aircraftBuilt 1999 · S/N 18280541 N2368SShane LLC · Wilmington, DEBuilt 1999 · S/N 18280390 N2369KMgm Aviation LLC · Montara, CABuilt 1998 · S/N 18280394 N2370EPowers Thomas Jr · Westerly, RIS/N 18280540 N2370WSall LLC · Mill Valley, CABuilt 1998 · S/N 18280405 N23735Leighton Farms Ltd · Griswold, IABuilt 1999 · S/N 18280458 N23756Sweet Fred A · Loves Park, ILBuilt 1998 · S/N 18280429 N2375JBarr Air Patrol LLC · Mesquite, TXBuilt 1999 · S/N 18280451 N2376RRegistered aircraftBuilt 1999 · S/N 18280431 N2376VPeyrot Eric M · Summerland Key, FLBuilt 1998 · S/N 18280432 N2376XMueller Howard W · Winston Salem, NCBuilt 1999 · S/N 18280433 N2377PLammers William Scott · Deer Park, ILBuilt 1998 · S/N 18280434 N2377YTerral William C · Farmerville, LABuilt 1998 · S/N 18280436 N23782Zylstra Cycle Co Inc · Ames, IAFirst renewal noticeBuilt 1999 · S/N 18280448 N237AJSuo Anttila Ahti · Albuquerque, NMBuilt 2000 · S/N 18280794 N237MEWestbank Fishing LLC · Kiln, MSBuilt 2000 · S/N 18280756 N23807Crone Patrick · Reston, VABuilt 1999 · S/N 18280468 N2380CH & M Aviation LLC · Calhoun, GABuilt 1999 · S/N 18280462 N2380YAlbert Jeffrey Frederick · Biltmore Lake, NCBuilt 1999 · S/N 18280465 N23816Malloy Dennis John · Mesquite, NVBuilt 1999 · S/N 18280470

Back to Cessna 182S