OpenAirDocs.org
AD 80-25-02 R2

Registered aircraft · 6,348

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

N1349ZSch Aviation Inc Trustee · NorfolkBuilt 1981 · S/N 1879N1350RBates Victoria Anna · West Union, WVS/N AA1B0650N1353RRegistered aircraftBuilt 1979 · S/N WA-6N135TMMowbray Jerry H · Reno, NVBuilt 2001 · S/N 1384-2001N135WAHardin Melissa K · Terrell, TXBuilt 1979 · S/N 15283655N1360RBreland James G · Laurel, MSBuilt 1976 · S/N AA1B0660N136EJForeman Guy W · Valparaiso, INBuilt 1979 · S/N 38-79A0572N136MSTerhune Jack E · Alzada, MTBuilt 2015 · S/N 138N1372RStephenson John W · Whittier, CABuilt 1976 · S/N AA1B0672N1373RSmith Paul R Jr · Hubbardston, MABuilt 1976 · S/N AA1B0673N1375NJefferson Jacob K · Salinas, CABuilt 1956 · S/N ER-100N1378XTurner Charles B · Mansfield, MABuilt 1982 · S/N 315N137BTBoyce Daniel L · Beach Park, ILS/N S9503-0109N137JBMason Harold T · Hesperia, CABuilt 1978 · S/N AA1C0207N137TMonno Joseph P · Hastings, MNBuilt 1953 · S/N 18-2251N137YHenry Vernon C · Stevensville, MTBuilt 1978 · S/N AA1C0137N1380RNevers Joseph R II · Homestead, FLBuilt 1976 · S/N AA1B0670N1391WKotinek Douglas A · Rapid City, SDBuilt 1983 · S/N 124N13EAHood Norman R · Austin, TXBuilt 1977 · S/N 15279914N13RESchneider David J · Statesville, NCBuilt 1987 · S/N 1N13RHChrist Graham Charles · Mandeville, LABuilt 1973 · S/N 973-73N13RSHoward Kenneth L · Collinsville, OKS/N RES-2N1401TJetmro Inc · Sebastian, FLS/N AA1B-0501N1406RPatrick Ernest E · Lufkin, TXBuilt 1974 · S/N AA1B-0506N1409RJersey Boys LLC · Rockledge, FLBuilt 1974 · S/N AA1B-0509N1411RBlanton Eric W · Santa Anna, TXBuilt 1974 · S/N AA1B-0511N1414RBerka George · Waterbury, CTS/N AA1B-0514N141TRipley Jesse W · Wasilla, AKBuilt 1953 · S/N 18-2255N1420RShires James D · Merrillan, WIS/N AA1B-0520N1421RGreenawald Richard J · San Mateo, CABuilt 1975 · S/N AA1B-0521N1425NJolley William H · Wamsutter, WYS/N 22950N1425RCambridge Aircraft LLC · Hot Springs, ARS/N AA1B-0525N1428RShiner Tod W · Talking Rock, GABuilt 1975 · S/N AA1B-0528N1429Rapalyea Eugene L · Santa Rosa, CABuilt 1969 · S/N 1N1429DChan Michael · Green Cove Springs, FLS/N 1429N1431RTwo Dot Aircraft LLC · Kalispell, MTS/N AA1B-0531N1433RNickell Stan A · Gilmer, TXS/N AA1B-0533N1434RLarson Kris K · Fullerton, CAS/N AA1B-0534N1438RLindsey Dustin T · Salem, ORS/N AA1B-0538N14398Dyke Milo D · Hazen, NDBuilt 1949 · S/N 14-516N143JJKinery Clifford J · Kewadin, MIBuilt 1947 · S/N 12-1705N143RRHale Arthur H · Angleton, TXBuilt 1972 · S/N AA1A-0397N1441RJorgensen John K · Dewey, AZS/N AA1B-0541N1443RBrown Jesse L · Muscle Shoals, ALBuilt 1975 · S/N AA1B-0543N1444RRye Steve V · Dickson, TNBuilt 1975 · S/N AA1B-0544N1446KColeman James P · Sand Springs, OKBuilt 2015 · S/N 8214N14470Girty Kenneth G · Enid, OKS/N 558N1448RWright Roger W · Buckeye, AZBuilt 1975 · S/N AA1B-0548N144MCoad Aeronautics LLC · Saint Jacob, ILBuilt 1978 · S/N 38-78A0596N144TCSemeneshen Edmund · Lisbon, CTBuilt 1978 · S/N 38-79A0119
Back to AD 80-25-02 R2