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.

N201YTJet Dawg Aviation LLC · Okeechobee, FLBuilt 1977 · S/N 24-0176N201YVMay Richard B · Mammoth Lakes, CABuilt 1978 · S/N 24-0528N201ZCavu Holdings LLC · Medon, TNBuilt 1978 · S/N 24-0542N201ZBBrowne Michael T · Ada, OKBuilt 1978 · S/N 24-0415N201ZDFlight Eval LLC · Flagler Beach, FLBuilt 1978 · S/N 24-0749N201ZESoeby Paul R · Walhalla, NDBuilt 1978 · S/N 24-0638N201ZFForever Aviation LLC · Houston, TXBuilt 1978 · S/N 24-0650N201ZGHaugen Mark K · Newhall, CABuilt 1978 · S/N 24-0640N201ZHBailey Michael D · Dover, FLS/N 24-0535N201ZLDressler David C · Mission Viejo, CABuilt 1978 · S/N 24-0536N201ZNJp Martin Service LLC · Hialeah, FLBuilt 1978 · S/N 24-0537N201ZQReber William T · Terrace Park, OHBuilt 1978 · S/N 24-0539N201ZRYost Robert L · Bridgeport, WVBuilt 1978 · S/N 24-0540N201ZTHn Journey LLC · Lewes, DEBuilt 1978 · S/N 24-0543N201ZVLeung Michael H · Millstone Township, NJBuilt 1978 · S/N 24-0546N201ZWHoward Richard A · Venice, FLBuilt 1981 · S/N 24-1194N201ZYFlight Associates Inc · Malabar, FLS/N 24-0551N201ZZSky West Aviation Inc Trustee · Albuquerque, NMS/N 24-0745N202DCThornton Dana S · Edgartown, MAS/N 24-0013N202MGCoast To Coast LLC · Branson West, MOS/N 24-1630N202PCLowell Bret I · Aurora, COBuilt 1981 · S/N 24-1086N204DPDavid Perry LLC · Oklahoma City, OKBuilt 1979 · S/N 24-0891N204MMAvest Ltd · Hilltop Lakes, TXS/N 24-0718N205ADWarner John E · West Redding, CTS/N 24-3037N205AEBerry Alan J · Danvers, MAS/N 24-3043N205CBBusse Christopher K · Leo, INS/N 24-0983N205CCHinn Terry A · Hot Springs, SDS/N 24-3044N205CSFillwock Bryan T · Saint Joseph, MIBuilt 1977 · S/N 24-0223N205DAero America Holdings LLC · Indianola, IAS/N 24-3005N205DCPocohantas Holdings LLC · Annapolis, MDBuilt 1986 · S/N 24-3004N205GIntegrity Aero LLC · Boerne, TXBuilt 1987 · S/N 24-3038N205HHayes Manufacturing · Parsons, TNBuilt 1986 · S/N 24-3006N205HBMattes Michael Alan · Sherman Oaks, CABuilt 1977 · S/N 24-0288N205JBmr Aviation LLC · Wilmington, DEBuilt 1986 · S/N 24-3002N205JJUpchurch Howard L · Pikeville, TNS/N 24-3053N205JSHollenberg Randall W · Houston, TXS/N 24-3001N205KDBats Aero LLC · Missoula, MTBuilt 1986 · S/N 24-3017N205KKBrignac Valmon Anthony III · Raleigh, NCBuilt 1987 · S/N 24-3054N205LLStemple Jasper Forest · Kalispell, MTS/N 24-3055N205MESf Imports LLC · Bluffdale, UTBuilt 1990 · S/N 24-3161N205MGGanter Berthold H · Woodside, CABuilt 1987 · S/N 24-3025N205MHIsmail Ahmad · Richmond, VAS/N 24-3026N205MKCloudskipper Inc · Salisbury, MDBuilt 1987 · S/N 24-3029N205MNCubbage Mark J · Tucson, AZS/N 24-3019N205MPSadler Ryan T · Alameda, CABuilt 1987 · S/N 24-3032N205NHuff Thomas W · West Melbourne, FLBuilt 1987 · S/N 24-3030N205PLQuinones Luis I · Gaithersburg, MDBuilt 1987 · S/N 24-3020N205PPBelai E Enterprise LLC · Burleson, TXS/N 24-3061N205QQSundhagen Construction Inc · Saint Ignatius, MTS/N 24-3069N205RGKeating Kevin C · Asheville, NCBuilt 1988 · S/N 243078
Back to AD 95-26-16 R1