OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 71,998

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:87-10-06-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:87-10-06-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.

N113BCBass William E · Anchorage, AKBuilt 1996 · S/N 001N113BMAcme Finance LLC · Flagstaff, AZBuilt 2003 · S/N 60467N113BPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2004 · S/N 4636363N113CCBowman Stephen L · Palm Bay, FLS/N 5264N113CDDowning Charles E · West Melbourne, FLBuilt 1998 · S/N 001N113CJMarshall Joshua · Chuckey, TNBuilt 1979 · S/N R18201076N113CKMorgan Joel E · Mcalester, OKBuilt 2003 · S/N 22378N113DDLane Michael D · Fruitvale, TXBuilt 2000 · S/N 379N113DLDiamond Aaron M · Ramsey, NJBuilt 1979 · S/N 1N113DRCalifornia In Nice Inc · San Jose, CABuilt 1975 · S/N 17265961N113EJIxi LLC · West Bloomfield, MIBuilt 1976 · S/N 28-7715075N113FCDistributed Motion LLC · Sandpoint, IDBuilt 1969 · S/N M-1229N113FSHallahan Robert J · Central Square, NYBuilt 1974 · S/N 17262996N113GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881455N113HMAkins Tal M · Register, GABuilt 1976 · S/N 32-7640084N113HPState Of Ohio · Columbus, OHBuilt 2002 · S/N 18281159N113JBMcdonald Aviation Inc · Knoxville, TNBuilt 1960 · S/N 27-226N113JCMcdonnell Bryant E · Boulder, COBuilt 1982 · S/N 28-8211027N113JGTaveniku Mikael · Painted Post, NYS/N DM0113N113JJRendleman Robert T · Murphysboro, ILBuilt 2000 · S/N 858-2000N113JKBusciglio Daren A · Tampa, FLBuilt 2009 · S/N 21369N113JRGrant Jose A · Jefferson, GABuilt 1975 · S/N M-1615N113JSSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1992 · S/N 3134N113JWGrass Roots Aviation LLC · Bend, ORBuilt 2004 · S/N RV623839N113JYFreeman Alan M · San Antonio, TXS/N 482RN113KCGolden Valley LLC · Missoula, MTBuilt 2018 · S/N 41573N113KRIal Corp · Lewes, DEBuilt 1974 · S/N 28-7415211N113MAMyllyla Ray J · Woodland Hills, CABuilt 1999 · S/N 304N113MEButler Robyn L · Vale, ORS/N 909-76N113MSFly2walk LLC · Loveland, COBuilt 1996 · S/N 1217-96N113MVRettig Air LLC · Riverside, CABuilt 2003 · S/N 2193N113MXN113mx LLC · Redding, CAS/N 002N113NShaw Brandon L · Juneau, AKBuilt 1998 · S/N 1422N113PCProp & Jet Air Museum Inc · Romoland, CABuilt 1982 · S/N 1N113PJLang Carl · Harper, TXBuilt 2003 · S/N 9957CCN113PVVaneau Philip M · Kerrville, TXBuilt 1987 · S/N DENTON GIVENS 1N113RVMason Chance L · Elwood, INBuilt 1988 · S/N 1029N113SJGlumac Stanley Jr · Grindstone, PABuilt 1993 · S/N 21400N113SWFargo Jet Center LLC · Fargo, NDBuilt 1977 · S/N 28-7890298N113TLKramer David P · Lebanon, TNBuilt 2003 · S/N T18208219N113TRBell Thomas E · Henniker, NHBuilt 1976 · S/N 32R-7680207N113UDRv8rs Anonymous LLC · Cincinnati, OHBuilt 2002 · S/N 80459N113VGN113vg LLC · Princeton, NJBuilt 1993 · S/N 2391N113WYRyals Barry · Rhine, GABuilt 1974 · S/N 28R-7535055N114Cooper Michael D · North Turner, MEBuilt 1954 · S/N 18-3937N11402Mcdowell Charles R II · South Charleston, WVBuilt 1973 · S/N 15075391N1140JGardner John D · Tallahassee, FLBuilt 1974 · S/N 140N1140PCromley Amanda J · Lewisburg, PABuilt 1955 · S/N 23-152N1140XReaper LLC · Britton, MIBuilt 1975 · S/N 32-7540147N11414Van Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N T18208413
Back to AD 87-10-06 R1