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.

N747SWJet Air Inc · Iowa City, IAS/N 1370N747TGValiair Ltd Co Trustee · Casper, WYBuilt 2003 · S/N 0718N747THPhilburto Consulting Ltd · Telluride, COBuilt 2006 · S/N 4636392N747TTDogbolter Aviation LLC · Milwaukee, WIBuilt 2003 · S/N 0481N747VPSavfar Aviation Inc · Wilmington, DEBuilt 2005 · S/N 41092N747XTEp747xt LLC · Miamisburg, OHBuilt 2006 · S/N 4697261N7481JShaffer John W · Titusville, PABuilt 1968 · S/N 28R-30839N7489JMayer Thomas D · Medford, ORBuilt 1968 · S/N 28R-30849N748CDPinkgg LLC · Marathon, FLBuilt 2001 · S/N 0086N748PASkywest Leasing Inc · St George, UTBuilt 2019 · S/N 2881190N748RAAri Ben Aviator Inc · Fort Pierce, FLBuilt 1988 · S/N 2841035N7492JClassic Air Aviation LLC · Mesa, AZBuilt 1968 · S/N 28R-30852N7493JRegistered aircraftBuilt 1968 · S/N 28R-30854N7495JDreamair LLC · Fargo, NDBuilt 1968 · S/N 28R-30856N7498JSawyer Steven A Md · Hampton, GABuilt 1968 · S/N 28R-30860N749CDGoat Island Films Inc · Covina, CABuilt 2001 · S/N 0099N749DAJoseph Fornara · Chalfont, PABuilt 2022 · S/N 8623N749DSUtah Valley University · Orem, UTBuilt 2007 · S/N 40.749N749JBSkylands Group LLC · Wilmington, DES/N 41511N749PASkywest Leasing Inc · St George, UTBuilt 2019 · S/N 2881244N749PGSfly LLC · Dubuque, IABuilt 2005 · S/N 1339N749RCChadwick Michael · Reston, VABuilt 2004 · S/N 1044N74AGMarion Pilots Club Inc · Marion, INBuilt 2002 · S/N 0428N74ARHickory Lane Corp · Farmingdale, NYBuilt 2022 · S/N 8594N74BLSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2005 · S/N 1484N74CWN74cw LLC · Sandy, UTBuilt 2025 · S/N 10655N74EEFarr Aviation LLC · Tullahoma, TNBuilt 1999 · S/N 4636215N74FBBurns Fred J · Hampstead, NCBuilt 2002 · S/N 0257N74KVAerodhooth Kilo-Victor LLC · Acton, MABuilt 2024 · S/N 10049N74LM74lm Travel LLC · Austin, TXBuilt 2011 · S/N 4636516N74MLHowie Aviation LLC · Bellaire, TXBuilt 2020 · S/N 4982N74SACloud Aviation LLC · Lagrange, OHBuilt 2006 · S/N 1994N74SWUtah State University · Logan, UTBuilt 2007 · S/N 40.828N74WTOrriserv LLC · Prior Lake, MNBuilt 1981 · S/N 34-8133253N74WWWhitewind Co · Windsor Locks, CTBuilt 1999 · S/N 3246144N75005Spiesman William J · Austin, TXBuilt 1976 · S/N 28-7690279N7500JNour George E · Eatonton, GAS/N 28R-30863N7501JSholl Douglas Alan Jr · Williams, AZBuilt 1968 · S/N 28R-30864N7502JIrvin H Hugh · Salina, KSBuilt 1968 · S/N 28R-30866N75047Dunlop Vance Trustee · Keizer, ORBuilt 1976 · S/N 28-7690285N75048Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1976 · S/N 28-7690286N75049Christie Brian L · Irvine, CABuilt 1976 · S/N 28-7690287N75059Markiewicz Mark J · Kokomo, INBuilt 1976 · S/N 28-7690289N75082Up And Away Aviation LLC · Poughkeepsie, NYBuilt 1976 · S/N 28-7690290N75084Wadas Burton J · Hudson, NHBuilt 1976 · S/N 28-7690292N750AURunamuck LLC · New Orleans, LABuilt 2025 · S/N 4496619N750CDPitmaster Pilot LLC · Lubbock, TXS/N 0060N750GVTrak Inc · Gainesville, GABuilt 2000 · S/N 3257171N750KAN750ka LLC · Wilmington, DEBuilt 1977 · S/N BB224N750NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2018 · S/N 2881030
Back to AD 2008-06-28 R1