OpenAirDocs.org
AD 2008-06-28 R1

Registered aircraft · 16,280

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2008-06-28-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2008-06-28-R1')
  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.

N416SCribbie Ronald J Trustee · Hernando, FLBuilt 2001 · S/N 0020N416TBMyers Hollis Donald III · Lexington, NCBuilt 2005 · S/N 42080N416TDC C Aviation Group LLC · Wilmington, DEBuilt 2009 · S/N 3398N416TSSutton Nathan M · Houma, LABuilt 1998 · S/N 3246100N416WBSoaring Eagle Air LLC · Salt Lake City, UTBuilt 2007 · S/N 2540N4170HBridges Kevin J · Clemmons, NCBuilt 2002 · S/N 3449259N4170LOsborn Allan R Trustee · Springfield, VABuilt 2000 · S/N 28-43387N4170TVwfusco Aircraft Management LLC · Stratford, CTBuilt 2000 · S/N 2843390N4170VPi High Flight LLC · Lancaster, PABuilt 2000 · S/N 3257141N4171XGailing Jessica L · Costa Mesa, CABuilt 2000 · S/N 2843349N4172DChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 2843400N4172TMajor Michael S · Ogden, UTBuilt 2000 · S/N 3257158N4172ZMathew Priya Trustee · Utica, NYS/N 2843384N4173AE Hospital Services Inc · Houston, TXFirst renewal noticeBuilt 2000 · S/N 3257146N4173DCw Flyers Ltd · Wilmington, DEBuilt 2000 · S/N 2843334N4174AGutwein Harvey R · Francesville, INBuilt 2000 · S/N 3246174N4174BTactical Integrated Training Solutions LLC · Colorado Springs, COS/N 40.932N4174CZierhut Kurt P · Camarillo, CABuilt 2000 · S/N 3246167N4174DB L Duke Inc · Joliet, ILBuilt 2000 · S/N 3449178N4174TAverett University · Danville, VABuilt 2000 · S/N 2843322N4174USouthern Siding And Window Corp · Augusta, GABuilt 2002 · S/N 3257308N4174VDalmore Estates LLC · Los Angeles, CABuilt 2000 · S/N 4697014N4174ZCaledonia Air LLC · Palm Beach, FLBuilt 2000 · S/N 3257179N4175KYu Christopher · Menlo Park, CABuilt 2000 · S/N 4636294N4176KWhite Dennis Trustee · Colorado Springs, COS/N 32-57189N4176TAir Ninja LLC · Wilmington, NCBuilt 1999 · S/N 3257124N4176XJack & Cole Airline Inc · Norcross, GABuilt 2003 · S/N 3232013N4177LBird Acquisition LLC · Phoenix, AZBuilt 1999 · S/N 2843210N4177NMankato Aviation Service Inc · Mankato, MNBuilt 2000 · S/N 2843351N4177PMoran John B · West Roxbury, MABuilt 1983 · S/N 28-8390051N4177TBrown Rock A · Willis, TXBuilt 1998 · S/N 3246112N4177VWages Charles Braden · Dallas, TXBuilt 1999 · S/N 3257077N4178NK Tahoe Air LLC · Glendale, CABuilt 2001 · S/N 2843415N41799Registration Pending · Panama City Beach, FLRegistration pendingBuilt 2000 · S/N 4636257N417CAHand David C · Oviedo, FLBuilt 1978 · S/N 28-7816345N417EPEpic Aviation Inc · New Smyrna, FLFirst renewal noticeBuilt 2017 · S/N 4496403N417EVValley Aircraft Capital LLC · Gulf Shores, ALBuilt 2025 · S/N 11069N417FTRegistered aircraftBuilt 2017 · S/N 2339N417JRBinary Ninjutsu LLC · Myrtle Beach, SCS/N 0222N417JSCockapoo Air LLC · Naperville, ILBuilt 1998 · S/N 4636183N417JTQuick Kenneth Wayne · Cordova, TNBuilt 2005 · S/N 1325N417KHWillens Mark D · Livermore, CABuilt 2010 · S/N 3657N417LCFowm LLC · West Memphis, ARBuilt 2016 · S/N 4367N417MAT&G Aviation Services LLC · Temple, TXBuilt 2007 · S/N 4636415N417MMN417mm LLC · Kirkwood, MOBuilt 2007 · S/N 2332N417MXAw Foxtrot LLC · Cuero, TXBuilt 2008 · S/N 4692017N417PABird Acquisition LLC · Phoenix, AZBuilt 2002 · S/N 2843524N417PWFleur De Lis Krewe LLC · Orlando, FLBuilt 2006 · S/N 1929N417RKAutavia Inc Trustee · Wilmington, DEBuilt 1999 · S/N 4636249N417STM500 LLC · Lewisville, TXBuilt 2017 · S/N 4636714
Back to AD 2008-06-28 R1