OpenAirDocs.org
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.

N9162NMann Aviation LLC · Wilmington, DEBuilt 1998 · S/N 24-3421N9163QWebb John L · Elgin, TXBuilt 1998 · S/N 24-3422N918THLayton James L · Carrollton, GABuilt 1992 · S/N 24-3258N91CPBeaty Christina T · Washington, DCS/N 24-0694N9201AN9201a LLC · Oro Valley, AZFirst renewal noticeBuilt 1978 · S/N 24-0610N9201MT-Smht LLC · Shoals, INBuilt 1978 · S/N 24-0611N9201TEisenhardt Scott · Milwaukee, WIBuilt 1978 · S/N 24-0615N923DFRosene Norm · Chico, CABuilt 1979 · S/N 24-0908N925JHLightning Air Group LLC · Fort Worth, TXBuilt 1994 · S/N 24-3329N9269NLevenfeld Yuri · Brookhaven, GABuilt 1978 · S/N 24-0751N926DSJsrg Aviation LLC · Incline Village, NVBuilt 1981 · S/N 24-1236N926KRNewton Christopher F · Kill Devil Hills, NCBuilt 1989 · S/N 24-3120N927ALBravo II Sierra LLC · Dallas, TXBuilt 1980 · S/N 24-1048N928KCBaldasaro Bonnie B · Clifton Park, NYBuilt 1988 · S/N 24-1678N92DBBroder Alan H · Port St Lucie, FLBuilt 1978 · S/N 24-0633N92ELTrue Course Aviation LLC · Flower Mound, TXBuilt 1992 · S/N 24-3273N9354TJb Aero LLC · Fairview, PABuilt 1980 · S/N 24-1065N9367VKolisnyk Christopher D · Winterville, GABuilt 1980 · S/N 24-1066N937BPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1987 · S/N 24-3046N93KSRose Jeffrey A · Cranfills Gap, TXBuilt 1989 · S/N 24-3127N94814Lint Michael G · Sacramento, CABuilt 1980 · S/N 24-1062N94REMckinney Charles A · Indiana, PABuilt 1980 · S/N 24-1071N952RHKilo Alpha Flights · Long Beach, CABuilt 1981 · S/N 24-1177N9609URykala Martha E · Hayward, CABuilt 1980 · S/N 24-1067N9656GPappas Ryan Conner · Ocean View, DES/N 24-1070N9680GRegistration Pending · Boerne, TXRegistration pendingBuilt 1980 · S/N 24-1072N96827Zehner Mike W · Boise, IDBuilt 1980 · S/N 24-1073N969RSShawn Richard N · Bradford, RIBuilt 1979 · S/N 24-0818N96CBNine Six Charlie Bravo LLC · Aspen, COBuilt 1994 · S/N 24-3346N96ERGunn Sean M · Colorado Springs, COBuilt 1993 · S/N 24-3308N96KSMower Douglas D · Cedar Ridge, CAS/N 24-3361N97136Lufertarg Group Inc · Mineola, NYBuilt 1980 · S/N 24-1061N975RJDavison Michael J · Big Rapids, MIBuilt 1982 · S/N 24-1268N97642Bravo Zulu Aviation Inc · Chattanooga, TNBuilt 1982 · S/N 24-1343N9777FStubstad Garrett · New Town, NDBuilt 1981 · S/N 24-1078N97983Wintill Gregory S · Roanoke, TXBuilt 1982 · S/N 24-1345N97DMRegistered aircraftBuilt 1997 · S/N 243409N981SMMcintosh Steve A · Jefferson City, MOBuilt 1994 · S/N 24-3338N984TDJones Joseph D · Broken Arrow, OKBuilt 1985 · S/N 24-1551N984VWSkyhawks Inc · Westminster, COBuilt 1984 · S/N 24-1458N98989Aurellium Corp · Bettendorf, IAS/N 24-1088N9899ARhodes William D Jr · New Tazewell, TNBuilt 1981 · S/N 24-1089N989PMGasper Michael J · Malvern, OHBuilt 1989 · S/N 24-3113N989TGSouthern Airmotive Inc · Texic, NMBuilt 1980 · S/N 24-1054N98BRGrant Brian · Durham, NCBuilt 1995 · S/N 24-3356N9909ESmith C Gary · Gretna, LABuilt 1982 · S/N 24-1346N9918GRoettger Investment Corporation · Evansville, INBuilt 1981 · S/N 24-1093N9930SGpm Flyers LLC · Colleyville, TXBuilt 1982 · S/N 24-1347N9932SNeboschick Ashley B · North Charleston, SCBuilt 1981 · S/N 24-1096N993JBLarson John H Trustee · Bend, ORBuilt 1993 · S/N 24-3297
Back to AD 95-26-16 R1