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.

N417TABrickler Alexander J · Tallahassee, FLBuilt 2002 · S/N 0241N417WDWheels Down LLC · Oklahoma City, OKBuilt 2014 · S/N 4162N417ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881670N4180ARgb Air Services Inc · Corpus Christi, TXBuilt 2002 · S/N 4697151N4180WHodson Bruce E · Madbury, NHBuilt 2000 · S/N 2843408N4181DN4181d Corp Trustee · Wilmington, DEBuilt 1998 · S/N 3246113N4181MHayden Christopher J · Old Orchard Beach, MEBuilt 1998 · S/N 2843120N4182AHidden Amphibians LLC · Dover, DES/N 3257182N4182DBarnhart David H · San Antonio, TXBuilt 2000 · S/N 2843406N4182JBialecki Aviation Leasing LLC · Getzville, NYBuilt 2001 · S/N 2842118N4182LHorizon Dreams LLC · Homer, GABuilt 2001 · S/N 2843416N4182NElon Aviation LLC · Burlington, NCS/N 2843380N41838Baker Arthur M II · Mundelein, ILBuilt 2000 · S/N 3246171N4183DChallenge Aviation · Orange, CAS/N 3257203N4183WTate Aviation LLC · Camden, DEBuilt 2000 · S/N 3257183N41847Saratoga N41847 LLC · Wilmington, DES/N 32-57165N41849Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2000 · S/N 3449179N4184TMullys Equipment Leasing LLC · Castle Pines, COBuilt 2001 · S/N 2843418N4184VUpper Jets Maintenance LLC · Miami, FLBuilt 2001 · S/N 2843420N4184XM&N Aviation LLC · Carolina Beach, NCBuilt 2001 · S/N 3257200N4185LWdw Aviation Leasing Inc · Knoxville, TNBuilt 2000 · S/N 4697025N4185WJames William S · Orange Park, FLBuilt 2001 · S/N 2843417N4185XWjw Transport Inc · Hampshire, ILBuilt 2000 · S/N 3257195N41862Shutter Up Aviation LLC · Lake Clarke Shores, FLS/N 3246178N41866Racy Equipment Leasing LLC · Tucson, AZBuilt 2000 · S/N 3257177N4186N86 Aviation LLC · Katy, TXS/N 2843411N41874Tailwinds Leasing LLC · Missoula, MTBuilt 1999 · S/N 4636230N4187DArthur Robert · Redlands, CAS/N 3257197N4187HMcalister Aviation LLC · Greenwood, ARBuilt 2000 · S/N 3257196N4187QAggie80 Air LLC · Richmond, TXBuilt 2001 · S/N 3257214N4188ASky Magic LLC · Helena, MTBuilt 2000 · S/N 4636296N4188DMachine Leasing · Kent, WABuilt 1999 · S/N 4636220N4188HAir Thacker LLC · Wilmington, DES/N 3246181N4188TBird Acquisition LLC · Phoenix, AZBuilt 1998 · S/N 2843124N4189APelton Ag Inc · Burdett, KSBuilt 2003 · S/N 3255007N4189UElectric Power Systems Inc · North Logan, UTBuilt 2007 · S/N 40.768N418BCFlying Beep LLC · Athens, GABuilt 2016 · S/N 4372N418CDWingsleasing LLC · Wichita, KSBuilt 2026 · S/N 11328N418DE2 Sierra Aviation LLC · Meridian, IDBuilt 2019 · S/N 2498N418DZDeman Richard · Nyack, NYBuilt 2013 · S/N 2236N418HPPonashomu LLC · Reston, VABuilt 2009 · S/N 4697418N418JCWalker Richard A · Omaha, NEBuilt 2004 · S/N 1132N418MLLloyd Morty C · Apison, TNBuilt 2006 · S/N 1781N418PASkywest Leasing Inc · St George, UTBuilt 2000 · S/N 2843414N418RMWind Sock Aviation LLC · Lancaster, KYBuilt 2005 · S/N 1719N418TJFive Star Family Aviation LLC · Yorkville, ILBuilt 1977 · S/N 28-7890086N4190E4190e LLC · Tucson, AZBuilt 2000 · S/N 3257172N4198FRal Aviation LLC · Trumbull, CTBuilt 1976 · S/N 28-7790006N419AMDymond Property Investments LLC · Libertyville, ILBuilt 2005 · S/N 40.570N419CDRsk Aviation LLC · Midland, MIBuilt 2005 · S/N 1377
Back to AD 2008-06-28 R1