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.

N6905DEvans Theresa K · Alexandria, MNBuilt 1957 · S/N 22-4832N6906KWilliams Don D · Athens, ALS/N 20-9N6907BJordan Walter B · Chehalis, WABuilt 1956 · S/N 22-4182N6908KRegistration Pending · Dillingham, AKRegistration pendingBuilt 1950 · S/N 20-12N6909BKaufmann Arnold L · Davenport, IABuilt 1956 · S/N 22-4184N6909KJersey Devil Dusters LLC · Southampton, NJBuilt 1950 · S/N 20-14N6910DWood Robert A · Sheboygan, WIBuilt 1957 · S/N 22-4837N6911KHatley Sean P · Mount Horeb, WIBuilt 1950 · S/N 20-16N6913Cooper Steven J · Redwood City, CABuilt 1949 · S/N 16-642N6913BKeyt Jeffrey D · New Providence, NJBuilt 1956 · S/N 22-4188N6913KMedcroft Sean M · Edmonds, WABuilt 1950 · S/N 20-6N6914BLark Bradley J · Enoch, UTBuilt 1956 · S/N 22-4189N6916KBrown Daniel A · Gettysburg, PABuilt 1950 · S/N 20-18N6918Sutherland Robert · Bowling Green, KYBuilt 1959 · S/N 18-6918N6919BPolyclinics.Net LLC · Hixson, TNS/N 22-4194N6921BKnepp Gerald L · Milroy, INBuilt 1956 · S/N 22-4197N6923BWitzel John F Jr · Frenchglen, ORBuilt 1956 · S/N 22-4199N6923DCline Patrick G · Granbury, TXBuilt 1957 · S/N 22-4851N6923KLeocha Anthony J · Hampstead, NHBuilt 1950 · S/N 20-26N6926DGibson Christopher R · Natchez, MSBuilt 1957 · S/N 22-4854N6926KRed Wolf Aviation LLC · Venice, FLBuilt 1950 · S/N 20-28N6927KLord Mary E · Kalama, WABuilt 1950 · S/N 20-29N6928DRegistration Pending · West Yellowstone, MTRegistration pendingBuilt 1957 · S/N 22-4856N6929DJohnson Timothy D · Chapel Hill, NCBuilt 1957 · S/N 22-4857N6931DThomas Isaac F · Portland, ORBuilt 1957 · S/N 22-4859N6931KValiair Limited Co Trustee · Casper, WYBuilt 1950 · S/N 20-35N6932BHauser Nathan · Newark, DEBuilt 1956 · S/N 22-4210N6932KHodge Tyler · Prattville, ALBuilt 1950 · S/N 20-36N6933DRegistered aircraftBuilt 1957 · S/N 22-4861N6934BBrownlee Chase J · Billings, MTBuilt 1956 · S/N 22-4213N6934DJohnson Steven D · Pardeeville, WIBuilt 1957 · S/N 22-4862N6936KVan Bergeyk Ronald J · Trapper Creek, AKBuilt 1950 · S/N 20-38N6936ZKingsley Kiman J · Miller, MOBuilt 1964 · S/N 25-2680N6937KInternational Air Services Inc Trustee · Carson City, NVBuilt 1950 · S/N 20-34N6937ZStewarts Aircraft Service Inc · Waynesville, OHBuilt 1964 · S/N 25-2681N6938DVanaman Robbie M · Wheeling, WVBuilt 1957 · S/N 22-4866N6938ZWerth Lance C · Johnson Lake, NEBuilt 1964 · S/N 25-2682N693JBScott Alia T · Wasilla, AKBuilt 1952 · S/N 18-1255N6940BRegistered aircraftBuilt 1956 · S/N 22-4219N6941DKodysh Peter J · North Ridgeville, OHBuilt 1957 · S/N 22-4869N6941KWinter Gary L · Ocala, FLBuilt 1950 · S/N 20-45N6942DHorwitz Kenneth D · Bremerton, WAS/N 18-5690N6942KGold Cap LLC · Bremerton, WABuilt 1953 · S/N 18-2471N6942YVan Fossen Eddie L · Bakersfield, CABuilt 1994 · S/N 1809107N6943BAndrews Joshua T · Lakeview, ORBuilt 1956 · S/N 22-4223N6943KLow And Slow Aviation LLC · Williston, FLS/N 20-52N6947BB&R Aerial Crop Care Inc · Connell, WABuilt 1957 · S/N 22-4227N6948KTerch Lawrence P Jr · North Pole, AKBuilt 1950 · S/N 20-53N6949BPool Gene E · Anchorage, AKBuilt 1956 · S/N 22-4229N6949KSaverio Gambassi · Bealeton, VABuilt 1950 · S/N 20-54
Back to AD 99-01-05 R1