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.

N582MBLatitude Leasing LLC · Birmingham, ALBuilt 1999 · S/N 4636237N582MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2004 · S/N 40.398N582NDChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 4496261N582TTSkyview Holdings LLC · Lacey, WABuilt 2017 · S/N 2354N583CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881132N583CDInternational Air Services Inc Trustee · Carson City, NVBuilt 2006 · S/N 1809N583MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2004 · S/N 40.399N583NDChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 4496253N583PUSale Reported · Gainesville, FLSale reported, pending cancellationBuilt 2010 · S/N 2043N583WPWp583 Enterprises LLC · Camarillo, CABuilt 2007 · S/N 41740N5846FDunning Steve L · Hopkinsville, KYBuilt 1976 · S/N 28-7790138N5849FGng LLC · Arlington, INBuilt 1976 · S/N 28-7790139N584BSch Aviation Inc Trustee · NorfolkBuilt 2007 · S/N 2330N584CDBrothers David M Trustee · Cainsville, MOBuilt 2005 · S/N 1652N584CFGreenspace Of Virginia LLC · Forest, VABuilt 2022 · S/N 8584N584CPThorpe LLC · Jupiter, FLS/N 3353N584MTMiddle Tennessee State Univ · Murfreesboro, TNBuilt 2008 · S/N 40.952N584SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881403N584SRThunder Richard · San Diego, CABuilt 2007 · S/N 2378N5854AColorado High Plains Aviation Ltd · Englewood, COBuilt 2002 · S/N 0171N5857VHague Parkerson B · Virginia Beach, VAS/N 28-7716207N5859VHaney Paul · Navarre, FLBuilt 1977 · S/N 28-7790504N585ABHh Aircraft LLC · Englewood, COBuilt 2009 · S/N 3499N585AWChristiansen Aviation LLC · Wilmington, DEBuilt 2017 · S/N 2843934N585BWNew Horizon Aviation LLC · Medford, NJS/N 40.262N585CDE And J Holdings 25 LLC · El Dorado, ARBuilt 2005 · S/N 1661N585CFBuzzing Above II LLC · Tampa, FLBuilt 2022 · S/N 8585N585ECMc Aviation II LLC · West Palm Beach, FLBuilt 2019 · S/N 4816N585EJPuckett Christopher A · Stillwater, OKBuilt 2016 · S/N 2319N585GBCirrus Design Corp · Knoxville, TNBuilt 2013 · S/N 3959N585GEWayne Mogg Inc · Parker, AZFirst renewal noticeBuilt 2018 · S/N 2881009N585GT2029 Realty Corp · Farmingdale, NYBuilt 2017 · S/N 4491N585MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2008 · S/N 40.958N585RBPonderosa Aviation LLC · Safford, AZBuilt 1979 · S/N BB-528N585SPEagle Aviation Columbia LLC · West Columbia, SCBuilt 2006 · S/N 1737N585SRNublos Group LLC · Birmingham, ALBuilt 2007 · S/N 2347N585TCAv8 LLC · Rockwall, TXBuilt 2013 · S/N 2230N5863N5863 LLC · Kalispell, MTBuilt 2019 · S/N 4764N586BSea Breeze Aviation LLC · Ocean Isle Beach, NCBuilt 2026 · S/N 11258N586CAOrlando Holding Company LLC · Port Jervis, NYBuilt 2026 · S/N 11081N586CFJbw Aviation LLC · Benton, KYBuilt 2022 · S/N 8596N586EFMauli Enterprises LLC · Somerset, NJBuilt 2026 · S/N 11381N586KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843917N586MAWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1999 · S/N 2843297N586MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2008 · S/N 40.962N586SRFat Alberts Inc · Poteau, OKBuilt 2007 · S/N 2348N5875VCrew Michael A · Phoenix, AZBuilt 1977 · S/N 28-7716209N5877VWest Keith W · Slatington, PABuilt 1977 · S/N 28-7790505N5878VVoll Douglas W · Watford City, NDS/N 28-7790506N587ATBcaa Aviation LLC · Westfield, INBuilt 2009 · S/N 3459
Back to AD 2008-06-28 R1