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

N8245NShimei Mark A · Titusville, FLBuilt 1969 · S/N 28-25454N8245WJ & L Aircraft Rentals Llctrust · Oxford, GABuilt 1965 · S/N 28-2391N8246NMorgan Jeffrey P · Mc Veytown, PABuilt 1969 · S/N 28-25455N8247NHorizon Edge LLC · Helena, MTBuilt 1969 · S/N 28-25456N8247WDombrowski Gregory John · Mangum, OKBuilt 1965 · S/N 28-2394N8248NGarcia Leobardo · Tucson, AZBuilt 1969 · S/N 28-25457N8249NAero Club Aviation LLC · Apollo Beach, FLBuilt 1969 · S/N 28-25459N8249WHartpence Damian K · Newcastle, OKBuilt 1965 · S/N 28-2397N8250NBruce James E · Greenfield, INS/N 28-25460N8250WMorehead Leonard E · Bryan, TXS/N 28-2399N8251NLarue Jesse W · College Station, TXBuilt 1969 · S/N 28-25461N8251WKeddis Moheb N · Fairfax, VABuilt 1965 · S/N 28-2401N8252NWhiting Reed Brandon · Mesa, AZBuilt 1969 · S/N 28-25462N8254NBlum William C · Alma, NEBuilt 1969 · S/N 28-25465N8255WReed Emerson E · Winter Haven, FLBuilt 1965 · S/N 28-2406N8256WInland Northwest Flyers LLC · Spokane Vly, WAS/N 28-2407N8257WHou Barry · San Marino, CABuilt 1965 · S/N 28-2409N8258WWirkus Branden D · Apo, AEBuilt 1965 · S/N 28-2410N8259NAughenbaugh Timothy A · Iriquois, SDS/N 28-25471N8259WMorrison Daniel S · Hershey, PABuilt 1965 · S/N 28-2411N825PTIcarus Flyers LLC · Richmond Hill, GABuilt 1973 · S/N 28-7305472N8260NSundberg Nicholas William · Stevensville, MTBuilt 1969 · S/N 28-25472N8262N40 Flight LLC · Fernandina Beach, FLBuilt 1969 · S/N 28-25474N8262WCalhoun Jerry H · Washington, NCBuilt 1965 · S/N 28-2413N8263NPiper Partners Mbda LLC · Fairfield, ILBuilt 1969 · S/N 28-25475N8263WViking Crown LLC · Prescott, AZBuilt 1965 · S/N 28-2414N8264NRegistered aircraftRegistration pendingBuilt 1969 · S/N 28-25477N8264WEyrich Richard L · Cave Creek, AZBuilt 1965 · S/N 28-2415N8265NImmanuel Baptist Church Of Kansas City Kansas · Basehor, KSBuilt 1969 · S/N 28-25478N8265WRoy Kristi D · Burleson, TXS/N 28-2417N8266WCraddock James E · Greensboro, NCBuilt 1965 · S/N 28-2419N8267NGallup Asa N · Morgan, TXBuilt 1969 · S/N 28-25480N8268NDawes Roger L · Bullhead City, AZS/N 28-25481N8268WMontjar Andrew J · Shelby Township, MIBuilt 1965 · S/N 28-2421N8270NCloudsurfer LLC · Louisville, KYBuilt 1969 · S/N 28-25484N8270WRegistration Pending · Fair Oaks Ranch, TXRegistration pendingS/N 28-2423N8271WWashington Aero Club · South Park, PABuilt 1965 · S/N 28-2425N8273NSomboonsap Patanapong · Oakland Park, FLBuilt 1969 · S/N 28-25487N8274NJln Aviation Services LLC · Avon, INBuilt 1969 · S/N 28-25489N8274WSleight Travis A · Southfield, MIBuilt 1965 · S/N 28-2429N8275NRollinger Dennis P · Plainfield, ILBuilt 1969 · S/N 28-25490N8276WTreleven Alfred Herbert IV · Tacoma, WAS/N 28-2431N8278NBastian Richard D · Chiloquin, ORBuilt 1969 · S/N 28-25493N8278WChamberlain Mark S · Hamburg, NYBuilt 1965 · S/N 28-2434N8279NWillson Michael S · Saint Cloud, FLBuilt 1969 · S/N 28-25495N8280NEllis Clifford J · Murray, KYBuilt 1969 · S/N 28-25496N8280WGarbin Kurt A · Steamboat Springs, COBuilt 1965 · S/N 28-2437N8281NTan Dexter E · Dallas, TXS/N 28-25497N8281WNeisen Brandon L · Fowler, ILBuilt 1965 · S/N 28-2438N8282WBenker Albert J · Bevier, MOBuilt 1965 · S/N 28-2440
Back to AD 96-10-01 R1