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.

N3360MStyer David · Pendleton, ORBuilt 1977 · S/N 28-7816339N336BWright Brothers Aero Inc · Vandalia, OHBuilt 2006 · S/N 2049N336BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2019 · S/N 2881098N336DSValiair Limited Company Trustee · Casper, WYBuilt 2004 · S/N 40.365N336HTRegistered aircraftBuilt 2019 · S/N 4801N336KTBlue Sky Worldwide LLC · Wilmington, DEBuilt 2001 · S/N 4697033N336MAHot Wings Aviation LLC · Fishers, INBuilt 2024 · S/N 28020175N336MKNorth Star Aviation Inc · Mankato, MNBuilt 2018 · S/N 2881087N336PAWingsleasing LLC · Wichita, KSBuilt 2002 · S/N 4496140N3374M74 Mike LLC · Ft Mitchell, KYBuilt 1977 · S/N 28-7890297N337BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2019 · S/N 2881099N337EPAtp Aircraft 4 LLC · Wilmington, DEBuilt 1978 · S/N 44-7995064N337FBMa Aviation Group LLC · Farmingdale, NYBuilt 2003 · S/N 2843550N337FMBrous James T Trustee · New York, NYBuilt 1997 · S/N 3449028N337GAtp Taa LLC · Wilmington, DEBuilt 2020 · S/N 2881424N337GVVenturino Lee Angelo Trustee · Kure Beach, NCBuilt 2013 · S/N 3928N337KCN337kc LLC · Wichita, KSBuilt 1985 · S/N 441-0337N337RBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 0869N338BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2019 · S/N 2881263N338CPQualitair LLC Trustee · MichelstadtBuilt 2008 · S/N 3253N338DSMission Air LLC · North Charleston, SCBuilt 2013 · S/N 40.1180N338MAHayes & Associates Inc · Teays, WVBuilt 2003 · S/N 40.298N338MKNorth Star Aviation · Mankato, MNBuilt 2019 · S/N 2881096N338PEFlying Scotchman LLC · Green Bay, WIBuilt 2026 · S/N 11237N338TXBussin' Air LLC · San Antonio, TXBuilt 2023 · S/N 9383N3396QRomanair Wdr Inc · Winder, GABuilt 1977 · S/N 28-7790455N339BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2022 · S/N 2881525N339CDMcwethy22 LLC · Woodstock, GABuilt 2004 · S/N 1107N339DTGuzauff LLC · Katy, TXBuilt 2015 · S/N 4224N339KAChenango Aviation LLC · Dallas, TXBuilt 1980 · S/N LW-339N339MAAddie Holdings LLC · Jackson, TNBuilt 2016 · S/N 4636701N339MKNorth Star Aviation · Mankato, MNBuilt 2019 · S/N 2881097N339NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2006 · S/N 28010012N339WMFlying Frenchies LLC · Naples, FLBuilt 2024 · S/N 9850N33CALrb Aviation LLC · Catawba, NCBuilt 2019 · S/N 4636748N33CFObx Boil Aviation LLC · Kitty Hawk, NCBuilt 2022 · S/N 8525N33CTThree Wing Flight School LLC · Stratford, CTBuilt 1977 · S/N 28-7890136N33ETE Fly LLC · Mckinney, TXBuilt 2025 · S/N 10739N33FRCharles L Fridge III Pc · Houston, TXBuilt 1978 · S/N LW-299N33HCSmith Christopher J · Longwood, FLBuilt 2004 · S/N 0815N33HEShelton Barry · Austin, TXBuilt 2008 · S/N 411109N33JCMurphree Matthew · San Marcos, TXBuilt 1977 · S/N 28-7890144N33JGCavu 1989 LLC · New Hope, PABuilt 2021 · S/N 5075N33LMSkymax LLC · Stanford, KYBuilt 2018 · S/N 4636732N33MWSackett Gary G · Millcreek, UTBuilt 2007 · S/N 2435N33PFNeed For Speed Aviation LLC · Charleston, SCBuilt 2007 · S/N 2572N33SUSouthern Utah University · Cedar City, UTBuilt 2017 · S/N 2368N33SYFlight Level 510 LLC · El Dorado Hills, CABuilt 2004 · S/N 40.370N33TPJt Services LLC · Wilmington, DEBuilt 2008 · S/N 411049N33TVTgbde LLC · Fort Pierce, FLBuilt 2007 · S/N 2400
Back to AD 2008-06-28 R1