AD 60-01-07

Registered aircraft · 3,967

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:60-01-07')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:60-01-07')
  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.

N1270CSchnack Kenneth L · Crescent, IABuilt 1953 · S/N 22-1063N127GSSanoski Gregory G · Talkeetna, AKS/N 12-273N1280CRoesch Karl L · Arlee, MTBuilt 1953 · S/N 22-1078N1282CSpivey Harold E · Thomaston, GABuilt 1953 · S/N 22-1076N1283CZawada Matthew J · Roberts, MTBuilt 1953 · S/N 22-1079N1289CGordon Robert Earl · Sanford, NCS/N 22-1110N12MZRatfield Dwaine C · Onamia, MNS/N 12-2930N12TASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1958 · S/N 22-6319N1300CSelf 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-1098N1308CHahn Aviation Inc · Troy, OHBuilt 1953 · S/N 22-1112N1312CApplegate Paul H · Queen City, MOBuilt 1953 · S/N 22-1104N1320CToney Tasha Fay · Lafayette, INS/N 22-1116N1324CLawrence Mark J · Rouses Point, NYS/N 22-1131N1329CHughes Steve D · Ellsworth, WIBuilt 1953 · S/N 22-1119N1335CDorn Kevin J · De Pere, WIBuilt 1953 · S/N 22-1136N133FKing Tyler B · Saint Stephen, SCBuilt 1956 · S/N 22-4023N1343CNimer David K · Malad City, IDS/N 22-1142N1344CCreasy Frank E · Suffolk, VABuilt 1953 · S/N 22-1144N1346CWorden Gail · Burt, MIS/N 22-1145N136JMGregory Warren D Jr · Aguila, AZBuilt 1963 · S/N 22-5557N1391CSale Reported · Beech Creek, PASale reportedBuilt 1953 · S/N 22-1143N1393CHayden Daniel · North Pole, AKS/N 20-980N1397CDerr Rodney W · Frackville, PAS/N 22-1154N1399CShankster Thomas G · Aurora, COBuilt 1953 · S/N 22-1150N13DBBauer Dereck R · Springfield, ORFirst renewal noticeS/N 12-2919N13YFTemple Peter L · Harrisville, NHS/N 12-848N1404ALindinger John I · Auburn, NEBuilt 1951 · S/N 22-318N1405CGbq LLC · New Prague, MNBuilt 1953 · S/N 22-1162N1407CLafreniere Joseph A · Harmony, MNBuilt 1953 · S/N 22-1157N1411APetz Matthew M · Sandpoint, IDBuilt 1951 · S/N 22-323N1411CBraden James L · Hillsboro, KSS/N 22-1165N1412CStanley Gregory S · Glasgow, MTBuilt 1953 · S/N 22-1173N1415AHock Wesley S · Holbrook, NEBuilt 1951 · S/N 22-326N1418CWaaam Volunteer Flying Association LLC · Hood River, ORS/N 22-1175N1421AKoplitz Wesley D · Oshkosh, WIS/N 22-336N1424AStacey Steve L · Hutchinson, KSBuilt 1951 · S/N 22-338N1427CGdm Properties LLC · Huron, OHBuilt 1953 · S/N 22-1179N1428CHolder Ward S · Oxnard, CARegistration revokedBuilt 1953 · S/N 22-1180N1429CLarge Jonathan B · Mahnomen, MNBuilt 1953 · S/N 22-1183N1431AKoiter Jason A · Prescott Valley, AZBuilt 1951 · S/N 22-347N1434CSherman Jeff Co Ow · Elkhart, INRegistration revokedBuilt 1953 · S/N 22-1189N1437CChilders Daniel A · Hartwell, GAS/N 22-1192N14398Dyke Milo D · Hazen, NDBuilt 1949 · S/N 14-516N143JJKinery Clifford J · Kewadin, MIBuilt 1947 · S/N 12-1705N1440CChamberlain Howard D · Lisbon, OHFirst renewal noticeBuilt 1953 · S/N 22-1194N144JWWarren Joy A · White Lake, MIS/N 22-7286N1456AMcbride Michael S · Allentown, PABuilt 1951 · S/N 22-359N1457ASanderson Michael E · Newberg, ORS/N 22-357
Back to AD 60-01-07