OpenAirDocs.org
AD 99-05-13 R1 WD

Registered aircraft · 13,518

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-05-13-R1-WD')
    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-05-13-R1-WD')
  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.

N5797KBank Of Utah Trustee · Salt Lake City, UTBuilt 1964 · S/N D-7586N5798VHarlow Daniel E · Spotsylvania, VABuilt 1966 · S/N MB-58N5799KCain Christopher · Colleyville, TXBuilt 1964 · S/N D-7590N579DMDiggins David A · Corpus Christi, TXS/N E-1769N57AWGrey Horizon Group LLC · Sheridan, WYS/N TC-1116N57CFTurbett Theodore T · Houston, TXBuilt 1972 · S/N D-9358N57EDWebster Chad E · Coronado, CABuilt 1957 · S/N D-5140N57GGGerhart Gary Elmer · Houston, TXBuilt 1978 · S/N E-1385N57GWHardin Thomas H III · Sonoita, AZBuilt 1989 · S/N CE-1398N57HBSkeeler William Tyler · Austin, TXBuilt 1957 · S/N D-5268N57MPSoleil Aviation LLC · Naples, FLBuilt 1973 · S/N TC-1631N57RSmith Gregory C · Geneva, ILBuilt 1955 · S/N D-4404N57RBDavis Timothy M · Yelm, WABuilt 1979 · S/N E-1572N57RTChristiansen Aviation LLC · Wilmington, DEBuilt 1979 · S/N ME-172N57SBRadkey Edward B · Humble, TXBuilt 1979 · S/N E-1467N57TCNiemi Aviation LLC · Glyndon, MNBuilt 1968 · S/N D-8693N57TWBc & Tw Flying Service LLC · Hot Springs, ARBuilt 1982 · S/N EA-288N57UMMichaud David · Naples, FLBuilt 1984 · S/N CE-1039N57ZZUnited States Air Force Owner · March Arb, CABuilt 1957 · S/N BG-323N5800SRabosky Gary · Frenchtown, NJBuilt 1964 · S/N TC-817N5802CRackham Alan Scott · Foresthill, CABuilt 1951 · S/N D-2754N5803KWhittock Tyson H · Anchorage, AKBuilt 1965 · S/N D-7830N5804CGeorge Andrew N · Corvallis, ORBuilt 1951 · S/N A579N5804KHarrell Jeff E · Cedar Park, TXBuilt 1965 · S/N D-7831N5805KDoran James V · Saint John, KSBuilt 1965 · S/N D-7833N5806CPasztalaniec Matt · Monterey, CABuilt 1951 · S/N D-2758N5806SAg Solutions Of West Texas LLC · Roby, TXBuilt 1964 · S/N D-7720N5808CDeasy John F Jr · Doylestown, PABuilt 1951 · S/N D-2760N5809SRegistered aircraftBuilt 1964 · S/N D-7717N5811KUpp Air LLC · Portland, MEBuilt 1965 · S/N TC-910N5811SCampbell Andrew S · Lake Havasu City, AZBuilt 1964 · S/N D-7719N5812CJanzen Larry L · Lakeland, FLBuilt 1951 · S/N D-2764N5813SBailey Craig R · Poplar Grove, ILBuilt 1964 · S/N D-7721N5814CMag Aviation Fuel · Flagstaff, AZS/N D-2827N5818CSwartz William R · Alto, MIS/N D-2770N581BVStueber Daniel A · Royse City, TXBuilt 1987 · S/N CE-1177N581CBColorado Baron LLC · Ketchum, IDBuilt 1979 · S/N TJ-233N581KBFenn Farms Inc · Durham, CABuilt 1975 · S/N E-786N5821941 Historical Aircraft Group DBA · Geneseo, NYBuilt 1944 · S/N 6704N5820SHemmeger Scott E · Kokomo, INBuilt 1964 · S/N D-7724N5821CMilazzo Air LLC · North Adams, MAS/N D-2773N5821SHatfield Aviation Inc · Otsego, MIBuilt 1964 · S/N D-7725N5822SPatton Aviation LLC · Billings, MTBuilt 1964 · S/N D-7726N58238Odell Eugene S · Yakima, WABuilt 1964 · S/N TC-830N5825KBonanza Over Miami Inc · Coral Gables, FLBuilt 1965 · S/N D-7855N5826KObiewan Air Services LLC · Manvel, TXBuilt 1965 · S/N D-7842N5828CTubens Robert N · Benton City, WABuilt 1951 · S/N D-2780N5828SCustom Ag LLC · El Centro, CABuilt 1964 · S/N D-7727N5829CYore Victor N · Chase City, VABuilt 1951 · S/N D-2828N5829KPeck Joseph H · Stansbury Park, UTS/N TC-911
Back to AD 99-05-13 R1 WD