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.

N6309JLopez Josue Ismael · Foothill Ranch, CAS/N 28-4721N6309RAerowolfe Aircraft Services LLC · Spokane, WABuilt 1966 · S/N 28-21475N630BJJones Robert M · Brooksville, FLBuilt 1969 · S/N 28-26111N6310RCcb Warriors LLC · Lawrence, KSBuilt 1966 · S/N 28-21476N6313WFlight Plan LLC · Friendswood, TXBuilt 1964 · S/N 28-20359N6315WAir Share Aviators Flight Club LLC · Fairfax, CAFirst renewal noticeBuilt 1964 · S/N 28-20372N6316JMcintosh Rick D · Kansas City, MOBuilt 1968 · S/N 28-4723N6316RHolec David V · Senoia, GABuilt 1966 · S/N 28-21482N6318RN383j LLC · Henderson, NVBuilt 1966 · S/N 28-21484N6319RRj Aviation LLC · Hurricane, UTBuilt 1966 · S/N 28-21485N631FLMiller William H · Blue Mound, ILBuilt 1971 · S/N 28-7125526N6320JJns Corp · Wilmington, DEBuilt 1968 · S/N 28-4728N6321JPrecision Aircraft Service LLC · Staples, MNBuilt 1968 · S/N 28-4729N6322JBaus Mark L · La Crosse, KSBuilt 1968 · S/N 28-4730N6323JYoung Troy D · Vernon, TXS/N 28-4731N6323RSeigel Virginia L · Havre, MTBuilt 1966 · S/N 28-21490N6323WMedicine By Design Inc · Miami, FLBuilt 1964 · S/N 28-20379N6325JBantle Flyers LLC · North Chesterfield, VABuilt 1968 · S/N 28-4733N6325RVaught Janet M · Creedmoor, NCBuilt 1966 · S/N 28-21492N6326RBlancett-Maddock David D · Kailua Kona, HIBuilt 1966 · S/N 28-21494N6326WKipkurui Stephen · Fort Worth, TXBuilt 1964 · S/N 28-20382N6328JWildflower Remedies LLC · Millersburg, OHS/N 28-4736N6329JBeavers Danny G · San Antonio, TXBuilt 1968 · S/N 28-4737N6329RLomax Robert P · Belfair, WABuilt 1966 · S/N 28-21497N6329WKingsley Kaland W · Miller, MOBuilt 1964 · S/N 28-20385N6330JBrashear Don F · Orcas, WABuilt 1968 · S/N 28-4738N6330RLuton Christopher S · Cedar Park, TXBuilt 1966 · S/N 28-21498N6332REllis Mark D · Parma, OHBuilt 1966 · S/N 28-21501N6334JBazacos Theresa B · Pensacola, FLBuilt 1968 · S/N 28-4743N6334RPollock William J · Agawam, MABuilt 1966 · S/N 28-21503N6335JAher Kishor Dudhabhai · Livingston, NJBuilt 1968 · S/N 28-4744N6336JTessmann David James · Albuquerque, NMBuilt 1968 · S/N 28-4745N6337WGuerin Bryant J · West Ossipee, NHS/N 28-20394N6338JBennett Aviation LLC · Gillette, WYBuilt 1968 · S/N 28-4747N6338RJohnson Cody J · Trafalgar, INBuilt 1966 · S/N 28-21507N6339RSeager Anthony M · Medford, ORBuilt 1966 · S/N 28-21508N633CEpperson Dallas C · Asheville, NCS/N 28-7125601N6340J4 M Aviation LLC · Glenwood, ARBuilt 1968 · S/N 28-4749N6340WVarnell George W · Kennesaw, GABuilt 1964 · S/N 28-20398N6341RBethany Holdings LLC · Jamestown, NCBuilt 1966 · S/N 28-21510N6341WMangham Aviation LLC · Mullin, TXBuilt 1964 · S/N 28-20399N6342RNagle George · Phillipsburg, NJBuilt 1966 · S/N 28-21511N6342WAg Air Squadron Two LLC · Saint Joseph, ILBuilt 1964 · S/N 28-20400N6344RGalaxy Electronics LLC · Hallandale Beach, FLBuilt 1966 · S/N 28-21513N6345JHaywood Ken P · Acworth, GABuilt 1968 · S/N 28-4754N6346JSons Thomas · Norwood, MNBuilt 1968 · S/N 28-4755N6346RBuresh Noah A · Blair, WIBuilt 1966 · S/N 28-21516N6346WCottrill William M Jr · Joplin, MOFirst renewal noticeBuilt 1964 · S/N 28-20404N6347JGrove City Aviation LLC · Mercer, PABuilt 1968 · S/N 28-4756N6348JWingsleasing LLC · Wichita, KSBuilt 1968 · S/N 28-4757
Back to AD 96-10-01 R1