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.

N698MADaher Michael P · Trabuco Canyon, CABuilt 1997 · S/N 3246096N698NDUniversity Of North Dakota · Grand Forks, NDBuilt 2026 · S/N 4496637N698SLBayside Associates LLC · Richmond, VABuilt 2017 · S/N 2355N698WMBoard Of Trustees Of Western Michigan University · Kalamazoo, MIBuilt 2024 · S/N 9914N6997JBailey Kevin R · Crown Point, INBuilt 1976 · S/N 28-7690452N6998JMt Aircraft Sales And Leasing LLC · Wilmington, DEBuilt 1976 · S/N 28-7690453N699CDFaridev LLC · White Plains, NYBuilt 2005 · S/N 1505N699DWDw Flight LLC · Columbus, OHBuilt 2005 · S/N 2843612N699GWSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1987 · S/N 3213004N699LGN699 Lg LLC · Mahtomedi, MNBuilt 1999 · S/N 2843258N699LHFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 2881687N699MDJvation LLC · Belgrade, MTBuilt 1994 · S/N 4622159N699PGBrady Richard V · Show Low, AZBuilt 2013 · S/N 4636600N699SPMa Aviation LLC · Danville, ILBuilt 1996 · S/N 3246023N699TBUS Anesthesia Consultants LLC · Chesterfield, MOBuilt 1994 · S/N 4622158N699YZLift Up Aviation LLC · Johns Island, SCBuilt 2018 · S/N 2448N69BACirrus Design Corp · Duluth, MNS/N 11771N69BWJet & Rotor Aviation LLC · Sacramento, CABuilt 1982 · S/N 34-8233087N69LVTbd Air LLC · Chatham, MABuilt 2001 · S/N 3257229N69MKFisher Jack C · Ashland City, TNBuilt 1998 · S/N 3257063N69MZHall John · Litchfield Park, AZBuilt 2007 · S/N 2700N69PJVvv Aviation Inc · Mountain View, CABuilt 2023 · S/N 9500N69PKBiofusion LLC · Fort Smith, ARBuilt 2009 · S/N 3576N69PZParagon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020182N69TZUnder The Radar LLC · Henderson, NVBuilt 2006 · S/N 2843640N69VUVincennes University · Vincennes, INBuilt 2025 · S/N 11049N69YKMetal Wholesale LLC · Bloomfield, IABuilt 2021 · S/N 5110N69ZAMoleno Capital LLC · Dallas, TXBuilt 2010 · S/N 3519N6AAGeneral Property Development LLC · Bedford, NHBuilt 2008 · S/N 411100N6BGMollica Air LLC · North Andover, MABuilt 2021 · S/N 5090N6CACra Aviation LLC · Dickerson, MDBuilt 2021 · S/N 5073N6CDAviator One LLC · Holly Springs, NCBuilt 2001 · S/N 0037N6EYCsh Aviation LLC · Sheridan, WYBuilt 2004 · S/N 41005N6JZFaith Church Of Sherman · Sherman, TXBuilt 2003 · S/N 3232003N6MPTilt Up Air LLC · Middleboro, MABuilt 2017 · S/N 4497N6NSWestern Flying Club Inc · Burlington, NCBuilt 1978 · S/N 28-7990206N6TZOut In Front Inc · Wilmington, DEBuilt 1999 · S/N 3449125N6WEHigh Flight Aviation LLC · Harwinton, CTBuilt 1993 · S/N 3213050N6WTBig Sky Flight Solutions LLC · Helena, MTS/N 411101N6XTBarrass John · Winter Garden, FLS/N 348233144N7004FSouthern Vector Aerospace LLC · Huntsville, ALS/N 28-7790176N7005Paragon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020180N70075Kennel Isaac John · Salt Lake City, UTBuilt 1976 · S/N 28-7790177N7007VTurk James H · Mesa, AZBuilt 2001 · S/N 0082N700BGSuisse Management LLC · Park City, UTBuilt 2011 · S/N 4697457N700DHGramer Air II LLC · Bloomfield Hills, MIBuilt 1974 · S/N LW-114N700FCSandlapper Aviation Of De Inc · Bennington, VTS/N 1986N700HGAerosphere LLC · Cedar City, UTBuilt 2005 · S/N 1506N700KPN700kp LLC · Melbourne, FLBuilt 2021 · S/N 2774N700PGoree John A · Iowa City, IABuilt 2004 · S/N 0791
Back to AD 2008-06-28 R1