AD 72-01-07

Registered aircraft · 1,150

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:72-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:72-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.

N1325AAlaskas Cub Training Specialists LLC · Wasilla, AKBuilt 1951 · S/N 18-1139N1329AWatsabaugh Byron D Jr · Gillette, WYBuilt 1951 · S/N 18-1140N132LClapp William H · Mountain View, MOS/N 18-2321N1330AKost 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-1147N1336APluhar Charles J · Cohagen, MTBuilt 1951 · S/N 18-1151N133TTroftgruben Gregory G · Buxton, NDBuilt 1953 · S/N 18-2247N1340A4031 Aviation Inc · Bemidji, MNS/N 18-1154N1342AHagenston Arthur J · Fairbanks, AKS/N 18-1167N1347AKalba 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-1184N135KSBunde 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-1190N1365ARegistration 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-1197N1372ABice 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-2251N1380AGlenn Douglas W · Palmer, AKBuilt 1951 · S/N 18-1211N1385CBlake Hughie R · Cordova, AKBuilt 1953 · S/N 18-2638N1386AState Of Alaska · Anchorage, AKBuilt 1951 · S/N 18-1219N1387GList Martinus R · Wasilla, AKS/N 18-3521N1389AMorris David G · Wasilla, AKBuilt 1951 · S/N 18-1220N1392AHerrig Daniel C · King Salmon, AKBuilt 1951 · S/N 18-1228N1394RRoss Bill · Meridian, MSBuilt 1952 · S/N 18-1983N1394YOjendyk Mark R · Newcastle, WABuilt 1953 · S/N 18-3357N1398AN1398a LLC · Anchorage, AKS/N 18 1234N13FFVeal Tim S · Kenai, AKBuilt 1954 · S/N 18-3415N13RYSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1952 · S/N 18-1727N141TRipley Jesse W · Wasilla, AKBuilt 1953 · S/N 18-2255N142TReed Britt A · White Salmon, WABuilt 1953 · S/N 18-2256N14319Erickson Mark D · Valley Springs, SDS/N 18-6359N143TMurray Paul M Trustee · Storm Lake, IABuilt 1953 · S/N 18-2257
Back to AD 72-01-07