OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,495

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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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.

N74FBBurns Fred J · Hampstead, NCBuilt 2002 · S/N 0257N74FXGeorgia Screen Rooms LLC · Wilmington, DEBuilt 2007 · S/N L2K-283N74GSBaron 55 Inc · Lewes, DEBuilt 2006 · S/N TH-2158N74HJRegistration Pending · Sheridan, WYRegistration pendingBuilt 1974 · S/N 340-0333N74JGBurkett Christopher · Las Vegas, NVBuilt 1990 · S/N 90-301011N74JSHoots Husky LLC · Helena, MTBuilt 1980 · S/N 18504139N74JWWells Janice M · Chandler, AZBuilt 1973 · S/N 73-30568N74LCLee County Sheriffs Office · Ft Myers, FLBuilt 1972 · S/N 21059755N74LECarnes Eddy A · Uvalde, TXBuilt 1989 · S/N CE-1310N74MFCarl Raymond Baker LLC · Brenham, TXBuilt 1981 · S/N TJ-397N74MMFief Ron C · Creede, COBuilt 1974 · S/N 21060375N74MTKopair LLC · Saint Louis, MOBuilt 2000 · S/N EA-659N74PBBaranko Peter A · Meridian, IDBuilt 1981 · S/N 414A0828N74PSOrion Works Inc · Denali Park, AKBuilt 1973 · S/N U20601894N74RMGrimes Taylor · Odessa, TXBuilt 1976 · S/N 21061694N74SKKoontz Construction Inc · Livingston, MTBuilt 1966 · S/N D-8148N74TGLf Operations LLC N74tg Series · Coalgate, OKBuilt 1968 · S/N E-3N74TRAnderson Chercial · Essex, MDS/N 74-30713N74TWWichmann Gregory Scott · Las Vegas, NVBuilt 1980 · S/N 18504043N74USTwo Three Air LLC · Orlando, FLBuilt 1974 · S/N E-574N74WJVicari Aviation LLC · Harvey, LABuilt 1988 · S/N E-2458N74WMTurnage Leon G · Weatherford, TXBuilt 1975 · S/N TH-653N7500NReiter Ken · Plano, TXBuilt 1968 · S/N E-41N7501NBeckner Gregory · Houston, TXBuilt 1968 · S/N E-42N7504NReynolds Rex J · Bloomington, INBuilt 1968 · S/N E-37N7505NMiller Mary Lou · Dothan, ALBuilt 1968 · S/N E-36N7508QZulu Hours LLC · Moneta, VABuilt 1969 · S/N 310Q0008N750DBBearpack LLC · Boulder City, NVBuilt 2005 · S/N 29-0355N750DCHills Alan · Youngsville, NCBuilt 1997 · S/N 29-0123N750DRLukowski Zachary L · Gainesville, FLBuilt 1975 · S/N 310R-0064N750HKalj1884 LLC · Lewes, DEFirst renewal noticeBuilt 2017 · S/N TH-2477N750JFHamontree Gerry · Ellsworth, KSBuilt 1991 · S/N CE-1633N750NTEle Motorsports LLC · Dover, DEBuilt 1978 · S/N U20604230N750PCMarilyn Merlot LLC · Kalispell, MTBuilt 1972 · S/N 340-0189N750PMWunsch John D · Anchorage, AKBuilt 1975 · S/N 18502843N750RGHmcs LLC · Charlotte, NCS/N 12044N7513NAspiras Dionisio O Jr · Rosharon, TXBuilt 1968 · S/N E-47N7516NDelis Balentine Jeremy W · Phoenix, AZBuilt 1968 · S/N D-8846N7516QS Flight LLC · Evergreen, COBuilt 1972 · S/N 310Q0530N7517NEagle Squadron Inc · The Villages, FLBuilt 1968 · S/N D-8845N7518NHarper Darin M Trustee · Independence, ORBuilt 1968 · S/N D-8843N751APAmdent Air LLC · Wyomissing, PABuilt 2005 · S/N 1446N751CAHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0217N751PPPlane White Corporation · Sunriver, ORBuilt 1999 · S/N E3260N7521RWatchill LLC · Traverse City, MIBuilt 1965 · S/N D-7835N7523NSickels Henry C · El Cajon, CABuilt 1968 · S/N E-49N7525NFityfityink LLC · Troy, OHBuilt 1968 · S/N E-52N7526NJr Aircraft LLC · Lexington, KYBuilt 1968 · S/N E-53N7527NParadise Prop LLC · Cedarburg, WIBuilt 1968 · S/N E-54N752SBKevu Aviators LLC · Maryville, MOBuilt 2003 · S/N 0773
Back to AD 86-13-04 R3