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.

N5247TTevik Michael A · Provo, UTBuilt 1972 · S/N 28-7225371N5248TDopfel Sierra M · Udall, KSBuilt 1972 · S/N 28-7225372N5248WBalfa Joshua · Lumberton, TXBuilt 1962 · S/N 28-290N524FLMoore Bruce W · Aledo, TXBuilt 1971 · S/N 28-7125351N5250LAcharya Jagat P · Powell Butte, ORS/N 28-4545N5251LRegistration Pending · Osage Beach, MORegistration pendingBuilt 1967 · S/N 28-4547N5253THart William · Johnson City, TNS/N 28-7225373N5255TGood Joseph A · Weymouth, MABuilt 1972 · S/N 28-7225375N5255WHoppes Curt · Saint Jacob, ILBuilt 1962 · S/N 28-299N5256LIngram Aviation LLC · Johns Island, SCBuilt 1967 · S/N 28-4553N5259LPennsylvania Flying Assoc Inc · Saegertown, PABuilt 1967 · S/N 28-4557N525FLSiebert Derrick R · Wausau, WIBuilt 1971 · S/N 28-7125357N5262LWilliams Gregory L · Tehachapi, CABuilt 1967 · S/N 28-4560N5263LRjl Aero Inc · Valparaiso, INBuilt 1967 · S/N 28-4561N5264WGray Donald B Trustee · Houston, TXBuilt 1961 · S/N 28-310N5265WDwight Marketing Corporation · Caldwell, KSBuilt 1962 · S/N 28-311N5267LBlasi Aviation LLC · Valley Center, KSBuilt 1967 · S/N 28-4565N5268TDykes Don A · Houston, TXBuilt 1972 · S/N 28-7205252N5269LKarel John · Stillwater, MNBuilt 1967 · S/N 28-4567N5269TKailua Aviation LLC · Moorestown, NJBuilt 1972 · S/N 28-7205253N5269WGoetz David B · Gleason, WIS/N 28-315N5271LBright Skies Sales And Leasing LLC · Hendersonville, TNBuilt 1967 · S/N 28-4569N5273LMancuso Dale · Dallas, TXFirst renewal noticeBuilt 1967 · S/N 28-4571N5273SCarnegie Nursing Home Inc · Carnegie, OKBuilt 1971 · S/N 28-7125209N5274LRetzer Daniel R · Rockford, ILBuilt 1967 · S/N 28-4573N5276LHaynie Sidney S · Sedona, AZBuilt 1968 · S/N 28-4575N5277SFers Mitchell A · Stafford Springs, CTBuilt 1970 · S/N 28-26908N5278SN5278s LLC · Katy, TXBuilt 1970 · S/N 28-26911N5278WJohns Tyler B · Folsom, CABuilt 1962 · S/N 28-326N5279LCarverair LLC · Lakeland, FLBuilt 1967 · S/N 28-4578N5279TDicecco Jennifer · West Chester, PABuilt 1972 · S/N 28-7225386N527FLPatterson Roy A · Cameron, TXS/N 28-7125354N527LMacan Ed · Overland Park, KSBuilt 1975 · S/N 28-7505228N5280WKinney Colton S · Montrose, MNBuilt 1962 · S/N 28-329N5281LPioneer Aviation Inc · Fond Du Lac, WIBuilt 1968 · S/N 28-4581N5281SKurkjian Daniel C · Chester Springs, PABuilt 1970 · S/N 28-26918N5281TCentury Flight Systems Inc · Mineral Wells, TXBuilt 1972 · S/N 28-7205255N5281WThomaston Mitchell E · Hampton, GABuilt 1962 · S/N 28-330N5282LHodges Richard T · Williamston, MIBuilt 1967 · S/N 28-4582N5282WFloe Glen M · Wickenburg, AZBuilt 1962 · S/N 28-331N5284LRobert N Mclay Md A Professional Medical Corp · Chula Vista, CABuilt 1967 · S/N 28-4584N5287WStump Kenneth H · Ward, ARBuilt 1962 · S/N 28-336N5288WMcdowell John Michael · Auburn, CABuilt 1962 · S/N 28-338N5289LJames Brandon · Maple Valley, WABuilt 1968 · S/N 28-4590N5289SHarrison John M · Letart, WVBuilt 1970 · S/N 28-26945N528BFBoldflight LLC · Danville, INBuilt 1975 · S/N 28-7525176N528FLRamirez Ciro · Corona, CABuilt 1971 · S/N 28-7125358N5290LWenger Michael · Lancaster, PABuilt 1968 · S/N 28-4591N5291SWilliams Scott H · Renton, WABuilt 1970 · S/N 28-26913N5292SVermilyea Paul E · Newton, KSBuilt 1970 · S/N 28-26923
Back to AD 96-10-01 R1