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.

N5139ZKnarr Perry Lee · Lock Haven, PABuilt 1961 · S/N 22-8782N5142HThistle Richard J · Wasilla, AKBuilt 1948 · S/N 14-152N5142ZFlorey Carl L · Eureka, MTBuilt 1961 · S/N 22-8791N5143ZHonkala Michael R · Wasilla, AKS/N 22-8789N5144ZUlrich Kenneth B Jr · Kingwood, TXBuilt 1961 · S/N 22-8790N5145HFoust Michael L · Soldotna, AKBuilt 1948 · S/N 14-155N5146HTundra Aviation Inc · Casselton, NDBuilt 1948 · S/N 14-156N5146ZBeloit Aviation LLC · Beloit, WIBuilt 1961 · S/N 22-8792N5149HLeaders Bob O · Clear Lake, MNBuilt 1948 · S/N 14-159N5149ZWeishaar Wallace · Livingston, TXBuilt 1961 · S/N 22-8797N5150HGregorin Richard C · Anchorage, AKBuilt 1948 · S/N 14-160N5150ZBarilov Yekaterina · Santa Paula, CABuilt 1961 · S/N 22-8800N5151HHirons John L · Eugene, ORBuilt 1966 · S/N 14-161N5151ZSanve Edwin K · Elk City, OKBuilt 1961 · S/N 22-8801N51542Gaddy Sam O · Bluff Dale, TXS/N 10570N5154ZSexton Gregory · Jordan, MNS/N 22-8804N5155ZTowe Billy Joe Jr · Decatur, ALBuilt 1961 · S/N 22-8806N5156HIndigenous Peoples Technology & Education Center · Dunnellon, FLBuilt 1948 · S/N 14-28N5157HSchwend Brian · Forsyth, MTBuilt 1948 · S/N 14167N5158HWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1948 · S/N 14-168N5159HH&H Restoration LLC · Wasilla, AKBuilt 1948 · S/N 14-169N5159ZSiegel Scott A · Inez, KYS/N 22-8813N5160HNiemi Danny L · Osage, MNBuilt 1948 · S/N 14-170N5160ZWend Roger W · Charlotte, MIBuilt 1961 · S/N 22-8814N51627Warren David T · Mobile, ALS/N 18-8562N5164ZEast Texas Aircraft Engines LLC · Palestine, TXS/N 22-8819N5166ZTuttle Anthony G · Walnut Cove, NCBuilt 1961 · S/N 22-8824N51675Crawford Aviation Services LLC · Flagstaff, AZBuilt 1968 · S/N 18-8571N5167ZRamsdell Edmun · Modesto, CABuilt 1961 · S/N 22-8825N5168HBenallo Joseph D · Homer, AKBuilt 1948 · S/N 14-179N5168ZBrown Noah M · Tyler, TXS/N 22-8826N5169ZManning David G · Greenville, NCBuilt 1961 · S/N 22-8829N516DDFawcett Walter L Jr · Wolfeboro, NHBuilt 1981 · S/N 18-8109010N5170AHamilton Dennis A · Seward, AKS/N 183622N5172ZTurner William J · Twentynine Palms, CABuilt 1961 · S/N 22-8836N5173ZSvenningse Joshua J · Menomonie, WIBuilt 1961 · S/N 22-8837N5174ZSale Reported · Spearfish, SDSale reportedBuilt 1961 · S/N 22-8838N5175DSlug Air LLC · White Salmon, WABuilt 1966 · S/N 18-8438N5176HBoyer Christopher A · Anchorage, AKBuilt 1948 · S/N 14-196N5176MDotzenroth David A · Watertown, MNS/N 12-2835N5178AHale Mitchell D · Chugiak, AKBuilt 1962 · S/N 18-7483N5178HGage Scott M · Anchorage, AKS/N 14-200N5178ZUnderwood Robert D Jr · Randolph, NYBuilt 1961 · S/N 22-8842N517WCFreedom Wings LLC · Parker, COBuilt 1993 · S/N 1809065N5180ZScheer Paul G · Portland, ORBuilt 1961 · S/N 22-8846N5183HLlewellyn John M · Grangeville, IDBuilt 1949 · S/N 14-501N5184HReynolds Michael A · Fairbanks, AKBuilt 1949 · S/N 14-502N5184ZCox Ronnie · Whitesburg, GABuilt 1961 · S/N 22-8851N5185ZTroy Michael J · Albion, NYS/N 22-8852N5186ZBearer Ronald C · Wimauma, FLBuilt 1961 · S/N 22-8853
Back to AD 99-01-05 R1