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.

N3903PPeterman Michael N · Huron, OHBuilt 1956 · S/N 22-3572N3903ZBrown Michael S · Kenai, AKS/N 18-7715N3904MCowan Drew P · Anchorage, AKBuilt 1947 · S/N 12-2803N3904PJohnson Rusty E · Enumclaw, WAS/N 22-3573N3904ZHorney Paul E · Fort Sumner, NMBuilt 1961 · S/N 18-7717N3905MTaro Brian James Trustee · Ketchikan, AKS/N 12-2585N3906MCarroll Dan L · Soldotna, AKS/N 12-2805N3906PJb Efta Farms Inc · Argyle, MNS/N 22-3575N3907KMcmanamin Conor P · Anchorage, AKBuilt 1961 · S/N 18-7543N3908ZWiederkehr Air Inc · Palmer, AKBuilt 1961 · S/N 18-7721N390CCKenmore Air Harbor LLC · Kenmore, WABuilt 2002 · S/N 9944CCN390SCJacobs Jim · Great Barrington, MABuilt 1950 · S/N 18-194N3910MHodges Larry W · Lees Summit, MOBuilt 1947 · S/N 12-2808N3910ZHudson Ollie C · Talkeetna, AKBuilt 1961 · S/N 18-7726N3911MDeppmeyer Thomas · Woodgate, NYBuilt 1947 · S/N 12-2809N3913MHagman Jeffrey W · Saint Bonifacius, MNBuilt 1947 · S/N 12-2811N3914MNatwick Micah E · Anchorage, AKS/N 12-2812N3914POrtiz Fernando Mark · Squaw Valley, CAS/N 22-3584N3914ZHaefeli Thomas · Del Norte, COBuilt 1961 · S/N 18-7731N3915EPiper Aircraft Inc · Vero Beach, FLBuilt 1980 · S/N 18-8109017N3915PDryer Lucien E · Boise, IDBuilt 1956 · S/N 22-3585N3915ZHigh Exposure Inc · Wilmington, DEBuilt 1961 · S/N 18-7733N3916ZSimon Mitchell B · Edison, NJBuilt 1961 · S/N 18-7740N3917ZLittlejohn Travis J · Wichita, KSBuilt 1961 · S/N 18-7741N3918ZLautrup Joel W · Palmer, AKBuilt 1961 · S/N 18-7742N3919ZPrice Kenneth R Sr · Woodland, CABuilt 1961 · S/N 18-7743N3920MBergstedt Jon P · Anchorage, AKS/N 12-2588N3920ZRembelski Jason · Challis, IDBuilt 1961 · S/N 18-7744N3921MJoslin David W · Seward, AKBuilt 1947 · S/N 12-2817N3921PRadwanick Louis S · Virginia Beach, VABuilt 1957 · S/N 22-3591N3922PMoulton Robert Paul · Middletown, NYBuilt 1955 · S/N 22-3594N3924MNiles Air LLC · Concord, NCBuilt 1947 · S/N 12-2826N3924PYetter Mark · Georgetown, PABuilt 1956 · S/N 22-3597N3926ZCarlson Jeffrey D · Ashville, NYBuilt 1961 · S/N 18-7752N3927PLenz Jerry L · Loveland, COBuilt 1956 · S/N 22-3600N3927ZNordstrom Eric Trustee · Anchorage, AKS/N 18-7755N3928ZFish And Feathers Aviation LLC · Soldotna, AKS/N 18-7775N3929ZShaffer Carl E · Fort Bragg, CABuilt 1962 · S/N 18-7776N392CCCecil John P · Willows, CAFirst renewal noticeBuilt 2003 · S/N 9960CCN3930PMatson Dean R · Spring, TXBuilt 1956 · S/N 22-3605N3930ZDaniel Junior G · Wasilla, AKS/N 18-7777N3931MBrehm Mensink Tracie M · Preston, MNS/N 12-2110N3932PCuozzo Alfred F · Eagle Point, ORBuilt 1956 · S/N 22-3607N3932ZKnefley J Michael · Ulysses, PABuilt 1961 · S/N 18-7756N3933MLee Gary W Trustee · Oklahoma City, OKBuilt 1947 · S/N 12-2829N3933ZRyan Alan Parks · Newcastle, WYBuilt 1962 · S/N 18-7757N3934ZWard Gary P · Lincolnton, GABuilt 1962 · S/N 18-7780N3935MShuster David Joseph · Marmora, NJBuilt 1947 · S/N 12-2823N3936PTroyer Robert E · Toledo, WABuilt 1956 · S/N 22-3611N3937MDowns Douglas · Fairbanks, AKS/N 12-2825
Back to AD 99-01-05 R1