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.

N574JWCirrus Design Corp · Duluth, MNS/N 11682N574RKHorn Aviation LLC · Hartland, WIFirst renewal noticeBuilt 2016 · S/N 4423N574RMCardinal Enterprises LLC · Denver, COBuilt 2004 · S/N 41007N574SBristol Aircraft Leasing LLC · Willoughby, OHBuilt 2002 · S/N 0343N574SAManager Aviation LLC · Pleasanton, CABuilt 2024 · S/N 9924N5754MJ & A Aviation LLC · Danvers, MABuilt 2020 · S/N 4945N5757International Air Services Inc Trustee · Carson City, NVBuilt 1997 · S/N 4636114N575ATAtp Aircraft 3 LLC · Wilmington, DEBuilt 2005 · S/N 4496203N575BLSolera Aviation LLC · Bozeman, MTBuilt 2025 · S/N 2881958N575CATmofly LLC · Suffolk, VABuilt 2011 · S/N 4697452N575CDG2 Aero LLC · Chattanooga, TNBuilt 2004 · S/N 0936N575CPHka Flying Club LLC · Hoover, ALBuilt 2008 · S/N 3341N575JMCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11579N575LDFlyer 757 LLC · Wilmington, DEBuilt 2015 · S/N 2293N575MCStuteville Consulting LLC · Durant, OKBuilt 2007 · S/N 2764N575MDWesties With Altitude LLC · Newark, DEBuilt 2012 · S/N 2221N575SABarnts Sales Company LLC · Diller, NEBuilt 2006 · S/N 2003N575SDBlue Sky Aviation LLC · Menominee, MIBuilt 2023 · S/N 2881633N575TXHu Jianing · Santa Clara, CABuilt 2010 · S/N 3520N575WTDanemann Mark · Taos, NMBuilt 2005 · S/N 1533N576BSC&J Aerobiz LLC · Madison, ALBuilt 2005 · S/N 41059N576CDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 1665N576CLAci Aviation LLC · Victor, MTBuilt 1979 · S/N BB-576N576CPQualitair LLC Trustee · MichelstadtBuilt 2008 · S/N 3342N576DGEdge David Lee · Lumberton, NCBuilt 2005 · S/N 1617N576KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843937N576WSLottman Transportation LLC · Diller, NEBuilt 2004 · S/N 3255025N577DGW&E Aviation LLC · Peoria, AZBuilt 2020 · S/N 4887N577DHHawkeye Aviation LLC · Mason, OHBuilt 2016 · S/N 4339N577HPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 4697377N577KC1906 Aviation LLC · Greenwood, SCBuilt 2014 · S/N 4697577N577PGCirrus Design Corp · Duluth, MNBuilt 2008 · S/N 2978N577SRSteubesand Karl · Rhinebeck, NYBuilt 2007 · S/N 2845N577STPlane Fun Inc Tr Trustee · Snellville, GABuilt 2008 · S/N 411091N578ACN578ac LLC · Westfield, MABuilt 2026 · S/N 11308N578AGAlpha Gulf Holdings LLC · Wesley Chapel, FLBuilt 2007 · S/N 2822N578CDCarothers Donald Luis · Bakersfield, CABuilt 2005 · S/N 1643N578CPOsman Keenan · Seffner, FLBuilt 2008 · S/N 3350N578KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843901N578KSMisurelli Francis X · Lake Hopatcong, NJBuilt 2004 · S/N 40.429N578PSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 0966N578SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881402N579HFNorthstar Voyager Corp · Lewes, DEBuilt 2006 · S/N 3257408N579MWCqf Holdings LLC · Fairhope, ALBuilt 2019 · S/N 4785N579RCLavid Corp · Miami, FLBuilt 2002 · S/N 1200N579SRShepherd Kris R · Blue Ash, OHBuilt 2007 · S/N 2376N579WWCobb Kevin · Lincoln, CABuilt 2006 · S/N 1639N57ATJp Bcbnz Holdings LLC · Clinton, MDS/N 4697350N57DB57db Aviation LLC · Fort Myers, FLBuilt 2021 · S/N 5108N57DECape Aviation LLC · Lewes, DEBuilt 2024 · S/N 10129
Back to AD 2008-06-28 R1