AD 97-01-13

Registered aircraft · 54,837

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-13')
    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-13')
  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.

N2139FCrow Brian M · Oakesdale, WABuilt 1965 · S/N U206-0339N2139GSoarmates LLC · Missoula, MTBuilt 1958 · S/N 51439N2139RShaw Gregory A · West Richland, WABuilt 1964 · S/N 18255339N2139XAerometrix LLC · Lino Lakes, MNBuilt 1965 · S/N 337-0039N213ANCalifornia In Nice Inc DBA · San Jose, CAS/N 17272380N213BGUpstate Flyers LLC · Woodruff, SCBuilt 1972 · S/N 18261580N213JDS&C Vending LLC · Scottsbluff, NES/N 310R0136N213LAJet Rider LLC · Middletown, DEBuilt 2004 · S/N 208B1096N213MBNational Tax Relief Inc · Riverside, CAS/N 17702282N21401Sterling Steven G · Richland, WABuilt 1972 · S/N 18261612N21402Hester James Timothy · Fayetteville, GABuilt 1972 · S/N 18261613N21403Bering Capital LLC · Anchorage, AKBuilt 1974 · S/N 17263944N21404Usglap · Fort Morgan, COBuilt 1972 · S/N 18261615N21405Brushwood John W · Coshocton, OHBuilt 1972 · S/N 18261616N2140GBoger Malcolm L · Dickens, TXBuilt 1958 · S/N 51440N2140JHardin County Aviation LLC · Kountze, TXBuilt 1975 · S/N 17265018N2140QAtlantic Beach Flyers LLC · Atlantic Beach, FLBuilt 1974 · S/N 177RG0540N21414Flyboys Flying Club LLC · Pawleys Island, SCBuilt 1972 · S/N 18261624N21416Campbell David Lloyd · Fredericksburg, TXBuilt 1972 · S/N 18261626N2141FHill Henry M · Sleetmute, AKBuilt 1965 · S/N U206-0341N2141GFreiheit Larry · Clinton, MOBuilt 1958 · S/N 51441N2141QNeuman Allen D · Sanger, TXS/N 177RG0541N21421Paul Janet K · Beaver Island, MIBuilt 1972 · S/N 18261630N2142QLichtenberg Jeffrey L · Brookfield, MOBuilt 1974 · S/N 177RG0542N21430Burns Preston · Spruce Pine, ALBuilt 1990 · S/N 310Q1073N21445Woody Dwain F Trustee · Lubbock, TXBuilt 1972 · S/N 18261632N21446Ham Todd O · Opdyke, ILBuilt 1974 · S/N 17263946N2144RButterfield Stephen · Nampa, IDS/N 18255344N2144ZBeerle Brion J · Anchorage, AKBuilt 1963 · S/N 18051244N21450Brant Gary E · Salisbury, PABuilt 1972 · S/N 18261637N21453Super D Electric Inc · Coeur D Alene, IDBuilt 1972 · S/N 18261640N21455Drewett Edward A · Many, LABuilt 1974 · S/N 17263950N21457Registration Pending · Deland, FLRegistration pendingBuilt 1973 · S/N 18261642N2145GGraham William F III · North Wilkesboro, NCBuilt 1958 · S/N 51445N2145QErnstes William L · Greensburg, INBuilt 1974 · S/N 177RG0545N2145YRegistration Pending · Spokane, WARegistration pendingS/N 17249645N21461Acme Aviation Inc · Lake Charles, LABuilt 1972 · S/N 18261645N21462Fly Man LLC · Waxhaw, NCBuilt 1972 · S/N 18261646N21465Clary Kenneth W Sr · Huntsville, TXS/N 18261648N2146QMcdonald Anthony Robert · Brookside, UTBuilt 1974 · S/N 177RG0546N21472Registered aircraftBuilt 1972 · S/N 18261652N21474Alexander David L · North Pole, AKBuilt 1972 · S/N 18261654N21475Austin Police Dept · Pflugerville, TXBuilt 1972 · S/N 18261655N21477Frizzell Richard W Jr · Blacksburg, VABuilt 1972 · S/N 18261657N2147YEast Carolina Aviation LLC · Camden, NCBuilt 1962 · S/N 17249647N21485Dipzinski Victor L · Clio, MIFirst renewal noticeBuilt 1974 · S/N 17263956N21487Millennial Flight LLC · Kalispell, MTS/N 18261663N21488Mission Hardware LLC · Savannah, GABuilt 1973 · S/N 18261664N2148GMissildine Ronald E Trustee · Simi Valley, CABuilt 1958 · S/N 51448N2148QMorten Jesse L · Larimore, NDBuilt 1974 · S/N 177RG0548
Back to AD 97-01-13