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.

N9966QParker Christopher W · Penngrove, CABuilt 1955 · S/N 18-3984N9967QTaildragon LLC · Boise, IDBuilt 1954 · S/N 18-4012N9968QErmatinger Daniel L · Missoula, MTS/N 18-4013N9969QPerry Sarah Ellen Executor · Garwood, TXS/N 18-4015N996CCL-Bird LLC · Hood River, ORBuilt 2000 · S/N 9914CCN9971DAhern Daniel Patrick · Oxford, NCS/N 22-6762N9971QPierce Alvin A · Soldotna, AKBuilt 1954 · S/N 18-4024N9973DRoadarmel Brandon L · Three Forks, MTS/N 22-6764N9974QJohnson Timothy D · Chapel Hill, NCBuilt 1953 · S/N 18-4033N9976DHamon Troy R · King Salmon, AKBuilt 1959 · S/N 22-6767N9976QStinnett James B · Downers Grove, ILBuilt 1954 · S/N 18-4040N9977DMesserla David M · Manhattan, KSBuilt 1959 · S/N 22-6768N9977QShepphird John C · Reno, NVS/N 18-3575N9977YBenninger Timothy A · Cobleskill, NYBuilt 1967 · S/N 18-8587N997CCWunorse Openslae LLC · Dallas, TXBuilt 2000 · S/N 9915CCN997UPPotti Noah · Kalispell, MTBuilt 1950 · S/N 20-246N9985DTrimmer Marvin E · Willow, AKBuilt 1959 · S/N 22-6777N9986DWalsh Arthur B · Lincoln, NERegistration revokedBuilt 1959 · S/N 226778N998CCBecker Mike DBA · La Grande, ORBuilt 2000 · S/N 9916CCN9991DNothum Robert G · Dixon, MOBuilt 1959 · S/N 22-6783N9993DMunson Matthew C · Canby, ORBuilt 1959 · S/N 22-6786N9993HCarlsfrom Thomas A · Bonita Springs, FLBuilt 1943 · S/N 5-1473N9994DKnudsen Ernest W Jr · Ennis, TXBuilt 1959 · S/N 22-6787N9998DHarkins Cody · Grover, WYS/N 22-6791N9999ALake Mark S · Erie, COBuilt 1955 · S/N 22-2842N9999DAnderson Corlin L · North Branch, MNBuilt 1959 · S/N 22-6792N999BATeslow Timothy W · Fairbanks, AKBuilt 1977 · S/N 18-7709138N999EOwens Wilbur · Rancho Palos Verde, CABuilt 1947 · S/N 12-2060N999HKGeboy Alan R II · Newnan, GABuilt 1952 · S/N 22-574N999JVWatson James W · Fairbanks, AKBuilt 1989 · S/N 1809005N999NTHolbrook Joel · Delta Junction, AKS/N 22-5225N999TXDel Mar College · Corpus Christi, TXBuilt 1960 · S/N 25392N999VLHeidt Brian F · Owosso, MIBuilt 1958 · S/N 22-6451N99PJLarose Gary R · Anchorage, AKS/N 18-7509141N99ZWWyckoff Kevin D · Wasilla, AKBuilt 1958 · S/N 18-6148N9KTJacelon Charles E · Little River, SCBuilt 1946 · S/N 12-1625N9RRyder Dean DBA · Carmel, NYS/N 18-7809025N9YVChampness Daniel N · Bakersfield, CABuilt 1971 · S/N 18-8926N9ZUFowler Ronald W · Lopez Island, WABuilt 1959 · S/N 18-7028
Back to AD 99-01-05 R1