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.

N205RJBrickey Thomas J · Loveland, OHBuilt 1979 · S/N 24-0774N205RLAlcott Thomas J · Jacksonville, ILBuilt 1987 · S/N 24-3022N205RSGansta Of Love LLC · Moorpark, CABuilt 1979 · S/N 24-0797N205RWGarratt Tyler Trustee · Carlsbad, CAS/N 24-3052N205SJudson Alexander · Hermitage, TNS/N 24-3014N205SERecreation Activity Club Inc · Bloomfield Hills, MIS/N 24-3051N205SSAir Turbo LLC · White, GAS/N 24-3060N205TGLe Garrec Jean-Dominique M · Pittsburgh, PABuilt 1987 · S/N 24-3041N205UGoro Sky Aircraft LLC · Lino Lakes, MNS/N 24-3036N205UUTailwind Blue LLC · Lakewood, COBuilt 1988 · S/N 24-3067N205VVAawca Wings LLC · Augusta, MIBuilt 1988 · S/N 24-3068N20JXWorld Wide Air & Sea Inc · Wilton, NHBuilt 1990 · S/N 24-3204N20PWWingnuts Aviation Inc · Franklin, INBuilt 1979 · S/N 24-0900N210RHJeremiahs International Trading Co Inc · Saint Petersburg, FLBuilt 1982 · S/N 24-1301N210WECross Services LLC · Wilmington, DEBuilt 1994 · S/N 24-3352N211PDCaylor David Lynn · Newnan, GABuilt 1990 · S/N 24-1703-14N211ZNAllen Michael J · Rescue, CABuilt 1985 · S/N 24-1535N212JHHunter James A · Elizabeth City, NCBuilt 1978 · S/N 24-0625N2131ESchuman William C II · Poplar Grove, ILBuilt 1997 · S/N 24-3401N213CSAeromarine Airways Inc · Miami, FLBuilt 1978 · S/N 24-0529N2146XGalloway Robert L III · Cypress, TXBuilt 1997 · S/N 24-3413N2148CLarsen Timothy · Marietta, GABuilt 1997 · S/N 24-3405N214JC214 Mooney LLC · Boca Raton, FLBuilt 1978 · S/N 24-0706N2155PRegistered aircraftBuilt 1998 · S/N 24-3430N217RWBlue Skies Flying LLC · Morganville, NJBuilt 1983 · S/N 24-1374N21EM2fly-Safety LLC · Azle, TXS/N 243129N2201Decou Gordon C · Myakka City, FLBuilt 1983 · S/N 24-1389N2201AJulius Air LLC · Lewes, DEBuilt 1978 · S/N 24-0559N2201MSteck Richard E · Arlington Heights, ILBuilt 1978 · S/N 24-0560N2201PRm Stoudt Inc · Jamestown, NDBuilt 1978 · S/N 24-0561N2201QBocaj Air LLC · Irving, TXBuilt 1978 · S/N 24-0562N2201RMize Helicopter LLC · Grand Prairie, TXBuilt 1978 · S/N 24-0564N220FCRegistered aircraftBuilt 1993 · S/N 24-3282N220TMMoore Wistar III · Savannah, GABuilt 1993 · S/N 24-3303N2210WGarg Ken M · Brewster, NYBuilt 1998 · S/N 24-3423N221FCWest Charles E Jr · Yulee, FLBuilt 1993 · S/N 24-3289N222BHLudwigson Joel R · Inver Grove, MNBuilt 1978 · S/N 24-0498N222KRSharon Carl G · Brookshire, TXBuilt 1979 · S/N 24-0773N223FCKimzey Edwin D Jr · La Jolla, CABuilt 1993 · S/N 24-3309N226RLAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1998 · S/N 24-3427N228ALRacach Air LLC · Corvallis, MTBuilt 1984 · S/N 24-1529N22RJSandhu Balraj S · Fairfield, CABuilt 1990 · S/N 24-3207N232JTBlezek Kent D · Tustin, CABuilt 1978 · S/N 24-0727N234BPYoung Tim M Trustee · Edmond, OKBuilt 1992 · S/N 24-3283N239SWPyles William J · Pismo Beach, CABuilt 1979 · S/N 24-0924N23MDBell William P · Gainesville, GABuilt 1981 · S/N 24-1247N241RCReynolds Thomas H · Toms River, NJBuilt 1981 · S/N 24-1121N242CBHarte Mike · Lone Star, TXBuilt 1978 · S/N 24-0459N242CPBeste Robert K · Sauk Centre, MNBuilt 1978 · S/N 24-0715N242HMWes Vance LLC · Four Oaks, NCBuilt 1990 · S/N 24-3151
Back to AD 95-26-16 R1