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.

N4370MDunker Arden J · Boise, IDBuilt 1947 · S/N 12-3306N4371AWest Transport LLC · Anchorage, AKBuilt 1956 · S/N 18-4773N4371HLazor Ron · Middlefield, CTBuilt 1948 · S/N 15-155N4371ZChow Kamahele Taylor · Homer, AKBuilt 1968 · S/N 18-8693N4372APex John A · Chugiak, AKBuilt 1956 · S/N 18-4774N4372HMathys Greg A · Marysville, OHBuilt 1948 · S/N 15-156N4372MRegistration Pending · Tulsa, OKRegistration pendingBuilt 1947 · S/N 12-3308N4373YMohr Robert J · Wausau, WIBuilt 1946 · S/N 12-1440N4374ZLasseter Granville D II · Richmond, TXBuilt 1968 · S/N 18-8696N4375HOestreich Scott W · Wausau, WIBuilt 1948 · S/N 15-160N4375MKrapels Keith A · Huntsville, ALBuilt 1947 · S/N 12-3319N4375ZRwr Air Inc · Tok, AKBuilt 1968 · S/N 18-8697N4376ZLabbee Tyler J · White Swan, WABuilt 1968 · S/N 18-8698N4377HJones Rick R · Greenville, NCBuilt 1948 · S/N 15-163N4377MBeach Banners Inc · Jacksonville, FLBuilt 1947 · S/N 12-3311N4378MWilson Robert A · England, ARS/N 12-3314N4378YDahl Russell A · Nashua, MTBuilt 1971 · S/N 18-8922N4378ZFore Henry R · Hope, IDBuilt 1968 · S/N 18-8700N4379HBurns Barry D · Amarillo, TXBuilt 1948 · S/N 15-164N4379ZAmidon Gary S · Shady Cove, ORBuilt 1968 · S/N 18-8701N43806Heard Jesse H · Lewiston, IDBuilt 1974 · S/N 18-7409049N4380HBrodin Terry E · South Haven, MIBuilt 1948 · S/N 15-165N4380MTalkeetna Aviation LLC · Talkeetna, AKS/N 12-3316N4380ZMike Harmon Aviation LLC · Mansfield, SDBuilt 1968 · S/N 18-8703N4381AN4381a Inc · Shoreview, MNS/N 18-4787N4382HJohnson Steven D · Pardeeville, WIBuilt 1948 · S/N 15-167N4382ZFlerlage Katy Anne · Maple Hill, KSBuilt 1968 · S/N 18-8706N4383HRivenbark Maurice G · Floral City, FLBuilt 1948 · S/N 15-168N4383ZBredthauer Glen E · Hastings, NEBuilt 1968 · S/N 18-8683N4384AJourneys Aviation Inc · Boulder, COBuilt 1956 · S/N 18-4792N4384HMiller Rodney M · Ripon, WIBuilt 1948 · S/N 15-169N4384ZSilent Knights Inc · Ankeny, IAFirst renewal noticeBuilt 1968 · S/N 18-8685N4385YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N 25-4892N4385ZFinney James R · Howe, TXBuilt 1974 · S/N 18-7409044N4386AShannon Christopher R · Nome, AKS/N 18-4794N4386HOrf Aviation LLC · Wentzville, MOBuilt 1948 · S/N 15-171N4386YSoaring Club Of Houston · Waller, TXBuilt 1969 · S/N 25-4893N4386ZBallard David L Trustee · Chugiak, AKBuilt 1968 · S/N 18-8708N4387AMcgahan Cody · Nikiski, AKBuilt 1956 · S/N 18-4795N4387MBedard Michael J Trustee · Madison, ALBuilt 1947 · S/N 12-3325N4388AVan Wagner Aerial Media LLC · Pembroke Pines, FLBuilt 1956 · S/N 18-4796N4388ZWooliver Steve P · Wasilla, AKFirst renewal noticeBuilt 1968 · S/N 18-8714N4389ZZaczkowski Paul S · Tok, AKBuilt 1968 · S/N 18-8716N4390ZAlsade Ltd · Big Piney, WYBuilt 1968 · S/N 18-8717N4391ZAshby Scott J · Lemoore, CABuilt 1968 · S/N 18-8720N4392APeterson Kerry J · Toston, MTBuilt 1956 · S/N 18-4801N4392MVinton Timothy R · Whitman, NES/N 12-3330N4393ZWilliams Aircraft LLC · Anchorage, AKBuilt 1968 · S/N 18-8724N4394MPachl John A · Forsyth, MTBuilt 1947 · S/N 12-3332N4394ZSherman Kent L · Sterling, AKS/N 18-8725
Back to AD 99-01-05 R1