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.

N2147GAviation Capital Management LLC · San Jose, CABuilt 1978 · S/N 28-7916178N21481Houston Christopher T · Webster, NYBuilt 1978 · S/N 28-7916044N21489D & S Aviation LLC · Spring, TXBuilt 1978 · S/N 28-7990050N2148FRegistration Pending · Wilmington, DERegistration pendingBuilt 1978 · S/N 44-7995157N2148ZMalburg Phillip E · Holland, MIBuilt 1979 · S/N 28-7916378N2149ZBauer Jeff C · North Falmouth, MABuilt 1980 · S/N 28-7916380N214BBMessina Mark · Wallingford, CTBuilt 2001 · S/N 0085N214BPHolmes Aviation Inc · Webster, FLBuilt 2000 · S/N 3257156N214BRBaba Daniel · Glastonbury, CTBuilt 2007 · S/N 2318N214CDN214cd LLC · Atlanta, GABuilt 2001 · S/N 1113N214CLCx Aviation Inc Trustee · Wilmington, DEBuilt 2012 · S/N 3830N214CPHollis Roofing Inc · Columbus, MSS/N 3146N214CTValiair Limited Co Trustee · Casper, WYBuilt 2009 · S/N 3584N214DJAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2003 · S/N 0746N214EDWoods Johnny I · Hendersonville, TNBuilt 1980 · S/N 44-8195007N214GKSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1985 · S/N 34-8633001N214HLGulf Sun Vacation Rentals LLC · Port Saint Joe, FLBuilt 2006 · S/N 41622N214JGValiair Lc Trustee · Casper, WYS/N 2048N214JPTop Flight Leasing LLC · Frankfort, ILBuilt 1994 · S/N 3213083N214JRMullet & Grits II LLC · Muskogee, OKBuilt 2005 · S/N 3232048N214KRRogers Karl Dr · Nashville, TNBuilt 2008 · S/N 4692098N214LMHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 44-7995053N214PDN214pd LLC · Manakin Sabot, VABuilt 2008 · S/N 40.1018N214RAJw Aero Holdings Inc · Canandaigua, NYBuilt 1976 · S/N 28-7690440N214SCAzul Air LLC · Dover, DEBuilt 1976 · S/N LW-96N214SQSawque LLC · Rochester, MNBuilt 2019 · S/N 2527N214TWRegistered aircraftBuilt 2004 · S/N 1225N214TXAdams Randy K · Spicewood, TXBuilt 2014 · S/N 4066N214VQSimply Living LLC · Fort Myers, FLBuilt 2011 · S/N 3808N21500Cal Aggie Flying Farmers Inc · Davis, CABuilt 1978 · S/N 44-7995055N2150FShoreline Aviation Inc · Marshfield, MABuilt 1978 · S/N 28-7916186N2150YGoldstein Orpaz · Woodland Hills, CABuilt 1979 · S/N 28-7916360N2150ZHilton Head Flyers LLC · Liberty, SCBuilt 1979 · S/N 28-7916382N21522Hove Paul · St Paul, MNBuilt 1978 · S/N 28-7916046N2152AWojtowicz Jacek A · Rhinebeck, NYBuilt 1978 · S/N 28-7916099N2152ZN2152z LLC · Middletown, DEBuilt 1979 · S/N 28-7916383N2154FGentile Nicholas J · Spring Grove, PABuilt 1978 · S/N 28-7990203N2156BTassmanian Aircraft LLC · Middletown, DEBuilt 1978 · S/N 44-7995100N2157BMesheryakov Roman · Jacksonville, FLBuilt 1978 · S/N 28-7916113N2157YRegistration Pending · Northampton, MARegistration pendingBuilt 1979 · S/N 28-7990376N2158ZTribute Aero LLC · Rochester, MIBuilt 1979 · S/N 28-7990403N2159HBeverly Flight Center LLC · Middleton, MABuilt 1978 · S/N 28-7916192N2159QWisconsin Aviation-Four Lakes Inc · Madison, WIBuilt 1979 · S/N 28-7916282N215ALUdaan LLC · Vienna, VABuilt 2025 · S/N 11061N215CDValiair Lc Trustee · Casper, WYBuilt 2001 · S/N 1114N215CPMcallen Enterprises LLC · Mission, TXBuilt 2006 · S/N 1741N215CTTellam Allan R Trustee · Chandler, AZS/N 41646N215DSArm Financial LLC · Annandale, VABuilt 2007 · S/N 40.829N215EBSalty Air LLC · Wayne, PABuilt 2024 · S/N 9766N215EMPostma Air LLC · Saint Paul, MNS/N 2453
Back to AD 2008-06-28 R1