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.

N693JDBowles Brent K · Lake Jackson, TXBuilt 2008 · S/N 3021N693LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881218N693MSandpiper Air LLC · Alexandria, VABuilt 2020 · S/N 4949N693SRCarmichael Mark G · Palm Desert, CABuilt 2007 · S/N 2796N693TFStevenson Farhana · Lexington, MABuilt 2017 · S/N 4583N693TSColtharp William M · Austin, TXBuilt 2009 · S/N 3393N6942JAndromeda Air LLC · Houston, TXBuilt 1976 · S/N 28-7690434N6944CUpdraft Leasing LLC · Tea, SDBuilt 1978 · S/N 28-7816442N694CDRogers Jack Burton Jr · Bakersfield, CABuilt 2006 · S/N 1789N694LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881219N694MRHarmon Creighton D · Scott, LABuilt 2010 · S/N 3694N694PCBajedi Aviation LLC · Lewes, DEBuilt 2002 · S/N 3257305N694PRAdvanced Charter Industries LLC · Orange, CABuilt 2005 · S/N 1606N694RMTavel Charles · Cave Creek, AZBuilt 2005 · S/N 2843607N694STMcmillion Air LLC · Franklin, INBuilt 2016 · S/N 4636694N694TTMiller Patrick · Riverside, CABuilt 2004 · S/N 1239N6950TThornebymyside LLC · Punta Gorda, FLBuilt 2019 · S/N 4863N6956JJuliet Sky LLC · Sioux City, IABuilt 1976 · S/N 28-7690439N6958JAkin Enterprises Inc · Greensboro, GABuilt 1976 · S/N 28-7690441N695APiper Archer Three LLC · Wilmington, DEBuilt 2014 · S/N 2843782N695AABurke Garrett · Jupiter, FLBuilt 2021 · S/N 2714N695DSBravo Busters LLC · Southport, NCBuilt 2007 · S/N 40.865N695DTRegistered aircraftBuilt 1995 · S/N 3213102N695FParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020237N695LHJrnd Corp · Lewes, DEBuilt 2023 · S/N 2881628N695NDFly Gateway Aviation Institute · New Castle, DEBuilt 2015 · S/N 4496386N695TSSyring James D · Boerne, TXBuilt 2023 · S/N 9571N6962SYeaman John Robert IV · Aroda, VABuilt 2000 · S/N 4636272N6965JDanik LLC · Harper Woods, MIBuilt 1976 · S/N 28-7690442N6966CSchlichter Timothy J · Huntsville, ALBuilt 1978 · S/N 28-7816443N6966JTwo Mile Final LLC · Spring, TXBuilt 1976 · S/N 28-7690443N6967CUp And Down Aviation LLC · Perry, GAS/N 28-7816444N6969VArcher II Management LLC · Hernando, MSBuilt 1979 · S/N 288090137N696APiper Archer Three LLC · Wilmington, DEBuilt 2014 · S/N 2843783N696HJCold Rain Inc · Carleton, NEBuilt 1979 · S/N 28-8090190N696LHFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 2881629N696PGCirrus Sr22 3606 Inc Trustee · Wilmington, DEBuilt 2010 · S/N 3606N6972JBicker Farms Lllp · Tioga, NDBuilt 1976 · S/N 28-7690445N6979JImani Cameron · Lexington, KYS/N 28-7690446N697CMrc Aviation LLC · Columbia, TNS/N 0443N697CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881133N697CBPaul L W Smith Inc · Kingston, GABuilt 2010 · S/N 3693N697LHFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 2881686N697MMHarmon Aviation LLC · Oxford, MIBuilt 2008 · S/N 4692097N697NDSouth Dakota State University · Brookings, SDBuilt 2015 · S/N 4496385N697SRSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2006 · S/N 1827N6980JNulton Enterprises LLC · Johnstown, PABuilt 1976 · S/N 28-7690447N698ATNugent Inc · Indianapolis, INBuilt 2001 · S/N 4697059N698ESSund Lloyd · Kramer, NDBuilt 2022 · S/N 8609N698JMA Aviation LLC · Wilmette, ILBuilt 2025 · S/N 11038
Back to AD 2008-06-28 R1