AD 97-15-01

Registered aircraft · 19,952

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

N1069LWilson Michael A · Everett, WABuilt 1956 · S/N 33633N106BAnderson Martino G · Lakeland, FLBuilt 1955 · S/N D-4394N106NChenevert Eric M · Clarence, NYBuilt 1962 · S/N D7035N106PSScarrow James D · Jerome, IDBuilt 1976 · S/N 18264800N106RGCadena Edward R Jr · Houston, TXBuilt 1966 · S/N 18257535N106UMiha LLC · Dover, DEBuilt 1956 · S/N 32325N106VKenyon Joseph S · Fort Collins, COBuilt 1959 · S/N D-6009N10712Hall Air Inc · Weiner, ARBuilt 1961 · S/N TC-59N10714Tennessee Museum Of Aviation · Sevierville, TNBuilt 1951 · S/N 22748N10715Noyes Stephen S · Newburyport, MABuilt 1951 · S/N 22816N1073MScr Aviation LLC · Austin, TXBuilt 1975 · S/N 18264219N1073QRegistration Pending · Polo, MORegistration pendingBuilt 1963 · S/N 310H0073N1077B85 Alpha Inc · Wilmington, DEBuilt 1957 · S/N D-4931N1079QGriffin Marcus · Houston, TXBuilt 1963 · S/N 310H0079N107SWanagel Walter · Lisbon, CTBuilt 1949 · S/N NAV-4-1946N107SPDepartment Of Emergency Svc & Public Protection · Hartford, CTBuilt 1984 · S/N 18268427N107VWHenning Nancy E · Hardinsburg, KYBuilt 1960 · S/N CD-71N107WFWilcox Farms Inc · Roy, WABuilt 1961 · S/N 18253149N107YYBeezhold Terence J · Lake Stevens, WABuilt 1956 · S/N 35266N1080MFlying Particles Inc · Livermore, CABuilt 1977 · S/N 18266034N1082PGarrett James D Jr Trustee · Coolidge, AZBuilt 1968 · S/N 18258855N1083QAhlhorn Travis W · San Marcos, TXBuilt 1963 · S/N 310H0083N1084WLafayette Foundation Inc · Fort Lupton, COBuilt 2019 · S/N C1084N1085MDuncan Terry C Trustee · Cupertino, CABuilt 1975 · S/N 18264221N1086LLade Burton G · Bemidji, MNBuilt 1959 · S/N 50564N1086MSargent John E · Vancouver, WABuilt 1975 · S/N 18264222N1089MPetersen Clayton · Albert Lea, MNBuilt 1975 · S/N 18264223N108BCaturia Jeffrey T · Layton, UTBuilt 1955 · S/N D-4397N108BTFlying J Aviation LLC · Lynden, WABuilt 1948 · S/N 108-4045N108EENorthwood Services Inc · Skwentna, AKBuilt 1956 · S/N 32505N108GBLooney Jordan · Trumann, ARBuilt 1960 · S/N D-6422N108GWPope James D · Clarkston, WAS/N 32683N108JHInternational Air Services Inc Trustee · Carson City, NVS/N TC-1530N108KDPayne Steven H · Nine Mile Falls, WABuilt 1949 · S/N 1084963N108MLosey Thomas L · Ft Myers, FLBuilt 1963 · S/N 281N108RMFernandez Taylor R · Wasilla, AKBuilt 1948 · S/N 108-5257N108SPDale County Sheriffs Office · Ozark, ALS/N 18260052N108TTTurnbull Archie · Ypsilanti, MIBuilt 1946 · S/N 108-534N1090MBergstrom Aircraft Inc · Pasco, WAS/N 18264224N1092WAmerican Aviation LLC · Waterville, MEBuilt 1973 · S/N TC-1549N10948Morris Jacky D · Watonga, OKBuilt 1977 · S/N 18266102N109AKHarris Eric W Jr · Moncks Corner, SCBuilt 1956 · S/N D-4464N109DSBell Bradley L · Bothell, WABuilt 1948 · S/N NAV-4-1373N109FRoos Patrick R · Purcellville, VABuilt 1947 · S/N NAV-4-839N109HBadke Paul J · Ray, MIBuilt 1962 · S/N 21057921N109VKeeling Rodney E · Pearce, AZBuilt 1960 · S/N CD-160N109WYPerala Daniel R · Cheyenne, WYBuilt 1969 · S/N 18260131N109YBraun Joshua S · Port Hope, MIBuilt 1962 · S/N 18253513N10ETTech Nav LLC · Columbus, INBuilt 1971 · S/N 310Q0415N10EVCafiero Vincent · Haskell, OKBuilt 1955 · S/N D-4186
Back to AD 97-15-01