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.

N6051CQualitair LLC Trustee · MichelstadtBuilt 2003 · S/N 0600N6052CDouble D Air LLC · Lake In The Hills, ILBuilt 2008 · S/N 3257485N6053FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020149N6053SFlying By LLC · Breckenridge, MNFirst renewal noticeBuilt 2003 · S/N 1328N6053UAtlas Vineyard Management Inc · Napa, CABuilt 2003 · S/N 0621N6057HAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1977 · S/N 28-7816216N6058FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020150N6059HOverholtzer Mark S · Salem, ORBuilt 1977 · S/N 28-7816217N6059ULt-Marine/Aviation Partners LLC · Lakeway, TXBuilt 2008 · S/N 3257493N605BGAir Carriage Inc · Chico, CABuilt 2005 · S/N 40.566N605CAUtah State University · Logan, UTBuilt 2008 · S/N 40.911N605CDFl175 Aviation Partners LLC · Sugar Land, TXBuilt 2005 · S/N 1486N605FFFf22 LLC · Scottsdale, AZS/N 2881605N605FTOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1989 · S/N 2841198N605GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881193N605JCHustler Aviation LLC · Huntsville, TXBuilt 1969 · S/N 28R-31088N605LMBst Cirrus LLC · Mooresville, NCBuilt 2017 · S/N 4530N605MHSteinberg Kenneth R · Longport, NJBuilt 2005 · S/N 1469N605RMClear Prop Aviation LLC · Palo Alto, CABuilt 2014 · S/N 4133N6063HHagerstown Flying Club · Williamsburg, INBuilt 1977 · S/N 28-7890203N6065HNoble Mark · Memphis, TNBuilt 1977 · S/N 28-7890204N6066HFlaps Inc · Cincinnati, OHBuilt 1977 · S/N 28-7890205N6069AAt Aero LLC · Wilmington, DEBuilt 1978 · S/N BB-357N6069FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020151N606CTPkck Plane LLC · Newton, MABuilt 2019 · S/N 4852N606EAOakmere Leasing LLC · Norton Shores, MIBuilt 1979 · S/N 28-7916477N606KHWood & Wood Aviation LLC · Boaz, ALBuilt 2016 · S/N 4418N606MFAtaraxia Aircraft Holdings LLC · Greenville, SCS/N 3799N606WCFlight Unlimited LLC · Smyrna, GABuilt 2004 · S/N 4697176N606ZZPiper Dreams LLC · Nantucket, MABuilt 2008 · S/N 4692062N6071BRoss Bryan L · Marion, MSBuilt 2003 · S/N 0566N6072JSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2009 · S/N 4697417N6074JFive Miles Up LLC · Sisters, ORBuilt 2009 · S/N 4697397N6076UJr Squared Aviation LLC · Lewes, DEBuilt 2008 · S/N 4692081N6077EAir Fleet Holdings LLC · Addison, TXBuilt 2022 · S/N 2881548N6077QTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 4697383N6078FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020152N6079DBird Properties LLC · Roosevelt, UTBuilt 2009 · S/N 4692104N607ARCirrus Design Corp · Duluth, MNS/N 11743N607CBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4636497N607DSNasir Rehan S · Lancaster, PABuilt 2002 · S/N 40.207N607EABlue Horizons Flying Club Inc · Perrysburg, OHBuilt 1980 · S/N 28-8116140N607EDUnimax Aviation LLC · Portland, ORBuilt 2010 · S/N 4636481N607FTFlorida Institute Of Technology · Melbourne, FLBuilt 1979 · S/N 28-7916271N607MAAllen Kelvin T Trustee · Canyon, TXBuilt 2001 · S/N 4697107N607MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2026 · S/N 40.1259N607NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 2881185N607PCCidale David R · Grand Island, NYBuilt 2005 · S/N 1624N607PTAzure Leasing LLC · Oakdale, PABuilt 1989 · S/N 2841215N607SADoctorate Holdings LLC · Sheridan, WYBuilt 2023 · S/N 9104
Back to AD 2008-06-28 R1