OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,007

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.

N313CZBuckley Robert L Jr · Castle Rock, COBuilt 2009 · S/N 71122N313DDunlap Charles R · Pima, AZBuilt 2013 · S/N 299A-320-61N313DCRegistered aircraftBuilt 1978 · S/N 28-7816591N313DDAlpine Air Aviation LLC · West Haven, UTBuilt 2001 · S/N 3226N313EJBohrman Ken C · Pebble Beach, CABuilt 2010 · S/N 40504N313GALittle Craig · Oregon City, ORBuilt 2000 · S/N 333AN313GTRegistered aircraftBuilt 2016 · S/N 92132N313GWWright George E Jr · Homestead, FLBuilt 1956 · S/N 18-5260N313HTKiernan Bernard J · Hopewell Junction, NYS/N 1N313JVScholze Jerome V · Anchorage, AKBuilt 2014 · S/N 003N313KDOdonnell Daniel Gordon · Plymouth, MABuilt 1975 · S/N 17702353N313LNBazal Jared W · Castle Rock, COS/N 28-2571N313MAAbrams David · Holmdel, NJBuilt 1998 · S/N 18280238N313MTNguyen Nhu-An T · Parkville, MDBuilt 1977 · S/N 356-77N313MWClover George S · Catheys Valley, CABuilt 1959 · S/N 24-1637N313PKCampbell James D · Palo Alto, CABuilt 1976 · S/N 32R-7780037N313PSHier Richard T · Lambert, MTBuilt 2002 · S/N 2002-1N313RBGlenn Simmons LLC · Point Lookout, NYBuilt 1978 · S/N 32R-7887157N313RMVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N T18208456N313RTBuechler James K · The Villages, FLBuilt 2012 · S/N 41043N313RVBusbea Shawn · Conway, ARBuilt 2008 · S/N 11366N313TAD A Consulting Inc · Orlando, FLBuilt 1977 · S/N AA5A0312N313TDCfi Care Inc · Oxford, CTBuilt 2014 · S/N 72402N313WFSalisbury Peter R · White Bear Lake, MNBuilt 2001 · S/N 879-2001N313WMKafer Mark T · Colleyville, TXBuilt 1965 · S/N 28-2678N313ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881640N31400Druidia Group LLC · Downingtown, PABuilt 1978 · S/N 28-7816557N31401Fox Flying Club Inc · Wheaton, ILBuilt 1978 · S/N 28R-7837234N31407Montei Nicholas P · Caro, MIS/N 32-7840130N3140TSuggs Helen T · Jacksonville, FLBuilt 1967 · S/N 17700440N3140ZHoyt Kenneth B · Marion, KSBuilt 1959 · S/N 22-7084N3141EPower City Aviation Inc · Hazleton, PABuilt 1978 · S/N 17271449N3141PDakota Aero Inc · Wilmington, DEBuilt 1957 · S/N 23-1069N3141TN3141t LLC · Saint Johns, MIBuilt 1967 · S/N 17700441N3141ZKumbier Jenene R · Maxwell, IABuilt 1959 · S/N 22-7086N31429Leonard Gordon A · Anchorage, AKBuilt 1991 · S/N 20649N3142BScaled Composites LLC · Mojave, CABuilt 1982 · S/N 1N3142RSharp Media Group LLC · Kansas City, MOS/N R18201117N3142TTri State Airmotive LLC · Berryville, ARS/N 17700442N3143CAuron Chris · Naples, FLBuilt 1977 · S/N 1103N3143DRoland Ann J · Woodland, CAS/N SA1025-75013LFN3143WLoyd Marion S · Dumas, ARBuilt 1991 · S/N 1920N3143ZChristian Edward A · Evans, GABuilt 1959 · S/N 22-7088N31445Kuther Kenneth J · Nezperce, IDS/N 2176N31449Peterman Keith A · Taylorsville, KYBuilt 1978 · S/N 2178N3144PEurohaus LLC · Phoenix, AZBuilt 1957 · S/N 23-1075N3144TKinsfather John D · Fowler, CABuilt 1967 · S/N 17700444N3144ZWasilowski Richard P · Arlington, WABuilt 1959 · S/N 22-7089N31453Kuhlig Clemens C · Hobe Sound, FLBuilt 1979 · S/N 2189N31456Flying Time LLC · Jenks, OKBuilt 1979 · S/N 2190
Back to AD 87-10-06 R1