Skip to content

Registered aircraft · 465

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

N4654TParthemore Terry L II · North Bend, ORS/N R18201726 N4657SXyz Aircraft LLC · Albuquerque, NMBuilt 1979 · S/N R18201369 N4664SSchunk Luke C · Tomahawk, WIBuilt 1979 · S/N R18201371 N4667SAdvanced Communications & Technologies Inc · Erie, COBuilt 1979 · S/N R18201373 N4670SEagle Valley Aviation LLC · Carson City, NVBuilt 1979 · S/N R18201375 N4674SDirect Oscar LLC · Jamestown, NYS/N R18201376 N4681SRezek William E · Centennial, COBuilt 1979 · S/N R18201377 N4683STorley Christopher · Flower Mound, TXBuilt 1979 · S/N R18201378 N4684TMk Aviation LLC · Charlotte, NCS/N R18201733 N4694SNyhus David L · Bismarck, NDBuilt 1979 · S/N R18201384 N4700SGiddyup Flyers LLC · Danville, CABuilt 1979 · S/N R18201388 N4701SBailey Mark E · Owingsville, KYBuilt 1979 · S/N R18201389 N4707SBas Part Sales LLC · Greeley, COBuilt 1979 · S/N R18201393 N471GMHarland Willard G · Tuscumbia, ALBuilt 1979 · S/N R18201112 N4723TPrs Holdings Inc · Jurupa Valley, CABuilt 1981 · S/N R18201744 N4735TUlrich Dennis · London, KYS/N R18201747 N4737SMaverick Consulting LLC · Prior Lake, MNBuilt 1979 · S/N R18201406 N4740RCall Tracy J · Carmel Valley, CABuilt 1978 · S/N R18200608 N4741SOkkb2 Inc · Vancouver, WABuilt 1979 · S/N R18201408 N4743SDimitri Bevc · Pleasanton, CABuilt 1979 · S/N R18201409 N4754SNichols William R Jr · Austin, TXBuilt 1979 · S/N R18201416 N4761TWorden Frederick F · Tucson, AZBuilt 1981 · S/N R18201755 N4763SMayday Flyers LLC · West Jordan, UTBuilt 1979 · S/N R18201419 N4772TCaballeros Aircraft LLC · Snohomish, WABuilt 1981 · S/N R18201760 N4777SN4777s LLC · Ault, COBuilt 1980 · S/N R18201424 N4785SSchiller Matt D · San Francisco, CABuilt 1979 · S/N R18201426 N4809RNorthern Air Inc · Bonners Ferry, IDS/N R18200610 N4829RThomas Michael W · Prescott, WABuilt 1978 · S/N R18200614 N4832TVesely Paul T Trustee · Louisa, VABuilt 1981 · S/N R18201772 N4836SRegistration Pending · Maple Lake, MNRegistration pendingBuilt 1979 · S/N R18201435 N4838TSnow Leopard Ltd · Incline Village, NVBuilt 1981 · S/N R18201774 N4840TRegistered aircraftS/N R18201775 N4850SWood Josh A · Chino Hills, CAS/N R182201438 N4871RWagner James M · Le Sueur, MNBuilt 1978 · S/N R18200615 N4881RSheffield Chad F · Muldrow, OKBuilt 1978 · S/N R18200619 N4902SBbsa Flight LLC · Tucson, AZBuilt 1979 · S/N R18201442 N4904SO Neil Mark F · Suffolk, VABuilt 1979 · S/N R18201444 N4906SSweeney Peter Allan · Irvine, CABuilt 1979 · S/N R18201446 N4912SStevens Joel N · Monticello, ARBuilt 1980 · S/N R18201451 N4918SSilverado Sales Inc · Orem, UTBuilt 1980 · S/N R18201457 N4920SExecutive Flyers Inc · Sacramento, CAS/N R18201459 N4922SNyrhinen Aki · Reno, NVBuilt 1980 · S/N R18201461 N4928SJohnson Jeffrey S · El Dorado, CABuilt 1980 · S/N R18201467 N4938TTilney Five LLC · Belleair, FLBuilt 1981 · S/N R18201796 N4939SLeriche Daniel R · Wolcott, VTBuilt 1980 · S/N R18201478 N4940SO'Gorman Robert W Jr · Wake Forest, NCBuilt 1980 · S/N R18201479 N4945TBj Aviation Inc · Littleton, COS/N R18201800 N4948STaildragon LLC · Albuquerque, NMBuilt 1980 · S/N R18201487 N4952TKeith Investments LLC · Verona, MSS/N R18201802 N4953TBergeron Jason Alan · San Antonio, TXS/N R18201803

Back to Cessna TR182