Skip to content

Registered aircraft · 487

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

N4662EJgm Aviation LLC · Marion, MTFirst renewal noticeS/N 18268256 N4674EMilliken Bradley B · San Mateo, CABuilt 1982 · S/N 18268258 N4675ERojo Aircraft LLC · Mesquite, NVBuilt 1982 · S/N 18268259 N4690EButler Zachary N · Manassas, VABuilt 1982 · S/N 18268260 N4699WN4699w LLC · Rutherford, CABuilt 1981 · S/N 18268131 N46JFTisdell Michael S · Olivia, MNBuilt 1986 · S/N 18268563 N4734EEnergy Transfer Aviation LLC · Spring, TXBuilt 1982 · S/N 18268263 N4740EVehorn Richard B · Carrollton, TXBuilt 1982 · S/N 18268264 N4743ERegistered aircraftBuilt 1982 · S/N 18268265 N4754EJrm Property LLC · Taylors, SCS/N 18268268 N4760EYoung John L · Glorieta, NMBuilt 1982 · S/N 18268269 N4761EDorsheimer Ryan J · Camp Hill, PABuilt 1982 · S/N 18268270 N476DWSkylane Capital Group LLC · Seattle, WABuilt 1980 · S/N 18267793 N4803WRollins Brian D · Smithville, MSS/N 18268203 N4804Pixel King 01 LLC · Fort Worth, TXBuilt 1983 · S/N 18268321 N4812CRennekamp Eric J · Andersonville, TNBuilt 1981 · S/N 18268132 N4836EOlson Philip R Trustee · Amity, ORBuilt 1982 · S/N 18268277 N4862EGyuro Stephen Douglas Trustee · Benton, KSBuilt 1982 · S/N 18268279 N4891EHerman Darrel K · Lebanon, ORS/N 18268281 N4895EWestern Big R Inc · Burns, ORS/N 18268282 N4912EAdams Bruce M · Santa Fe, NMBuilt 1982 · S/N 18268284 N4922HOptic Air LLC · Maurice, IABuilt 1981 · S/N 18267853 N4950HVaivadas Brian S · Bonney Lake, WABuilt 1981 · S/N 18267856 N4981EHendry Robert L · Lysite, WYBuilt 1982 · S/N 18268285 N49FCPiedmont Aviation Leasing LLC · Monticello, GAS/N 18268075 N5080YOptic Air LLC · Maurice, IABuilt 1981 · S/N 18267875 N510ARBrudigam Norman · Lafayette, CABuilt 1981 · S/N 18267733 N510ECState Of Tennessee Department Of Transportation · Nashville, TNBuilt 1984 · S/N 18268421 N5128HWelsh Rolland R · Shady Shores, TXBuilt 1981 · S/N 18267863 N5129ETjr Aviation LLC · Orefield, PABuilt 1982 · S/N 18268290 N5151EBlhh · Dixon, CABuilt 1982 · S/N 18268293 N515MBMoxie Air LLC · Winston Salem, NCBuilt 1982 · S/N 18268202 N5171EL & D Air · Foley, ALBuilt 1982 · S/N 18268295 N5176EAirplane Money Pit LLC · Rexburg, IDBuilt 1982 · S/N 18268296 N5204ECivil Air Patrol Inc · Maxwell Afb, ALS/N 18268299 N5218ETopsail Beach Aviation LLC · Topsail Beach, NCBuilt 1983 · S/N 18268300 N5230EBrentco Aerial Patrol Inc · Canton, OHBuilt 1983 · S/N 18268301 N5257EWings 4 Paws LLC · Yulee, FLBuilt 1983 · S/N 18268304 N5267HNichani Nikhil Deepak · Livingston, NJBuilt 1981 · S/N 18267864 N5276ESchmutz George L · Atascadero, CABuilt 1983 · S/N 18268306 N5299ERosenberg Douglas S · Tillamook, ORBuilt 1983 · S/N 18268308 N5310ENeiman Enviroments Inc · Junction, TXBuilt 1983 · S/N 18268310 N5330EKrieger Andy G · Katy, TXBuilt 1983 · S/N 18268311 N5336HEnergy Transfer Aviation LLC · Spring, TXBuilt 1981 · S/N 18267867 N5385HBeer Steve Z · Morristown, NJBuilt 1981 · S/N 18267868 N5399EAerocraft LLC · Durango, COS/N 18268314 N5412NCat Claw Aviation LLC · San Antonio, TXBuilt 1980 · S/N 18267763 N5438ECsp Aviation LLC · Stuart, FLBuilt 1983 · S/N 18268319 N5440NKenosha Airmens Flying Club Inc · Twin Lakes, WIBuilt 1980 · S/N 18267716 N5442NDeruwe Karl J · Othello, WABuilt 1980 · S/N 18267718

Back to Cessna 182R