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.

N49XLQualitair LLC Trustee · MichelstadtBuilt 1989 · S/N 4622049N4DWFlycone LLC · Encinitas, CABuilt 2025 · S/N 4636864N4GHDouble Bridges Aviation LLC · Luxora, ARBuilt 2013 · S/N 3941N4KWFly Aero LLC · Missoula, MTBuilt 2016 · S/N 4352N4NYLesair LLC · Framingham, MABuilt 2014 · S/N 4697572N4SGCp Aero LLC · Missoula, MTBuilt 2002 · S/N 3257282N4THIm Plane Crazy Ltd · Wilmington, DEBuilt 1978 · S/N 28-7890499N4VTUp And Up Aviation LLC · Magnolia, TXBuilt 1985 · S/N 28-8616015N4YPBobs Biz Ltd · Minster, OHBuilt 1999 · S/N 2843284N4ZYValiair Ltd Co Trustee · Casper, WYBuilt 2005 · S/N 1502N5000CFly Right LLC · Burlington, WIBuilt 2004 · S/N 0803N50068Ocala Aircraft Management LLC · Ocala, FLBuilt 2021 · S/N 2723N5009UOrca Flight LLC · Keaau, HIBuilt 2004 · S/N 0847N500AFAmerican Air Academy Inc · Merritt Island, FLBuilt 2020 · S/N 28020001N500BRSevenlimamike LLC · Cleveland, TNBuilt 2007 · S/N 4697290N500CPEcho Acquisitions LLC · Dover, DEBuilt 2007 · S/N 2636N500CRElite Medical Air Transport LLC · El Paso, TXBuilt 1980 · S/N BB-714N500DPO'Rourke Lawrence · Montgomery, PAS/N 28R-30391N500DYEnterprise Aircraft Finance LLC · Clayton, MOBuilt 2025 · S/N 4636865N500ERConquest II LLC · Kenner, LABuilt 1979 · S/N 441-0084N500FWWohltman Valerie A Trustee · Effingham, ILBuilt 1979 · S/N 28-7990431N500GSCloud Chaser Aviation LLC · Chesnee, SCBuilt 2005 · S/N 2843611N500HAWandering Quarks LLC · Lincolnville, MEBuilt 2005 · S/N 4697222N500HBN500hb LLC · Branchville, NJBuilt 2006 · S/N 1745N500JM500jm Aviation LLC · Westfield, INBuilt 2001 · S/N 4697118N500JRReel Aviators LLC · Scottsdale, AZBuilt 2015 · S/N 4697585N500LHParis Air Inc · Vero Beach, FLBuilt 1978 · S/N 28-7916240N500MHGoodman Aviation LLC · Redondo Beach, CABuilt 2010 · S/N 2067N500NAFive Star Marketing Inc · Raleigh, NCBuilt 2004 · S/N 40.367N500NMGriffin Medical LLC · Sidney, NEBuilt 2011 · S/N 4636500N500PEO2flyhi LLC · Brooksville, FLBuilt 2015 · S/N 4697600N500RCWright Mason · Henderson, NVBuilt 2005 · S/N 1680N500SARas Aviation LLC · Copperas Cove, TXBuilt 2022 · S/N 8859N500SGSimplicity Inc · Redmond, ORBuilt 2004 · S/N 3232020N500VBParagon Airplane Leasing Co · Fort Myers, FLBuilt 2022 · S/N 28020101N500WCRickey Donald N · Murfreesboro, TNBuilt 2004 · S/N 3232019N500XRRjt Equipment LLC · Lubbock, TXBuilt 2016 · S/N 4697609N5012AEpic Aviation Inc · New Smyrna Beach, FLFirst renewal noticeBuilt 2001 · S/N 4496044N501ARToce Leasing LLC · Frisco, TXBuilt 2008 · S/N 411013N501CGCirrus Flyers LLC · Gilbert, AZBuilt 2016 · S/N 4358N501DFAeronotto LLC · Palm Desert, CABuilt 2002 · S/N 1173N501EBPrecision Holdings LLC · Kimberly, IDBuilt 1978 · S/N BB-422N501HKBam Aviation LLC · Baton Rouge, LABuilt 1979 · S/N BB-565N501MAContinental Aerospace Technologies Inc · Mobile, ALBuilt 2021 · S/N 2881479N501NANasa Langley Research Center · Hampton, VABuilt 2001 · S/N 0012N501PTJe Air 2 Corp · Wilmington, DEBuilt 2014 · S/N 4076N501PXMo Flying LLC · Fredericktown, OHBuilt 2016 · S/N 4313N501TXRonald Jones Aviation LLC · Wilmington, DEBuilt 2005 · S/N 1592N5020YStandridge Robert M · Norman, OKS/N 3246187N5023FCharlie Tango Enterprises LLC · Newport Beach, CABuilt 2004 · S/N 0842
Back to AD 2008-06-28 R1