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.

N1263CWidman Ralph W · Lynchburg, OHBuilt 1953 · S/N 22-1058N1264APierskalla Nicolas B · Wasilla, AKBuilt 1951 · S/N 18-1060N1264CCoulter Clint C · Texline, TXBuilt 1953 · S/N 22-1060N1265AWalker Matthew J Trustee · Delta Junction, AKS/N 18-1061N1268ATegerdine Charley D · Sterling, AKBuilt 1951 · S/N 18-1063N126GSSanoski Gregory G · Talkeetna, AKS/N 12-1270N126THentges Kelley R · Frazer, MTS/N 18-2240N1270ASnow Richard C · Wasilla, AKBuilt 1951 · S/N 18-1065N1270CSchnack Kenneth L · Crescent, IABuilt 1953 · S/N 22-1063N1272AJacoby Peter A · Tucson, AZBuilt 1951 · S/N 18-1068N1277AWagner Tyler M · Sitka, AKBuilt 1951 · S/N 18-1072N1278ARegistration Pending · Palmer, AKRegistration pendingBuilt 1951 · S/N 18-1074N127CCKiser Aviation LLC · Grottoes, VAS/N 9949CCN127GSSanoski Gregory G · Talkeetna, AKS/N 12-273N127TBenham Charles · Lorena, TXBuilt 1952 · S/N 18-2241N1280CRoesch Karl L · Arlee, MTBuilt 1953 · S/N 22-1078N1282CSpivey Harold E · Thomaston, GABuilt 1953 · S/N 22-1076N1283AFritz David A · Wasilla, AKBuilt 1951 · S/N 18-1087N1283CZawada Matthew J · Roberts, MTBuilt 1953 · S/N 22-1079N1289CGordon Robert Earl · Sanford, NCS/N 22-1110N128DVAerial Sign North · Lakewood, NJBuilt 1955 · S/N 18-4366N128KTClaus Logan D · Chitna, AKBuilt 1975 · S/N 18-7509089N1291ASeale Sidney Joseph · Condon, ORBuilt 1951 · S/N 18-1094N1291CVand Flyve Klub · Newfolden, MNS/N 18-2502N1294AHubbard John H · Riverside, WAS/N 18-1097N1295AJenski Kobie · Sutton, AKBuilt 1951 · S/N 18-1098N1297AOrwick Robert J · Newell, SDS/N 18-1101N129CCChilds David E · Amber, OKBuilt 2002 · S/N 9951CCN12MZRatfield Dwaine C · Onamia, MNS/N 12-2930N12TASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1958 · S/N 22-6319N12ZFJohnson Ross · Anderson, SCBuilt 2000 · S/N 9912CCN1300CSelf James M · Fennville, MIBuilt 1953 · S/N 22-1102N1301CPiper Aviation Museum Foundation · Lock Haven, PABuilt 1953 · S/N 22-1095N1303CRodriguez Isaac J · Fort Smith, ARS/N 22-1098N1304ABilben Steve W · Kasilof, AKBuilt 1951 · S/N 18-1108N1305AAir Dakota Flite Inc · Hettinger, NDBuilt 1951 · S/N 18-1109N1308CHahn Aviation Inc · Troy, OHBuilt 1953 · S/N 22-1112N1312ABowen Haldor S · Sandpoint, IDBuilt 1951 · S/N 18-1114N1312CApplegate Paul H · Queen City, MOBuilt 1953 · S/N 22-1104N1313Cochrane Timothy A · Chippewa Lake, OHS/N 1809013N1314AK & D Livestock Inc · Volborg, MTBuilt 1951 · S/N 18-1120N1317ADixon Douglas C · Anchorage, AKBuilt 1951 · S/N 18-1124N131ABPlane And Simple Leasing LLC · Delano, MNBuilt 1965 · S/N 25-3693N131SCSum Livestock LLC · Ekalaka, MTS/N 18-7609060N1320ATerra Firma Aviation LLC · Bowman, CABuilt 1951 · S/N 18-1126N1320CToney Tasha Fay · Lafayette, INS/N 22-1116N1322AWrobel Sean M · Weatherford, TXBuilt 1951 · S/N 18-1128N1324AJagow Charles P · Fairbanks, AKBuilt 1951 · S/N 18-1134N1324CLawrence Mark J · Rouses Point, NYS/N 22-1131N1325AAlaskas Cub Training Specialists LLC · Wasilla, AKBuilt 1951 · S/N 18-1139
Back to AD 99-01-05 R1