Skip to content

Registered aircraft · 189

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

N307MRSilverstar II LLC · Houston, TXBuilt 1977 · S/N 501-0012 N311TPTarvair Eclipse LLC · Burnsville, NCBuilt 1981 · S/N 501-0196 N311VPBluegrass Venture Holdings LLC · Louisville, KYBuilt 1999 · S/N 501-0311 N322STC & W Aviation LLC · Vestavia Hills, ALBuilt 1977 · S/N 501-0278 N328NAN186sb LLC · Stuart, FLBuilt 1980 · S/N 501-0168 N339HPAlpine Turbine LLC · Rollins, MTBuilt 1979 · S/N 501-0292 N347MHStallion 501 LLC · Wilmington, DEFirst renewal noticeS/N 501-0155 N361DEClear Sky Flying LLC · Center, TXBuilt 1985 · S/N 501-0687 N381BJCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1978 · S/N 501-0286 N393PJThunder Wings Aircraft Sales LLC · Bethany, OKBuilt 1980 · S/N 501-0303 N39HHDig N Wings LLC · Knoxville, TNBuilt 1979 · S/N 501-0132 N3GNR-Air Inc · Wilmington, DES/N 501-0090 N3WTCb LLC · Mobile, ALBuilt 1979 · S/N 5010088 N403AAN403aa LLC · Fort Lauderdale, FLBuilt 1977 · S/N 501-0264 N406LJWord Jon D · Albuquerque, NMBuilt 1981 · S/N 501-0230 N41GTBraden Health LLC · Greensboro, NCBuilt 1978 · S/N 501-0297 N420PCCrimson Leasing LLC · Lenexa, KSBuilt 1981 · S/N 501-0237 N44MKCypress Aircraft Sales LLC · Clermont, FLS/N 501-0272 N454ACCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1977 · S/N 501-0015 N45AFCenturion Air LLC · Draper, UTBuilt 1978 · S/N 5010284 N45TLNbb II LLC · New Orleans, LAS/N 5010016 N500WJKiesau Insurance Services LLC · Lenoir City, TNS/N 501-0275 N501Stallion Aircraft LLC · Miami, FLBuilt 1977 · S/N 501-0011 N501ALandrock Real Estate Inc · Reedley, CABuilt 1977 · S/N 501-0051 N501ABRegistration Pending · Richmond, VARegistration pendingBuilt 1978 · S/N 501-0082 N501ADCrockagator Adventures LLC · Sabina, OHS/N 501-0093 N501AJFreiford LLC · Pasco, WAS/N 501-0059 N501ATEast Tennessee Aviation Services LLC · Harrison, TNBuilt 1977 · S/N 501-0017 N501BBWno Trust Services LLC Trustee · Wilmington, DES/N 501-0087 N501CBSnoe Gary A · Somerville, TXBuilt 1978 · S/N 5010281 N501CDCroman Corp · White City, ORBuilt 1978 · S/N 501-0066 N501CFApex Tower Group LLC · Spring, TXBuilt 1979 · S/N 501-0128 N501CPP And D Partnership II LLC · Oro Valley, AZS/N 501-0034 N501DDDk Air LLC · Brookings, ORBuilt 1977 · S/N 501-0035 N501DPBraden Health LLC · Greensboro, NCBuilt 1980 · S/N 501-0162 N501GRBest Aircraft Deals LLC · Salt Lake City, UTBuilt 1977 · S/N 501-0006 N501HSLewis Garry L · Livingston, LABuilt 1979 · S/N 501-0096 N501JDUniversal Air Service Ltd · Wilmington, DEBuilt 1979 · S/N 501-0129 N501JJKelsay Roger B · Hillsboro, ORS/N 501-0269 N501JMBohn Martin · Wichita Falls, TXS/N 501-0226 N501KWFly Buy LLC · Kalispell, MTBuilt 1979 · S/N 5010092 N501MBGarood LLC · Redmond, WAS/N 501-0122 N501MCCharlie Chase Aviation LLC · Findlay, OHBuilt 1981 · S/N 501-0204 N501MFGreyshore Aviation LLC · Mystic, CTS/N 501-0244 N501MZNovember501mikezulu LLC · Omaha, NEBuilt 1979 · S/N 5010298 N501NY501 Leasing LLC · Ocean Springs, MSBuilt 1977 · S/N 501-0038 N501NZPoussot Rodolphe · Malvern, PABuilt 1981 · S/N 501-0225 N501PJDiamond K Enterprises Inc · Caldwell, TXS/N 501-0111 N501PVJava Medical Group LLC · Nashville, TNBuilt 1977 · S/N 501-0028 N501QSmda LLC · Jefferson City, MOS/N 501-0233

Back to Cessna 501