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.

N243MSmall Hills Farms · Durham, CABuilt 1982 · S/N 24-1293N2468JJh Investments LLC · Henderson, NVBuilt 1996 · S/N 24-3391N246ATBorghi Eric C · Leonia, NJBuilt 1989 · S/N 24-3121N246BBTruman Nissley · Moberly, MOBuilt 1978 · S/N 24-0752N246JCSchultes James F Jr · Woodbury, NJBuilt 1985 · S/N 24-1557N248PVVasquez Pablo Javier Jr · El Dorado Hills, CABuilt 1991 · S/N 243221N256DDSch Aviation Inc Trustee · Sporle Kings LynnS/N 24-1080N258JTWilson Cecil · Lithonia, GABuilt 1992 · S/N 24-3252N25XXWings Of Joy Foundation · Wilmington, DEBuilt 1979 · S/N 24-0826N268ESHigh End Computing Systems Inc · Summit, NJBuilt 1990 · S/N 24-3150N2823WSmith Scot · Fayetteville, NCBuilt 1981 · S/N 24-1101N289MEWaseca Wings Inc · Waseca, MNBuilt 1990 · S/N 243197N28CEKohles Aviation LLC · Norfolk, NEBuilt 1978 · S/N 24-0554N28FYValiair Limited Co Trustee · Casper, WYBuilt 1981 · S/N 24-1219N292MPRice Kendrick Q · Philadelphia, PABuilt 1994 · S/N 243339N296DDDouglass Darrell C · Jamestown, CAS/N 24-0198N29FMJones Jonathan Paul · Pinehurst, NCBuilt 1997 · S/N 24-3406N2AMFazio Peter A · Nokomis, FLBuilt 1977 · S/N 24-0156N2CYPallante John · Manahawkin, NJS/N 24-3003N2KNSareavco LLC · Kissimmee, FLBuilt 1987 · S/N 24-3031N2RBRegistered aircraftBuilt 1981 · S/N 24-1148N2RHRene M Haas Inc · North Chatham, MABuilt 1996 · S/N 24-3376N300MConway Frank P · Sneads Ferry, NCBuilt 1978 · S/N 24-0630N300SZSpp Aviation LLC · Minot, NDBuilt 1981 · S/N 24-1108N300YBGospel Ministries International Inc · Collegedale, TNBuilt 1986 · S/N 24-3010N301JKKaminski John J · Torrance, CABuilt 1978 · S/N 24-0634N301KCRidl Kent S · West Fargo, NDBuilt 1978 · S/N 24-0414N301SPBeyond Air Llp · Burlington, NDS/N 24-1074N301TV301tv LLC · Three Lakes, WIBuilt 1982 · S/N 24-1308N305FWPetersen Ryan M · Lakewood, COBuilt 1981 · S/N 24-1112N307FWMooney Flying Club LLC · Pelican Rapids, MNBuilt 1981 · S/N 24-1155N308FWLlb Enterprises LLC · Des Moines, WABuilt 1981 · S/N 24-1212N30FMM20j LLC · Niceville, FLBuilt 1997 · S/N 24-3410N311WCIndy Aviation LLC · Dover, DES/N 24-1583N315LKnobler Michael D · Santa Monica, CABuilt 1993 · S/N 24-3293N318VPBialek Joseph · New Smyrna Beach, FLS/N 24-0996N31DLLoy David Parker · Eads, TNBuilt 1978 · S/N 24-0475N31NMBolton Philip L · Bloomington, ILBuilt 1982 · S/N 24-1334N3201GArdent Aviation LLC · Salt Lake City, UTBuilt 1978 · S/N 24-0565N3201LFowler Scott A · Lakeland, FLBuilt 1978 · S/N 24-0566N320WLAustin Mark S · Cat Spring, TXBuilt 1978 · S/N 24-0523N320WWForsythe Chad · Foresthill, CAS/N 24-3310N321KLInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 24-1102N322DMMooney Pit LLC · Noblesville, INBuilt 1993 · S/N 24-3294N322TLJubien Walter L Jr · Newport News, VABuilt 1982 · S/N 24-1265N324MCCharns Martin · Auburndale, MABuilt 1979 · S/N 24-0780N329DMMarek James E · Ozark, ALBuilt 1981 · S/N 24-1252N32JCMelton Charles Robert · Alexandria, VABuilt 1977 · S/N 24-0120N332DBFulton Flying Club Inc · North Canton, OHBuilt 1980 · S/N 24-0986N332JJBialek Joseph · New Smyrna Beach, FLBuilt 1982 · S/N 24-1344
Back to AD 95-26-16 R1