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.

N4510YFrost John David Trustee · Anchorage, AKBuilt 1972 · S/N 18-8931N4510ZLamphere Michael T · Whitehall, NYBuilt 1960 · S/N 22-8012N4511MSleeper Ken L · Anchorage, AKBuilt 1947 · S/N 11-14N4511YWab Air LLC · Boulder, MTBuilt 1971 · S/N 18-8932N4511ZKim Andrew · Upland, CABuilt 1960 · S/N 22-8013N4512YNohrenberg Redge O · Pingree, NDBuilt 1966 · S/N 25-4078N4513YAlbertson James M · Slocomb, ALBuilt 1966 · S/N 25-4019N4515HLindstrom Dale R · Kewanee, ILBuilt 1948 · S/N 15-288N4515YArthur Aviation LLC · Arthur, NDBuilt 1966 · S/N 25-4148N4516MSatran Laurel L · Detroit Lakes, MNBuilt 1947 · S/N 11-20N4517AShepherd Joseph Gary · Sharpsburg, GABuilt 1956 · S/N 22-3823N4517YHoffmann Earl R Jr · Wildwood, MOBuilt 1966 · S/N 25-4167N4518AJensen Dustin C · Santa Clara, UTS/N 22-3824N4518HThompson Raymond Jr · South Bend, INS/N 15292N4518ZHoecher Robert T · Anchorage, AKBuilt 1960 · S/N 22-8020N4520ACoogan Timothy J · Anchorage, AKBuilt 1957 · S/N 22-3827N4521YKron Howard H · Clara City, MNBuilt 1966 · S/N 25-4072N4521ZWeichert Eric S · Janesville, MNBuilt 1960 · S/N 22-8008N4522ABryant Stephen · Anchorage, AKS/N 22-3829N4522YAerial Messages Leasing Co · Longwood, FLBuilt 1966 · S/N 25-4030N4525MVeal Tim A · Kenai, AKBuilt 1947 · S/N 11-28N4526AMathews William A · Albuquerque, NMBuilt 1956 · S/N 22-3834N4526MGlasheen Sean T · Bethel, AKBuilt 1947 · S/N 11-31N4526ZArmstrong Brandon M · Sierra Vista, AZBuilt 1961 · S/N 22-8029N4527AMacking Craig P · Sepulveda, CABuilt 1956 · S/N 22-3835N4527HStewart Thomas D · Cashmere, WABuilt 1948 · S/N 15-300N4528HDavis Rick L · Everett, WAS/N 15-301N4528MBatie Russell J · Colstrip, MTBuilt 1947 · S/N 11-32N4529ACoffey County Airport · Burlington, KSBuilt 1956 · S/N 22-3838N4529HPayne William C · Duluth, MNBuilt 1948 · S/N 15-303N4529ZDaigle Michael R · Andover, NHBuilt 1961 · S/N 22-8032N452AKSalo Mark W · Poulsbo, WABuilt 1946 · S/N 12-867N4530HJed Aire Aviation LLC · Benson, MNBuilt 1948 · S/N 15-302N4530YSchindler Rick M · Neligh, NEBuilt 1966 · S/N 25-4143N4530ZKirby Andrew P · Strattanville, PABuilt 1960 · S/N 22-8035N4531HTerris Edward A · BucksBuilt 1948 · S/N 15-305N4531ZFelts Jacob I · Kalispell, MTBuilt 1960 · S/N 22-8036N4532ARasmussen Duane T · Culbertson, MTBuilt 1956 · S/N 22-3841N4532MObrien James P · Mullen, NEBuilt 1947 · S/N 11-36N4533AMount David B · Fairbanks, AKBuilt 1956 · S/N 22-3842N4533MGaskill Douglas D · Miles City, MTS/N 1138N4533ZDavis Taylor M · Doylestown, PABuilt 1961 · S/N 22-8038N4534HRevoir Scott R · Hastings, NYBuilt 1948 · S/N 15-307N4534ZKay Bennie L · Brigham City, UTBuilt 1960 · S/N 22-8039N4535MGold James M · Kerrville, TXBuilt 1947 · S/N 11-39N4536MChristensen Robert P · Ashton, IDBuilt 1947 · S/N 11-40N4538AHughes William L · Fort Worth, TXFirst renewal noticeBuilt 1956 · S/N 22-3847N4538MHorner Edwin R · Howard, PABuilt 1947 · S/N 11-42N4538YKnutson Wayne R · Thompson, NDFirst renewal noticeBuilt 1967 · S/N 25-4184N4539ASvenningsen Joshua J · Menomonie, WIBuilt 1956 · S/N 22-3848
Back to AD 99-01-05 R1