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.

N6472RWilson Richard J · Naknek, AKS/N 28-21660N6472WSilaban Chandra · Independence, KYBuilt 1964 · S/N 28-20546N6474JBenham Miriam · Elk Grove, CAS/N 28-4901N6475JClark Clyde E · Naknek, AKBuilt 1968 · S/N 28-4902N6475WJ K Merrill And Sons Inc · Pocatello, IDBuilt 1964 · S/N 28-20549N6476RVlaz Richard J · Washington Twp, MIBuilt 1966 · S/N 28-21665N6477JSweat Jeremy A · Morrill, KSS/N 28-4904N6477WWashington Samuel L · Cleveland, MSBuilt 1965 · S/N 28-20551N6478JPart Guy LLC · Berlin, NJS/N 28-4905N6478WLamar Edward Blake Jr · Rch Palos Vrd, CABuilt 1964 · S/N 28-20552N6479JBabula Ronald Lee Jr · Drums, PABuilt 1968 · S/N 28-4906N6479RGromada Kristian Paul · Eagle River, AKBuilt 1966 · S/N 28-21669N6479WManagement Ranch LLC · Sheridan, WYBuilt 1964 · S/N 28-20553N647FLRegistration Pending · Fruitland Park, FLRegistration pendingBuilt 1971 · S/N 28-7125555N6480JBeaver Douglas G · Harleysville, PABuilt 1968 · S/N 28-4908N6482JSmart Avionics Inc · Marietta, PABuilt 1968 · S/N 28-4910N6483JCimarron Flying Lc · Elkhart, KSS/N 28-4912N6484JMathis Flight Solutions LLC · Dubberly, LABuilt 1968 · S/N 28-4913N6485JYankee Flyers LLC · Berryville, VABuilt 1968 · S/N 28-4914N6485WShades Daniel L · Tumwater, WABuilt 1965 · S/N 28-20560N6486WSommerfeld Jordan Maxwell · Kittanning, PABuilt 1964 · S/N 28-20561N6487RNurney Steven P · Fountain Hills, AZBuilt 1966 · S/N 28-21678N6488JWccrt LLC · Enterprise, KSS/N 28-4918N6488R6 Aerospace LLC · Albuquerque, NMS/N 28-21679N6488WKendall Ralph L Jr · Cape Coral, FLBuilt 1965 · S/N 28-20563N6489JPatten Jeffery D · Rapid City, SDBuilt 1968 · S/N 28-4920N6490RDunn Christopher E · Amana, IAS/N 28-21681N6490WHanson Orion M · Seabeck, WAS/N 2820566N6491JEleven X Club Inc · Jeffersonville, INBuilt 1968 · S/N 28-4922N6491RGonzales Christian J · Dallas, TXBuilt 1966 · S/N 28-21683N6491WHuddleston Ronnie L · North Vernon, INBuilt 1965 · S/N 28-20567N6492RFagerhaug Jeffrey · Orangevale, CABuilt 1966 · S/N 28-21684N6493JReischmann Jonathan · Palm Bay, FLS/N 28-4924N6493RReifschneider Jay S · Patterson, CABuilt 1966 · S/N 28-21685N6494JKennedy Quincy A IV · Florence, SCBuilt 1968 · S/N 28-4925N6494RTurner Manley W Jr · Fredericksburg, VABuilt 1966 · S/N 28-21686N6495JStp Flight LLC · Saint Paul, MNBuilt 1968 · S/N 28-4926N6495WScheibinger Alois E · Oshkosh, WIBuilt 1964 · S/N 28-20571N6496JBudke Kris J · Osceola, WIBuilt 1968 · S/N 28-4928N6498JKvistad Jerome L · Coon Rapids, MNBuilt 1968 · S/N 28-4930N6499RGoodroe Zachary A · Santa Rosa Beach, FLBuilt 1966 · S/N 28-21692N6499WMarston Benjamin E · Seale, ALBuilt 1965 · S/N 28-20576N64MSTilko Stanley L Jr · Butler, PABuilt 1973 · S/N 28-7305466N6500JHorizon Aviation LLC · Brooks, GABuilt 1968 · S/N 28-4933N6501JAndersen Aviation LLC · Leavenworth, WAS/N 28-4934N6501WStewarts Aircraft Service Inc · Waynesville, OHBuilt 1964 · S/N 28-20578N6502Keen Brandon M · Brunswick, MEBuilt 1962 · S/N 28-566N6502JGanuza Diego J · Okeechobee, FLBuilt 1968 · S/N 28-5114N6502WMid American Pilot Association Inc · Lawrenceville, ILBuilt 1965 · S/N 28-20579N6503JTischler Keith Louris · Round Rock, TXBuilt 1968 · S/N 28-4938
Back to AD 96-10-01 R1