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.

N4285HPralle Jeffory K · Wasilla, AKBuilt 1948 · S/N 14-90N4285ZYoseph Barry L · Olympia, WABuilt 1967 · S/N 18-8534N4286ZMalcolm Rodgers K Jr · Belzoni, MSS/N 18-8599N4287ZCazac Connor · Kenai, AKBuilt 1967 · S/N 18-8536N4288HHoogendorn Homer E · Wasilla, AKBuilt 1948 · S/N 14-78N4288MMy Holdings Inc · Anchorage, AKBuilt 1947 · S/N 12-3218N4288ZAltobelli Matthew J · Dover, PABuilt 1967 · S/N 18-8601N4290HOwen Toy C · Anchorage, AKS/N 14-94N4290ZShearer John W · The Dalles, ORBuilt 1967 · S/N 18-8539N4291HDuclos Jack B · Anchorage, AKBuilt 1949 · S/N 14-95N4292HRoss Peter W Trustee · Lufkin, TXBuilt 1948 · S/N 14-45N4292MNelson Kenneth W · Duluth, MNBuilt 1947 · S/N 12-3223N4293ZSuper Cub N4293z LLC · Creston, CABuilt 1967 · S/N 18-8603N4294MBreiner Joyce K · Poolesville, MDBuilt 1947 · S/N 12-3225N4296HBogart Sean A · Anchorage, AKBuilt 1948 · S/N 14-99N4296MFowler Garry E · Post Falls, IDS/N 12-3228N4296ZSisk Michael Shaun · Steamboat Springs, COBuilt 1967 · S/N 18-8548N4297ZAcadiana Cub LLC · Abbeville, LAS/N 18-8549N4298ZAugustine Ryan M · Talkeetna, AKBuilt 1967 · S/N 18-8555N4299HCompton James D · Griffin, GABuilt 1948 · S/N 14-103N4299ZKauffman Loren C · Anchor Point, AKS/N 18-8558N4300HRasmussen Peter · Orient, OHBuilt 1948 · S/N 15-85N4300MJones Paul · Wasilla, AKS/N 12-3232N4301AStevens Constance I · Homewood, CAS/N 22-3651N4301HDrane Stephen T · Kerrville, TXBuilt 1948 · S/N 15-83N4301ZRubbert Logan · Reynolds, NDS/N 18-8609N4302MNiver Mark A · Wasilla, AKBuilt 1947 · S/N 12-3234N4302ZSportsmans Air Service Inc · Anchorage, AKBuilt 1967 · S/N 18-8611N4303ANelund Craig David · Edwardsburg, MIS/N 22-3653N4303MLight John W · Anchorage, AKBuilt 1947 · S/N 12-3235N4304AGuslick Michael M · Milwaukee, WIBuilt 1956 · S/N 22-3655N4304HZimmerman Bradley S · Greentop, MOBuilt 1954 · S/N 15-87N4305MBierlein Bruce M · Reese, MIBuilt 1947 · S/N 12-3237N4305ZMahoney Edmund Mont · Anchorage, AKBuilt 1968 · S/N 18-8614N4307AKennedy Gary R · Sanger, TXBuilt 1956 · S/N 22-3658N4307HEmerson Tiffany A · Roseville, CABuilt 1948 · S/N 15-90N4307ZDenons Flying Service Inc · Rolling Fork, MSBuilt 1967 · S/N 18-8616N4308HLeaders Bob O · Clear Lake, MNBuilt 1948 · S/N 15-91N4309AParylak Sean P · Colchester, CTBuilt 1956 · S/N 22-3661N4309HAutumn Oaks Air LLC · Chicago, ILBuilt 1948 · S/N 15-94N4309ZMccue Ryan D · Anchorage, AKBuilt 1967 · S/N 18-8619N430ABAerial Banners Inc · Pembroke Pines, FLBuilt 1966 · S/N 25-3996N4310HJohnson Ryan A · Dodgeville, WIBuilt 1948 · S/N 15-92N4312ZAlgona Aero Service Inc · Algona, IABuilt 1967 · S/N 18-8622N4313ARikansrud Eric M · Saint Petersburg, FLBuilt 1956 · S/N 22-3665N4313HStix Albert I · St Louis, MOFirst renewal noticeBuilt 1948 · S/N 15-97N4313PBradley Gerald H · Dallas, TXBuilt 1979 · S/N 18-8009006N4313YTracey Robert P · Nondalton, AKBuilt 1962 · S/N 18-7833N4314HCragg Noel J · Millbrae, CABuilt 1948 · S/N 15-96N4315HLil Dawg Aviation · Wilmington, DES/N 15-98
Back to AD 99-01-05 R1