AD 96-10-01 R1

Registered aircraft · 8,139

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:96-10-01-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:96-10-01-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.

N5211LDuncan Timothy Scott · Sioux Falls, SDBuilt 1967 · S/N 28-4503N5211WRupesh Patel · Waycross, GABuilt 1961 · S/N 28-247N5213LSchultz Lillian I · Henderson, TXBuilt 1967 · S/N 28-4505N5213WN5213w LLC · Clarksville, TNBuilt 1961 · S/N 28-249N5215LMorehouse William S · Tucson, AZBuilt 1967 · S/N 28-4507N5215TBarr Perry L · Bethel, AKS/N 28-7225358N5215WBurns Arlen B · Bellingham, WABuilt 1961 · S/N 28-251N5216TKntl Enterprises LLC · Boise, IDBuilt 1972 · S/N 28-7205247N5216WSteed Moroni W · Moorcroft, WYBuilt 1961 · S/N 28-252N5217LKenny Tommy D · Maryville, MOBuilt 1967 · S/N 28-4510N5218LTjossem James · Thompsons Station, TNBuilt 1967 · S/N 28-4511N5219LShanley William D · Orland Park, ILBuilt 1967 · S/N 28-4512N521DHPenner Ford Aviation LLC · Lebanon, MOBuilt 1965 · S/N 28-21007N5220LR & J Services LLC · Tracy, CABuilt 1967 · S/N 28-4513N5220THammond Michael R · Tigard, ORS/N 28-7225360N5221LVeritable Solutions LLC · Bremerton, WABuilt 1967 · S/N 28-4514N5221WGrady John M · Perham, MNBuilt 1961 · S/N 28-258N5223TBarnard Kevin D · Columbia Station, OHBuilt 1972 · S/N 28-7225362N5223WStover Jeffrey Wayne · Gastonia, NCBuilt 1961 · S/N 28-260N5224LWight John M · Merrimack, NHBuilt 1967 · S/N 28-4518N5224TPerkins Barber Shop · Jennings, LABuilt 1972 · S/N 28-7205248N5226LVancura Aviation LLC · Seffner, FLBuilt 1967 · S/N 28-4520N5227LPeter David A · Anderson, INBuilt 1967 · S/N 28-4521N5228LWilliam C New Aviation Services LLC · Morgan City, LAS/N 28-4522N522FLRegistration Pending · Teaneck, NJRegistration pendingBuilt 1971 · S/N 28-7125347N522JDFly Around Alaska LLC · Palmer, AKBuilt 1970 · S/N 28-26468N5231WErikson Nils S · Longview, TXBuilt 1962 · S/N 28-269N5232LRodway George W · Aurora, ORBuilt 1967 · S/N 28-4526N5232TCampbell Ronald W · Waller, TXBuilt 1972 · S/N 28-7225363N5233LFox Two LLC · Camino, CABuilt 1967 · S/N 28-4527N5233TBoots Larry C · Weiser, IDBuilt 1972 · S/N 28-7205249N5234LDileo Dale · West Islip, NYBuilt 1967 · S/N 28-4528N5235LJones Scott M · Overton, NVBuilt 1967 · S/N 28-4529N5237LAir Sicko LLC · Albany, NYBuilt 1967 · S/N 28-4531N5237TCavins Drew A · Jacksonville, FLBuilt 1972 · S/N 28-7225366N5238LBreon Ryan L · Castroville, TXBuilt 1967 · S/N 28-4533N5238WMckibben Clint E · Lubbock, TXS/N 28-278N5239LWilson Ronald A · Elk Grove, CABuilt 1967 · S/N 28-4534N5239TBrotherton Bradley T Trustee · Canby, ORBuilt 1972 · S/N 28-7225368N523BCSaman Beshoy · Round Rock, TXS/N 28-565N523FLOden Matthew E · Greenwood, SCBuilt 1971 · S/N 28-7125349N5240TRegistered aircraftBuilt 1972 · S/N 28-7225369N5240WVanni Steven J · Naples, FLBuilt 1962 · S/N 28-281N5241LFour One Lima Inc · Roanoke, VABuilt 1967 · S/N 28-4536N5242LSimpson Jacob William · Crescent Springs, KYBuilt 1967 · S/N 28-4537N5243LKeys Robert C · Winston Salem, NCBuilt 1967 · S/N 28-4538N5244LGarman Daniel L · Burr Oak, KSBuilt 1968 · S/N 28-4539N5245WSwartzfager Lee C · Corry, PABuilt 1962 · S/N 28-287N5246LSmithson Thomas E · Franklin, TNBuilt 1967 · S/N 28-4541N5246WScovil Jarin K · Laramie, WYS/N 28-288
Back to AD 96-10-01 R1