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.

N618JLAero Venture LLC · Pasadena, CABuilt 2022 · S/N 8502N618JPBrown Wings LLC · Palm Beach Gardens, FLBuilt 2023 · S/N 9264N618JRRegistered aircraftBuilt 2008 · S/N 2976N618MAAir Matrix LLC · Lomita, CABuilt 2005 · S/N 4697218N618MBSonic Boom Services Inc · Broad Channel, NYBuilt 2004 · S/N 1148N618MMJp Aviation LLC · Littleton, COBuilt 2020 · S/N 2549N618NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881137N618STT Spare Leasing LLC · Waldo, OHBuilt 2007 · S/N 4697318N618VAToorani Brian B · Irvine, CABuilt 2008 · S/N 2904N6190LPineapple Aviation LLC · Greenville, NCBuilt 2025 · S/N 10768N6194JJettstar LLC · Marshall, MNBuilt 1976 · S/N 28-7690368N6195JStandeford Thomas L · Lancaster, OHBuilt 1976 · S/N 28-7690369N6196JArcher Aviation LLC · Jesup, IABuilt 1976 · S/N 28-7690370N6199BD & S Aviation LLC · Spring, TXBuilt 1979 · S/N 287916095N619AGUnited States Air Force · Colorado Springs, COBuilt 1999 · S/N 2843252N619AJBowen John P · Harrison Township, MIS/N 2890201N619ALLamc Associates LLC · Fargo, NDBuilt 2006 · S/N 1742N619AMAirmart Inc · Lexington, KYS/N 2881093N619AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2025 · S/N 10884N619AWAlpha Whiskey Holdings LLC · New York, NYBuilt 2026 · S/N 11242N619BPGay Brandon W · Campbellsville, KYBuilt 2003 · S/N 1313N619CDSimpson Walker Aviation LLC · Joplin, MOBuilt 2005 · S/N 1672N619FTParsley Thomas B · Downingtown, PABuilt 1985 · S/N 28-8616029N619JESk Aviation LLC · Lovettsville, VABuilt 2011 · S/N 2119N619NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881138N619PMDm Flying LLC · Lighthouse Point, FLBuilt 2007 · S/N 2661N619RLPlane Addiction LLC · Hopkinton, MABuilt 2005 · S/N 1528N619SCSpartan Education LLC · Tulsa, OKBuilt 2021 · S/N 2881432N619SSJames Daryl Carr · Hoover, ALBuilt 2008 · S/N 1976N619TKRegistered aircraftBuilt 2006 · S/N 4697243N619TMHeaton Andrew · Houston, TXBuilt 1979 · S/N 28-8090030N619VBDe Paul Steven T DBA · Annandale, NJBuilt 2008 · S/N 411037N619WMKatz Aviation LLC · Riverwoods, ILBuilt 2005 · S/N 1447N61AFAnn Arbor Flyers Inc · Ann Arbor, MIBuilt 1998 · S/N 3257033N61AYAonvo Investment LLC · North Miami, FLS/N BB575N61CDKhoury Fadi · Phoenix, AZBuilt 2006 · S/N 1616N61CPFlying Df'S LLC · Dover, DEBuilt 2017 · S/N 4503N61DPDjp Enterprises Inc · Chandler, TXBuilt 1981 · S/N 348133043N61EWWrede Emil F · Lincroft, NJBuilt 2003 · S/N 1302N61FLCobb Glenn A · Blacksburg, VABuilt 1989 · S/N 4622037N61GEReal Estate Affiliates Of Telluride LLC · Telluride, COS/N 3229N61GTFogle Dennis · Pella, IAS/N 3824N61HBSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2001 · S/N 3449217N61JMJm Airways LLC · West Palm Beach, FLS/N 4251N61JSAltitude & Perspective LLC · Galivants Ferry, SCBuilt 2012 · S/N 3882N61JWBig Bear Resorts Inc · Big Bear Lake, CABuilt 1979 · S/N 32R-8029023N61KMFly US Corp · Lewes, DEBuilt 2006 · S/N 40.675N61KPFlying Coyote Productions LLC · Oro Valley, AZBuilt 2006 · S/N 4697260N61LHFive Star Marketing Inc · Morrisville, NCBuilt 2004 · S/N 40.415N61LMBowling Realty Inc · Jackson, MSBuilt 1981 · S/N 34-8133192
Back to AD 2008-06-28 R1