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.

N5549SArdizzone Mark Robert · Mckinney, TXS/N R18201607 N555FCRegistered aircraftBuilt 1981 · S/N R18201707 N55WMBankston Jeffery · Rice, TXBuilt 1978 · S/N R18200757 N56NLExtra Air LLC · Port Orange, FLBuilt 1977 · S/N R18200084 N5897ECoral Breeze Aviation LLC · Hinsdale, ILS/N 18268337 N58CCPittsburgh Marine Technologies · Eighty Four, PABuilt 1981 · S/N R18201729 N58GSCranford John · Douglassville, TXBuilt 1979 · S/N R18201412 N5921EPeterson Dennis L · Daleville, ALS/N 18268338 N5939EWhite Sound International Ltd · New Smyrna Beach, FLBuilt 1983 · S/N 18268339 N6006CUtah State University · Logan, UTS/N R18200347 N6007CAdler Jeffrey S Trustee · Westminster, COBuilt 1978 · S/N R18200348 N6013CWestra Jacob John · Visalia, CAS/N R18200351 N6014CHangar 14 LLC · Spokane, WABuilt 1978 · S/N R18200352 N6025CKesler Neal Trustee · Wilmette, ILBuilt 1978 · S/N R18200356 N6026CPflueger Michael W · Scottsdale, AZBuilt 1978 · S/N R18200357 N6027CShough Mark E · Bemidji, MNBuilt 1978 · S/N R18200358 N602HPStraight Up Aviation LLC · Columbus, MSS/N R18201916 N6051EMathews James L · Menlo Park, CABuilt 1983 · S/N 18268342 N6056CFlight Contract Services Inc · Las Vegas, NVBuilt 1978 · S/N R18200365 N6078CKtoa Rentals LLC · Torrance, CABuilt 1978 · S/N R18200370 N6079CAllen William H Trustee · Big Bear City, CAS/N R18200371 N6081CShannon Jeanette M · Marathon, FLS/N R18200372 N6086SDos Lobos Aviation LLC · Yankton, SDBuilt 1980 · S/N R18201610 N6103SJohnson Robert J · Santa Barbara, CABuilt 1980 · S/N R18201611 N6105SMy Sky LLC · Hays, KSBuilt 1980 · S/N R18201612 N6112SHall Metal Corp · Fort Pierce, FLBuilt 1980 · S/N R18201615 N6120SLash Gary L · Round Rock, TXBuilt 1980 · S/N R18201618 N6122SBusiness Jet Managers Inc · Canton, MIBuilt 1980 · S/N R18201619 N6124TBanjo Ben Aviation LLC · Kilgore, TXS/N R18201911 N6128TStone Mark · Scotts Valley, CABuilt 1982 · S/N R18201912 N6137TDurnin Timothy K · Lansing, ILS/N R18201917 N6145SPlaney Mcplane Face LLC · N Richlnd Hls, TXBuilt 1980 · S/N R18201625 N6149SScheller Kenneth R · Glassport, PABuilt 1980 · S/N R18201627 N614MBStarlight Express LLC · Bellevue, WABuilt 1978 · S/N R18200169 N614WMCarbonell Terry L · Alva, FLBuilt 1977 · S/N R18200117 N6157SKearley Christopher · Assonet, MABuilt 1980 · S/N R18201632 N6161STeklinski Andrew · Indian River, MIS/N R18201633 N6205TOglesby Dale A · Galena, KSBuilt 1983 · S/N R18201933 N6210TVandenakker Greg W · Whitinsville, MABuilt 1983 · S/N R18201938 N6212THooking Bull Investments LLC · Tallulah, LAS/N R18201939 N621DHPic Aviation LLC · Fort Valley, GABuilt 1978 · S/N R18200143 N6245SFillmore Aviation LLC · South Saint Paul, MNBuilt 1980 · S/N R18201653 N6269TN6269t · Lampe, MOBuilt 1983 · S/N R18201952 N6274TGlenum Donald L III · Norfolk, VABuilt 1983 · S/N R18201954 N6278SFlick Damon · Dansville, NYBuilt 1980 · S/N R18201657 N6287TCape Phoenix LLC · East Falmouth, MABuilt 1983 · S/N R18201960 N6289TCiliberti Gregory J · Loveland, OHBuilt 1983 · S/N R18201961 N628RDGebert Benjamin A · Hillsdale, NYBuilt 1979 · S/N R18201066 N6294TGreater Flint Pilots Association · Flushing, MIBuilt 1983 · S/N R18201962 N62JMVan Bergen Matthew D · Arlington Heights, ILS/N R18201834

Back to Cessna R182