OpenAirDocs.org
AD 97-01-01 R1

Registered aircraft · 6,916

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:97-01-01-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:97-01-01-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.

N6808JHot Seat Aviation · Blacksburg, VAS/N 28R-7635335N6809PMerino Cesar · Washington, DCS/N 24-1942N6810POlmedo Refugio J · Lancaster, CABuilt 1960 · S/N 24-1943N6812JGottschalk William R · Fort Atkinson, WIBuilt 1976 · S/N 32R-7680352N6814PFuller Michael David · Palmdale, CAFirst renewal noticeBuilt 1960 · S/N 24-1947N6816PElliott Patrick K Sr · North Bend, ORBuilt 1960 · S/N 24-1949N6821PComanche Logistics LLC · Lake City, FLBuilt 1960 · S/N 24-1954N6823PKoopmans Caleb · Bridgewater, SDBuilt 1960 · S/N 24-1956N6824PAtlas Equipment LLC · Casper, WYBuilt 1960 · S/N 24-1957N6828JKdrd Holdings LLC · Texas City, TXBuilt 1976 · S/N 28R-7635337N682FGlobal Flight Training Solutions Inc · Immokalee, FLBuilt 1969 · S/N 30-1955N6830PGregory M Gabriela · Las Vegas, NVBuilt 1960 · S/N 24-1963N6831JHogan Thomas J · San Diego, CABuilt 1976 · S/N 34-7670282N6832JHolseberg Properties LLC · Ridgeville, SCBuilt 1976 · S/N 32R-7680338N6833PHolmes Darrell · Chino Hills, CABuilt 1960 · S/N 24-1966N6835PMarvin Shawn · Tomahawk, WIS/N 24-1968N6838PHartley Victor A III · Woodbine, NJS/N 24-1971N6839PFriesen Brad A · Plains, TXBuilt 1960 · S/N 24-1972N6840JBeineke Paul · Marion, OHBuilt 1976 · S/N 32R-7680361N6841JStarnes Robert D · Lavonia, GABuilt 1976 · S/N 34-7670283N6849JSecker David A · San Jose, CAFirst renewal noticeBuilt 1976 · S/N 28R-7635340N6849PSvenningsen Joshua J · Menomonie, WIBuilt 1960 · S/N 24-1983N6850JBush J Scott · Grindstone, PABuilt 1976 · S/N 34-7670293N6851JHem Properties LLC · Winston Salem, NCBuilt 1976 · S/N 32R-7680370N6852PHauf Michael L · Minot, NDBuilt 1960 · S/N 24-1986N6853PNolan Donald E · Oro Valley, AZBuilt 1960 · S/N 24-1987N6854FWilson Stanton H · Vista, CAS/N 32R-7780038N6856FSchuybroek Aviation Inc · Dover, DEBuilt 1976 · S/N 32R-7780040N6856PPerkey Gilbert J · Eagle Rock, VABuilt 1960 · S/N 24-1992N6857JSkyward3 LLC · Kalispell, MTS/N 28R7635341N6857PHuntsman John E · West Linn, ORBuilt 1960 · S/N 24-1993N6860PRegistered aircraftBuilt 1960 · S/N 24-1996N6862JTraut Joseph W · Sharon, MABuilt 1976 · S/N 28R-7635353N6862PWeber Phillip A · Stroudsburg, PABuilt 1960 · S/N 24-1998N6865JPlanepals LLC · Waverly, MOBuilt 1976 · S/N 32R-7680372N6866PDeckard Kyle R · Harrisburg, ORBuilt 1960 · S/N 24-2001N6867PAviation Services LLC · Jacksonville, ORS/N 24-2002N6871JRyan Air Ventures LLC · Auburn, GABuilt 1976 · S/N 28R-7635354N6871PHogue Kalum Shane · Monroe, TNBuilt 1960 · S/N 24-2006N6878CWisconsin Aviation Inc · Watertown, WIBuilt 1978 · S/N 34-7870166N6878JLake Stephen · Geary, OKBuilt 1976 · S/N 28R-7635355N6879JJackson Evan · Gaston, INBuilt 1976 · S/N 32R-7680376N6879PCory Ipc Corp · Indianapolis, INS/N 24-2015N687BHTrmg Consulting Services LLC · Edison, NJS/N 28R-7737042N687TJMirarchi Joseph F · New Braunfels, TXBuilt 1977 · S/N 28R7703235N6880JRobertson Ed J · Owasso, OKBuilt 1976 · S/N 32R-7680377N6882PKrumel Bradley · Omaha, NEBuilt 1960 · S/N 24-2018N6886PBas Part Sales LLC · Greeley, COBuilt 1960 · S/N 24-2022N6887JBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 32R-7680379N6888FAtlanta Peach Air LLC · Oxford, GAS/N 32R-7780049
Back to AD 97-01-01 R1