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.

N532STNovaair LLC · Lake Sherwood, CABuilt 2013 · S/N 4697532N532TWRooplal Robby Ashram · Spring, TXBuilt 1983 · S/N 28-8416006N5330GKaris Aviation LLC · Poplar Bluff, MOBuilt 2001 · S/N 3257232N5330YMiller Steven M · Las Vegas, NVS/N 3257235N5331NUniversity Of Illinois · Savoy, ILBuilt 2001 · S/N 4496106N5331YHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2002 · S/N 4496163N53339Skywest Leasing Inc · St George, UTS/N 2843469N5333MWeaver William Cookman III · Fayetteville, NCBuilt 1977 · S/N 28-7816140N53349Arrow Aviation LLC · Howell, MIS/N 2843470N5335FEasterby Daniel · Big Bear Lake, CABuilt 1976 · S/N 28-7790090N5335TBillingsley Tom · Lufkin, TXS/N 3257231N53369Poor Boy Aero LLC · Seminole, TXBuilt 2001 · S/N 4697088N5336VKenco Leasing LLC · Mentor, OHBuilt 2001 · S/N 3257240N5336ZQualitair LLC Trustee · MichelstadtBuilt 2004 · S/N 1413N5337FIxi LLC · West Bloomfield, MIBuilt 1976 · S/N 28-7790092N5337NInternational Air Services Inc Trustee · Carson City, NVS/N 4697102N5337SAnn Arbor Flyers Inc · Ann Arbor, MIBuilt 2001 · S/N 2843479N5338MAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 4697103N53392Seacrest Seven LLC · Savannah, GAS/N 3257249N5339FFox Stephen J · Corning, ARS/N 3246195N5339G5339g LLC · Vero Beach, FLFirst renewal noticeBuilt 2001 · S/N 4697095N533CASkylink Xpress Inc · San Bernardino, CABuilt 1989 · S/N 2841210N533CDAvem LLC · Salt Lake City, UTBuilt 2004 · S/N 0995N533CFAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 1479N533CPAtaraxia Aircraft Holdings LLC · Greenville, SCBuilt 2008 · S/N 3031N533DDEverglades Aviation Academy LLC · Weston, FLS/N 28-8190240N533HTWest Wings LLC · Blair, NEBuilt 2004 · S/N 1046N533JTIpi Private Wealth LLC · Decatur, ILBuilt 2001 · S/N 3257198N533PGGabrek Properties LLC · Fort Wayne, INBuilt 2008 · S/N 1993N533SSMacon King Air 90 LLC · Dover, DEBuilt 1976 · S/N LW-197N533TJTmc Plane LLC · Bluffton, SCBuilt 2015 · S/N 4292N5340ACrews Randall S · Valdosta, GAS/N 2843489N5340MN5340m LLC · Greenville, SCBuilt 2001 · S/N 3246198N5341CMobilesphere LLC · Cambridge, MABuilt 2002 · S/N 4697142N5341ZAtp Aircraft 4 LLC · Wilmington, DEBuilt 2001 · S/N 4496107N53424Winnie Inc · Winchester, VAS/N 3257259N5342JMoore Durk · Farmington Hills, MIS/N 2843493N5342KWest Coast Equipment Leasing LLC · Aurora, ORBuilt 2001 · S/N 2843467N5342LAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 3246200N5342VS & L Real Estate LLC · Waterloo, IABuilt 2002 · S/N 3246205N5343CFranks Flying LLC · Dover, DES/N 3257255N53447Bank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 2843535N5344VSeneca Holdings LLC · Mesa, AZBuilt 2002 · S/N 3449239N5344WTech Team Corp · Saint Joseph, MOS/N 3246201N53455Real Robert · Miami, FLBuilt 2002 · S/N 3246204N5345FArcher Air LLC · Traverse City, MIBuilt 1976 · S/N 28-7790093N53464Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 3257262N5346FSo Send I You LLC · Cheyenne, WYS/N 28-7790094N5346UAverett University · Danville, VABuilt 2003 · S/N 2843542N5347DAdvanced Commercial Group LLC · Helena, MTBuilt 2004 · S/N 1415
Back to AD 2008-06-28 R1