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.

N5187HJinnette Michael E · Lafayette, COS/N 14-505N5187ZCottrell Mark C · Leitchfield, KYS/N 22-8854N5188HHartley Jerome K · Talkeetna, AKBuilt 1949 · S/N 14-506N5189ZNorthwest Florida State College · Niceville, FLBuilt 1961 · S/N 22-8856N518GMMountain Escape LLC · Pullman, WABuilt 1953 · S/N 18-2643N518SWGilchrist Robert T · White Salmon, WABuilt 1955 · S/N 18-4389N518TCBedell Gary L · Henderson, NVBuilt 2001 · S/N 9932CCN5191HPearce David W Trustee · Anchorage, AKBuilt 1949 · S/N 14-509N5191ZFlickinger Charles P · Hermitage, PABuilt 1961 · S/N 22-8859N5192HAlexander Steve T · Wasilla, AKS/N 14-510N5193ZSchlosser Joseph V · Rockford, MNBuilt 1961 · S/N 22-8862N5194HGottschalk Jon R · Stuart, FLBuilt 1949 · S/N 14-494N5194ZTinsman Anthony L · Hartford, ARBuilt 1961 · S/N 22-8863N5195HFowler Raymond D · Homer, AKBuilt 1949 · S/N 14-496N5197ZPalmer Ralph Jr · Howard City, MIS/N 22-8867N5199ZLeister Tyler W · Norfolk, VABuilt 1961 · S/N 22-8869N519TCSchoepflin Robert Dennis · Palouse, WABuilt 1957 · S/N 18-6027N519WGThunderbird Photography LLC · Greenville, CABuilt 2003 · S/N 9964CCN51QTGordon David A · Sitka, AKBuilt 1957 · S/N 18-905N51SGStout Randall Trustee · Springfield, ORS/N 18-7084N51TRRomero Anthony A · Tucson, AZS/N 20-681N5201ZNunn Adam L · Abilene, TXBuilt 1961 · S/N 22-8871N5203ZWeigel Gary R · Valley City, OHBuilt 1961 · S/N 22-8873N5204ZGodbey Patrick E T · St Simons Island, GABuilt 1961 · S/N 22-8874N5206HMccallum Michael C · Delta, COBuilt 1949 · S/N 16-7N5206ZFord Dustin D · Clear Brook, VABuilt 1961 · S/N 22-8876N5208HSweet Richard S · Prior Lake, MNBuilt 1949 · S/N 16-10N5208ZArnold Tyler S · Montgomery, LAS/N 22-8878N5209HCook James F · Portland, ORBuilt 1949 · S/N 16-11N5212ZYetter Mark A · Georgetown, PABuilt 1961 · S/N 22-8884N5214HVagabond Flight Corporation · Decatur, ILBuilt 1949 · S/N 16-15N5215HDavis Ted E · Brodhead, WIBuilt 1949 · S/N 16-17N5216HWatkins John W · Somers, CTBuilt 1944 · S/N 16-18N5219ZGarrett Joe · Saint Jacob, ILBuilt 1961 · S/N 22-8894N5222HDavidson Gerald W · Okatie, SCBuilt 1949 · S/N 16-24N5222ZSaltzman John D · Gilbert, AZBuilt 1961 · S/N 22-8897N5223HSzorek Evelyn Personal Representative · Fairbanks, AKBuilt 1949 · S/N 16-25N5225ZLamon Bruce G · Castle Rock, WABuilt 1961 · S/N 22-8901N5226HJockos Sleigh LLC · Fort Worth, TXBuilt 1949 · S/N 16-28N5226ZHale Michael E · Grass Valley, CABuilt 1961 · S/N 22-8902N5227HBowman Brent W · Sebewaing, MIS/N 16-31N5227ZPayne Robert A · Duluth, MNBuilt 1961 · S/N 22-8903N5229HCahoon Theodore J · Erie, COBuilt 1949 · S/N 16-33N522BBolster Stacey · Williamsburg, VABuilt 1956 · S/N 18-4788N522DNLinett Michael J · Elsmere, DEBuilt 1959 · S/N 226587N5230HSeneca Aeronautical Services LLC · Wilmington, DES/N 16-34N5231ZKawasaki Clyde H · Carson City, NVS/N 22-8908N5232ZGilmore Thomas E · Mesa, AZBuilt 1961 · S/N 22-8910N5235HMoore Jeffrey D · Cleveland, NYBuilt 1949 · S/N 16-39N5236ZPlank Larry B · Perkins, OKBuilt 1961 · S/N 22-8916
Back to AD 99-01-05 R1