AD 95-26-16 R1

Registered aircraft · 1,406

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:95-26-16-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:95-26-16-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.

N5816WQin David · La Verne, CAS/N 24-1586N5817AMarceau Michelle · Spofford, NHS/N 24-1656N5817TSnow Robert I · New Caney, TXBuilt 1988 · S/N 24-1654N584CMBurns Timothy R · Eighty Four, PABuilt 1978 · S/N 24-0544N597CAWest Wind Farm Inc · Camarillo, CABuilt 1979 · S/N 24-0784N597MBBrandon Air LLC · Valley Stream, NYBuilt 1983 · S/N 24-1391N598BGSamuel James · College Station, TXBuilt 1995 · S/N 24-3371N60GZAbl Aviation Inc Trustee · Wilmington, DEBuilt 1987 · S/N 24-3035N60RPMartin Rolf M · Wellsburg, NYBuilt 1980 · S/N 24-1000N611PSPc Simonton Egineering LLC · Greensboro, GAS/N 24-1278N616RLDeeb David Antony · Shelton, CTBuilt 1981 · S/N 24-1159N616SMDoo Dah Inc · Wilmington, DEBuilt 1990 · S/N 24-1691-14N6188ANash Corey · Spring, TXBuilt 1977 · S/N 240265N61YNDonovan Thomas · Spring Hill, FLS/N 24-3320N6201FJohnson Norman E · Ellijay, GABuilt 1978 · S/N 24-0589N6201YSorenson Andrew · Pickens, SCBuilt 1978 · S/N 24-0594N6227ZJet Green Aviation LLC · Terryville, CTBuilt 1990 · S/N 24-3187N622DXChang Daniel H · La Crescenta, CABuilt 1979 · S/N 24-0851N63BSPfinx LLC · Chapel Hill, NCBuilt 1992 · S/N 24-3286N63GMBmi Aviation LLC · Hallandale Beach, FLBuilt 1990 · S/N 24-3182N641CKrause Michael R · Sugar Land, TXBuilt 1980 · S/N 24-0973N644DDArfvidsson Emil · Mountain View, CABuilt 1978 · S/N 24-0664N64SZTotal Aircraft Management Inc · Acworth, GABuilt 1990 · S/N 24-3157N655FTFord Charles C · Godfrey, ILBuilt 1990 · S/N 24-1695-14N657FTNeal Randy W · Johns Creek, GABuilt 1992 · S/N 24-3268N65EEEssler Kim L · Garrison, NDBuilt 1978 · S/N 24-0569N65PMKummer Mark · Hayden, IDBuilt 1982 · S/N 24-1312N6684UFowler Kenneth G · Newport, TNBuilt 1976 · S/N 24-0036N66HMRegistered aircraftBuilt 1981 · S/N 24-1182N672WTWhiskey Tango Aviation LLC · Jasper, GABuilt 1977 · S/N 24-0267N676RJCrawford Charles Eldridge · Eastvale, CABuilt 1982 · S/N 24-1323N68AGDelucia Dennis DBA · Franklin, PABuilt 1997 · S/N 243404N696GSTriple Whiskey LLC · Lubbock, TXBuilt 1983 · S/N 24-1403N69DLIndy Air Sales LLC · Anderson, INS/N 24-0363N69LNValiair Limited Co Trustee · Casper, WYBuilt 1979 · S/N 24-0764N700CROneglia Francis G · Hawthorne, FLBuilt 1996 · S/N 24-3383N700CWDelta Sierra Aviation LLC · Wills Point, TXBuilt 1980 · S/N 24-1055N700TPCreedon Robert A · Lompoc, CABuilt 1994 · S/N 24-3322N707JLCanova Frederick M · Delray Beach, FLBuilt 1994 · S/N 24-3331N707LTSlater Timothy · Santa Rosa, CAS/N 24-1167N707RJSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1990 · S/N 243173N713JADesert Sealants Corp · Queen Creek, AZBuilt 1984 · S/N 24-1434N716JRegistered aircraftBuilt 1989 · S/N 24-3119N717BSTla Inc · Middletown, DEBuilt 1977 · S/N 24-0192N7201HMcclure Richard A · Edna, TXBuilt 1978 · S/N 24-0597N7201POrillac Natalie · Doral, FLBuilt 1978 · S/N 24-0599N7201VCompass Rose Aviation LLC · Fort Myers, FLS/N 24-0600N7201XMathews Daniel R · Vallejo, CABuilt 1978 · S/N 24-0601N720TSSpencer David T · Dayton, OHBuilt 1979 · S/N 24-0854N723LPDaly Robert · Plainview, NYBuilt 1994 · S/N 24-3343
Back to AD 95-26-16 R1