OpenAirDocs.org
AD 99-01-05 R1

Registered aircraft · 10,638

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.

N1329AWatsabaugh Byron D Jr · Gillette, WYBuilt 1951 · S/N 18-1140N1329CHughes Steve D · Ellsworth, WIBuilt 1953 · S/N 22-1119N132LClapp William H · Mountain View, MOS/N 18-2321N132MRReese Jeffrey D · Portland, ORBuilt 1950 · S/N 18-209N1330AKost George K L · Nome, AKBuilt 1952 · S/N 18-1144N1331ACoffee Barry L · Auke Bay, AKBuilt 1951 · S/N 18-1142N1334ABrowne Alfred A · Gardnerville, NVBuilt 1951 · S/N 18-1147N1335CDorn Kevin J · De Pere, WIBuilt 1953 · S/N 22-1136N1336APluhar Charles J · Cohagen, MTBuilt 1951 · S/N 18-1151N1339CWalt'S Kustom Kreations Inc · Palatka, FLBuilt 1953 · S/N 22-1135N133FKing Tyler B · Saint Stephen, SCBuilt 1956 · S/N 22-4023N133TTroftgruben Gregory G · Buxton, NDBuilt 1953 · S/N 18-2247N1340A4031 Aviation Inc · Bemidji, MNS/N 18-1154N1342AHagenston Arthur J · Fairbanks, AKS/N 18-1167N1342CLink James R · Moses Lake, WABuilt 1953 · S/N 20-977N1343CNimer David K · Malad City, IDS/N 22-1142N1344CCreasy Frank E · Suffolk, VABuilt 1953 · S/N 22-1144N1346CWorden Gail · Burt, MIS/N 22-1145N1347AKalba Shaun B · Pleasant Valley, NYBuilt 1951 · S/N 18-1165N1348AMiller Adam S · Bend, ORS/N 18-1175N1350CBryant Stephen C · Anchorage, AKS/N 18-2513N1352CBaker Mark R · Summerland Key, FLBuilt 1953 · S/N 18-2515N1354CAklested William T · Palmer, AKS/N 18-2518N1355AStanton Fred H · Amherst, NYBuilt 1951 · S/N 18-1179N1357ACarson Cubs LLC · Yelm, WABuilt 1951 · S/N 18-1181N1358ASchroeder Herbert P · Eagle River, AKBuilt 1951 · S/N 18-1184N135ESStutzer Lukas P · Chugiak, AKBuilt 1981 · S/N 18-8109074N135KAMccarthy Kiva A · Wasilla, AKBuilt 1973 · S/N 18-7309021N135KSBunde Konstantine E · Goldendale, WABuilt 1956 · S/N 18-4061N135RBWalter Caleb · Buffalo, WYS/N 18-3630N135WKGerlach Robert · Talkeetna, AKBuilt 1952 · S/N 182160N135WMTownsend Richard A · Wasilla, AKBuilt 1954 · S/N 18-3599N1363AHale Mitchell D · Chugiak, AKBuilt 1951 · S/N 18-1189N1364AFranz Stanley · Yakima, WABuilt 1951 · S/N 18-1190N1364CRush Christopher C · Anchorage, AKS/N 18-2613N1364PVinduska John A · Palmer, AKBuilt 1965 · S/N 18-8265N1365ARegistration Pending · Wasilla, AKRegistration pendingS/N 18-1193N1365CSchultz Kenneth W · Ekalaka, MTBuilt 1953 · S/N 18-2536N1366AT & E Inc · Fowler, KSBuilt 1951 · S/N 18-1195N1366CKuzina Ronald E · Wasilla, AKBuilt 1953 · S/N 18-2616N1367ALl Wings LLC · Minnetonka, MNBuilt 1951 · S/N 18-1196N1367CFerguson Bruce W · Fort Peck, MTBuilt 1953 · S/N 18-2626N1368AMcknight Thomas N · Fredericksburg, TXBuilt 1951 · S/N 18-1197N136CCShelk John Brian · Bend, ORBuilt 2002 · S/N 9953CCN136JMGregory Warren D Jr · Aguila, AZBuilt 1963 · S/N 22-5557N1371CVaughan Jeremy L · Alton, VABuilt 1953 · S/N 18-2624N1372ABice Donald L · Winner, SDBuilt 1951 · S/N 18-1203N1377AFar Horizon LLC · Bighorn, MTS/N 18-1208N1378ADray LLC · Bridgeport, NEBuilt 1951 · S/N 18-1209N137TMonno Joseph P · Hastings, MNBuilt 1953 · S/N 18-2251
Back to AD 99-01-05 R1