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.

N7690HSandstrom Brandon M · Palmer, AKBuilt 1946 · S/N 12-580N7691HSanders Wes E · Palos Park, ILBuilt 1946 · S/N 12-581N7694KKingsley Jacob R · Oscoda, MIS/N 20-517N7695KChase 13 LLC · Wilmington, DES/N 20-515N7696DLottman Aviation LLC · Beatrice, NES/N 18-5924N7696LMacys Flying Service Inc · Tulelake, CABuilt 1974 · S/N 18-7409124N7697DWells Jason R · Chugiak, AKBuilt 1957 · S/N 18-5925N7697HMashburn Daniel T Jr · Bolton, MSS/N 12-588N7697ZTri-State Aerial LLC · Canton, SDBuilt 1966 · S/N 25-3856N769AKThomas Cole A · Fairbanks, AKBuilt 1975 · S/N 18-7609017N76ELRed Willow Rescue Inc · Cooperstown, NDBuilt 1957 · S/N 18-6189N76EVKuhn Bernard O · Ripon, CABuilt 1976 · S/N 18-7609103N76MMRichardson John H · Monticello, NMBuilt 1957 · S/N 18-6031N76PQBoyd Benjamin L · Kila, MTBuilt 1976 · S/N 18-7609130N76RWThomas Allen C · Willow, AKBuilt 1953 · S/N 18-1886N76WWOakley James H · Spring Valley, CABuilt 1976 · S/N 18-7609114N76XGreen Steven L · Fairbanks, AKBuilt 1948 · S/N 12-4036N7701DChrysler Sheldon A · Pueblo, COFirst renewal noticeS/N 22-5372N7701HRenshaw Raymond E · Huntersville, NCBuilt 1946 · S/N 12-592N7702DAnderson Leonard M · Lakeside, MTS/N 22-5374N7703DBureau Todd M · Hope, AKS/N 22-5375N7703HWatt Ernie T · Scooba, MSS/N 12-594N7703ZBarrett Jane T · Tehachapi, CABuilt 1966 · S/N 25-3863N7704ZAerial Banners Inc · Pembroke Pines, FLBuilt 1966 · S/N 25-3864N7705DPumphrey Ronald W · Houston, MSFirst renewal noticeBuilt 1957 · S/N 22-5377N7705HNordic Flyers Inc · Plymouth, MNBuilt 1946 · S/N 12-597N7706HSgarrella William G Jr · Lovettsville, VABuilt 1946 · S/N 12-598N7708DR & R Hays Corp · Cody, WYBuilt 1957 · S/N 22-5380N7708HJohnson Stephen C · Bonney Lake, WABuilt 1946 · S/N 12-600N7709DAk8 Assets LLC · Talkeetna, AKBuilt 1957 · S/N 22-5381N7709HNewberg Curtis G · Willmar, MNS/N 12-601N770VKlippert Kevin T · El Dorado, ARBuilt 1939 · S/N 4-730N7710HStockmans Service & Supply LLC · Rushville, NEBuilt 1946 · S/N 12-602N7711KVisser Paul C · Junction City, KSBuilt 1950 · S/N 20-532N7712HMiller Kevin T · Wasilla, AKBuilt 1946 · S/N 12-604N7713KNottorf Eric W · Keller, TXBuilt 1950 · S/N 20-535N7714DZapata James A · Fallbrook, CABuilt 1957 · S/N 22-5388N7714ZSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1966 · S/N 25-3877N7715DIriarte Christopher P · Grosse Ile, MIBuilt 1957 · S/N 22-5389N7715ZMiller Aviation Inc · Norton, KSBuilt 1966 · S/N 25-3878N7716ZBig Aerial Sign Service LLC · Delano, MNBuilt 1966 · S/N 25-3881N7717HJohnson Paul C · Tower, MNBuilt 1946 · S/N 12-610N7719HBurks Richard H · Protem, MOBuilt 1946 · S/N 12-612N7719KHillegeist Tracy L · Beverly, KSBuilt 1950 · S/N 20-541N7720DBarnhill Jerry D · Longville, LABuilt 1957 · S/N 22-5394N7720ZAnderson Joel M · Starkweather, NDBuilt 1966 · S/N 25-3886N7721DRenick Tyler C · Wichita Falls, TXBuilt 1957 · S/N 22-5395N7721HRegistration Pending · Juneau, AKRegistration pendingS/N 12-614N7722HRickman Allen K · Absarokee, MTBuilt 1946 · S/N 12-616N7722ZCentral California Soaring Association Inc · Avenal, CABuilt 1966 · S/N 25-3889
Back to AD 99-01-05 R1