Skip to content

Registered aircraft · 706

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

N270ATsg Associates LLC · Stanley, NCBuilt 1978 · S/N R18200067 N271RGCapitol City Flyers Inc · Madison, WIBuilt 1978 · S/N R18200528 N2739CLge Flying Club Inc · Marietta, GABuilt 1978 · S/N R18200223 N2744CBrewer Farms · Thompson, MOBuilt 1978 · S/N R18200224 N276CKHuckabee Charles J · Seadrift, TXBuilt 1982 · S/N R18201852 N2798CStone Aviation LLC · Sacramento, CABuilt 1978 · S/N R18200228 N27TGHarrison Mark A · Corpus Christi, TXS/N R18201065 N2804CCampbell Mark · Burleson, TXBuilt 1978 · S/N R18200229 N2817C2817c Inc · Wilmington, DEBuilt 1978 · S/N R18200231 N2827CCalifornia Equipment Leasing LLC · Marina Del Rey, CABuilt 1978 · S/N R18200233 N2833CKizer Charlene A · Albany, ORBuilt 1978 · S/N R18200234 N2834COsborne David A · San Antonio, TXBuilt 1978 · S/N R18200235 N2HUN2hu LLC · Parker, COS/N R18200447 N30FCState Alabama Forestry Commission · Florence, ALFirst renewal noticeBuilt 1982 · S/N R18201913 N311MMAndrews Karen · Napa, CABuilt 1978 · S/N R18200366 N3132CBlack Eric · Fort Jones, CABuilt 1978 · S/N R18200238 N3138CTurbo-Sphere Inc · Longmont, COBuilt 1978 · S/N R18200239 N3142RSharp Media Group LLC · Kansas City, MOS/N R18201117 N3177CRsb Properties LLC · Lewes, DEBuilt 1978 · S/N R18200248 N3183CWide Open Aviation LLC · Kennewick, WABuilt 1978 · S/N R18200251 N3192CHansen Leland K · Phoenix, AZS/N R18200255 N321QPelco Aviation Inc · Hampton Bays, NYBuilt 1978 · S/N R18200438 N3224CHassebrock John M · Colorado Springs, COBuilt 1978 · S/N R18200257 N3227CSnider Frederick A Jr · Morgantown, WVBuilt 1978 · S/N R18200258 N3242CPelski Aviation LLC · Ocala, FLBuilt 1978 · S/N R18200259 N324SVDavis Kyle R · Colleyville, TXBuilt 1980 · S/N R18201609 N3268CLane Ryan Auctions LLC · Palmyra, PAS/N R18200262 N3275CMoore Hazel Grace · Boise, IDBuilt 1978 · S/N R18200263 N3277CSandstrom Mark R · Minot, NDBuilt 1978 · S/N R18200264 N3279CHunsucker Michael A · Seguin, TXS/N R18200265 N3306CSkylane Inc · Schaumburg, ILBuilt 1978 · S/N R18200269 N3309CScott Parker H · Bulverde, TXBuilt 1978 · S/N R18200270 N3338RMitchell And Son Aviation LLC · Greenwood, INBuilt 1978 · S/N R18200339 N3349CCabrera John F · Glendale, CABuilt 1978 · S/N R18200274 N3378CWaples Charles Andrew · Red Lodge, MTBuilt 1978 · S/N R18200277 N341JCCopeland David Craig · Jackson, GABuilt 1978 · S/N R18200577 N3421YMarshall Air LLC · Paso Robles, CABuilt 1979 · S/N R18201420 N34DWDarvis Enterprises LLC · Addison, TXBuilt 1980 · S/N R18201522 N353SPBerger Amnon Asher · Westwood, MABuilt 1979 · S/N R18201288 N356PTMoody Bible Institute Of Chicago · Spokane Valley, WAS/N R-18201584 N35BHSkylane Ventures LLC · Charlotte, NCBuilt 1979 · S/N R18201050 N35GElias 48 LLC · Morristown, AZS/N R18201785 N35WSRegistered aircraftS/N R18200346 N3618CHoshor Matthew David · Wetumpka, ALBuilt 1978 · S/N R18200278 N3620CSnohomish Flying Service Inc · Snohomish, WABuilt 1978 · S/N R18200279 N3621CAirplane 1 LLC · Warren, NHBuilt 1978 · S/N R18200280 N3625CBurton Michael A · Chicago, ILBuilt 1978 · S/N R18200283 N3626CCowey Kevin M · Pittsburgh, PABuilt 1978 · S/N R18200284 N3627CWebb Brent · Safford, AZBuilt 1978 · S/N R18200285 N3637CThree Seven Charlie LLC · Camp Hill, PABuilt 1978 · S/N R18200288

Back to Cessna R182