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.

N71GFUptime Aviation LLC · Fort Lauderdale, FLBuilt 1967 · S/N 283911N71KTL L C LLC · Rapid City, SDBuilt 1965 · S/N 28-21258N71PMAnderson Aviation LLC · Bulverde, TXBuilt 1971 · S/N 28-7125523N71SATake Off LLC · Boise, IDBuilt 1971 · S/N 28-7125607N71SHReese Jose A · Yuma, AZBuilt 1967 · S/N 28-4048N7200JBell Dylan Will Nash · W Columbia, TXBuilt 1968 · S/N 28-24471N7200WAgri Air LLC · Fairfax, MOBuilt 1963 · S/N 28-1011N7201FPowell Jonathan C · Philadelphia, PABuilt 1968 · S/N 28-25108N7201JTrebor Aviation LLC · Prescott Valley, AZBuilt 1968 · S/N 28-24531N7201WTaylor Robert · Greensboro, NCS/N 28-1012N7202JAir Indiana LLC · Noblesville, INBuilt 1968 · S/N 28-24533N7203FLaird Grant M · Puryear, TNBuilt 1968 · S/N 28-25111N7203JRegistration Pending · Tifton, GARegistration pendingBuilt 1968 · S/N 28-24534N7204WKlein Kaylin · Stillwater, OKBuilt 1963 · S/N 28-1017N7206CDwyer Benjamin J · Colorado Springs, COBuilt 1976 · S/N 28-7625072N7206FVoyage Capital Ventures LLC · Knightdale, NCBuilt 1968 · S/N 28-25114N7206WSchimmel O L · Port Hueneme, CABuilt 1963 · S/N 28-1020N7207FLandmark Title Inc · Clovis, NMBuilt 1968 · S/N 28-25115N7207JErhardt Industries LLC · Ottumwa, IABuilt 1968 · S/N 28-24540N7207WValkaria Flyers LLC · Palm Bay, FLBuilt 1963 · S/N 28-1021N7208FWignot Andrew R · Oceanside, CABuilt 1968 · S/N 28-25117N7208JWelby Samantha · Eastampton, NJBuilt 1968 · S/N 28-24541N7208WSky View Aviation LLC · Porter, OKS/N 28-1117N7209FNew Garden Township · Landenberg, PABuilt 1968 · S/N 28-25118N720FLExecutive Flight Training & Services LLC · Sanford, NCBuilt 1972 · S/N 28-7225401N7210FCedar Yopanz Flying Club LLC · Las Vegas, NVBuilt 1968 · S/N 28-25119N7210JBoling Kenneth A · Greenbrier, ARBuilt 1968 · S/N 28-24543N7210WN7210w Corp · Selma, NCBuilt 1963 · S/N 28-1355N7211JGolden Arrow Transportation · Plainfield, NJBuilt 1968 · S/N 28-24545N7212FDe Valle Rafael · Columbus, GABuilt 1968 · S/N 28-25121N7212JF7 Aviation LLC · Kalispell, MTBuilt 1968 · S/N 28-24546N7212WFerki Joseph J · Franklin, VABuilt 1963 · S/N 28-1154N7213WSmith Scott V · Presque Isle, MEBuilt 1963 · S/N 28-1155N7214JFalcon Flyers LLC · Hamilton, MTBuilt 1968 · S/N 28-24549N7215FGailie Thomas E · Middletown, NYS/N 28-25125N7216FBravo Aviation Assets LLC · Akron, OHBuilt 1968 · S/N 28-25126N7216JCaden Aviation Services LLC · Dallas, TXBuilt 1968 · S/N 28-24551N7216PFerrara Antonio · Granbury, TXBuilt 1963 · S/N 28-1433N7216WBim Merle Robert W III · Piqua, OHBuilt 1963 · S/N 28-1030N7217FWheeler Samuel C · O Fallon, MOBuilt 1968 · S/N 28-25127N7217JAvionraton LLC · Valparaiso, INBuilt 1968 · S/N 28-24553N7218JSullivan Michael D · Braddyville, IABuilt 1968 · S/N 28-24554N7218WIsaacs Gorden R · Dillingham, AKBuilt 1963 · S/N 28-1033N7219JJohnson Eric A · Shell Knob, MOBuilt 1968 · S/N 28-24555N721TTFlight School Of Gwinnett · Lawrenceville, GAS/N 28-7505093N7220FSmith Craig D · Lucedale, MSBuilt 1968 · S/N 28-25131N7221JWilliams Maria M · Kernersville, NCBuilt 1968 · S/N 28-24557N7222JAviation Partners Llp · Bismarck, NDBuilt 1968 · S/N 28-24558N7223FBrown Richard G · Irvine, CABuilt 1976 · S/N 28-7725087N7223WRajuan Oren · Sacramento, CAFirst renewal noticeBuilt 1963 · S/N 28-1038
Back to AD 96-10-01 R1