OpenAirDocs.org
AD 99-01-05 R1

Registered aircraft · 10,639

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:99-01-05-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:99-01-05-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.

N82618Lechner Burdette J · Kodiak, AKBuilt 1978 · S/N 18-7909018N82619Cherry Hill Aviation Inc · Freetown, INBuilt 1978 · S/N 18-7909019N82633Roth J · Anchorage, AKBuilt 1978 · S/N 18-7909023N82635Chase 13 LLC · Wilmington, DEBuilt 1978 · S/N 18-7909024N82665Schiestle Jason T · Greenville, PABuilt 1978 · S/N 18-7909026N82667Corfman Randle S · Lino Lakes, MNBuilt 1978 · S/N 18-7909028N82669Balcomb Mark S · Silt, COBuilt 1978 · S/N 18-7909029N8266CPiper 8266c LLC · Indianapolis, INBuilt 1954 · S/N 22-2341N8267CMichie Robert B · Austin, TXBuilt 1954 · S/N 22-2342N826ARobbins Julie A · Burson, CABuilt 1951 · S/N 22-128N826VACrop Care By Air Inc · Lantry, SDS/N 12-3012N8270CBriscoe Travis L · Archie, MOBuilt 1954 · S/N 22-2345N82712Flack Andrew P · Wasilla, AKBuilt 1977 · S/N 18-7709172N82714Gross Jeffrey A · Tok, AKBuilt 1977 · S/N 18-7709173N82718Hanley Company LLC · Littleton, COBuilt 1977 · S/N 18-7709174N82719Doitch Dan · Valencia, CABuilt 1976 · S/N 18-7709175N82725Sherman Guy F · Soldotna, AKBuilt 1977 · S/N 18-7709177N82727Gregory John R · Challis, IDS/N 18-7709178N82731Hoecher Chris · Greeley, COS/N 18-7709181N82732State Of Alaska · Anchorage, AKBuilt 1977 · S/N 18-7709182N82735State Of Alaska · Anchorage, AKBuilt 1977 · S/N 18-7709183N82736State Of Alaska · Anchorage, AKBuilt 1977 · S/N 18-7709184N82737Swiss Jack S · Anchorage, AKBuilt 1977 · S/N 18-7709185N82740Thomas Timothy W · Watsonville, CABuilt 1977 · S/N 18-7709186N82741Stancil Joseph E Jr · Eagle River, AKBuilt 1977 · S/N 18-7709187N82748Templeton Marie K Trustee · Carthage, MOBuilt 1959 · S/N 18-6838N82749Habersetzer Lon J · Yacolt, WABuilt 1977 · S/N 18-7709188N82751Fly49 LLC · Palmer, AKBuilt 1977 · S/N 18-7709194N82754Lee Nathan · Athol, IDBuilt 1977 · S/N 18-7709196N8275CLewis Payton S · Eupora, MSBuilt 1954 · S/N 22-2350N8275UStout Kerrick L · New Richmond, OHFirst renewal noticeBuilt 1979 · S/N 18-7909102N8280CEllis Matthew W · Sabina, OHBuilt 1954 · S/N 18-3688N8281CThomas Ken C · Fairbanks, AKBuilt 1954 · S/N 18-3689N8286AEuroaviation Inc · KematenS/N 7435N8287BCostanti Nicolas J · Medford, ORS/N 18-7609048N8288CRood James D · Winston, NMBuilt 1955 · S/N 18-4113N8289CSchilder Justin W · Faulkton, SDBuilt 1954 · S/N 18-3699N828AYoder Stephen · Melba, IDBuilt 1951 · S/N 22-130N828JPCarney William F · Gallatin, TNBuilt 1957 · S/N 185460N82905Reese Melissa A · Soldotna, AKBuilt 1977 · S/N 18-7709197N82907Law Offices Of David Henderson · Anchorage, AKBuilt 1978 · S/N 18-7909031N8290CMckinney Steve R · Hamersville, OHBuilt 1954 · S/N 20-1119N82912Barrows Stuart L · Eagle River, AKBuilt 1977 · S/N 18-7709195N82914Lkn Supercub LLC · Huntersville, NCBuilt 1977 · S/N 18-7809023N82918Herman Brant · Fairbanks, AKBuilt 1977 · S/N 18-7809024N8291CStober John · Goodrich, NDBuilt 1954 · S/N 22-2356N8293CMcchargue Robert W II · Talkeetna, AKS/N 18-4114N82941Super Cub Master LLC · Hurricane, UTS/N 18-7809026N82942Kemp Kerm R · Southwest Ranches, FLBuilt 1977 · S/N 18-7809027N82945Brewer William B Jr · Fairbanks, AKBuilt 1977 · S/N 18-7809029
Back to AD 99-01-05 R1