AD 57-22-01

Registered aircraft · 2,955

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

N1289CGordon Robert Earl · Sanford, NCS/N 22-1110N12TASky 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-1136N1339CWalt'S Kustom Kreations Inc · Palatka, FLBuilt 1953 · S/N 22-1135N133FKing Tyler B · Saint Stephen, SCBuilt 1956 · S/N 22-4023N1342CLink 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-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-1150N1404ALindinger 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-1192N1440CChamberlain Howard D · Lisbon, OHFirst renewal noticeBuilt 1953 · S/N 22-1194N1441CTroyer Cody L · Macon, MSS/N 20985N144JWWarren Joy A · White Lake, MIS/N 22-7286N1456AMcbride Michael S · Allentown, PABuilt 1951 · S/N 22-359N1457ASanderson Michael E · Newberg, ORS/N 22-357N1465ALarsen Caesar S · Pleasanton, CABuilt 1951 · S/N 22-372N1469AJohnson Steven C · Cheyenne, WYBuilt 1952 · S/N 22-377N1471AJames Norris J · Kannapolis, NCBuilt 1952 · S/N 22-378N1472ASmith Wesley P · Donnelly, IDBuilt 1952 · S/N 22-379N1474ARichard Waldren LLC · Newberg, ORS/N 22-385N1478ABehr Casper J · Neavitt, MDBuilt 1952 · S/N 22-392N1479AOlson Phillip Francis · Tenino, WABuilt 1952 · S/N 22-391
Back to AD 57-22-01