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.

N18145Stlouis Aviation LLC · Miramar, FLBuilt 1972 · S/N 15073818N1814FAlpine Cable And Construction Inc · Grand Junction, COBuilt 1965 · S/N 21058714N1814VBeyer Leasing Co · Paw Paw, MIS/N 17263759N18155Willis Nathan Eric · Broken Arrow, OKBuilt 1972 · S/N 15073828N18157Matz Robert D · Niles, MIBuilt 1972 · S/N 15073830N18159Beck Thomas G · Walled Lake, MIBuilt 1976 · S/N 17702534N1815MReim Rodney D · Enid, OKBuilt 1971 · S/N 33701415N1815ROsprey Island Lodge Inc · Eagle River, AKBuilt 1974 · S/N 18502530N18162Pruzek Richard L · Chippewa Falls, WIBuilt 1972 · S/N 15073834N18163Wings Aero LLC · Zeeland, MIBuilt 1972 · S/N 15073835N18164Cendejas Agustin · Chino, CABuilt 1972 · S/N 15073836N18167Be Chara Niz Ar E · Columbia, MDBuilt 1972 · S/N 15073838N1816FMalcom Scott O · Toledo, WABuilt 1965 · S/N 21058716N1816JWakefield Aircraft LLC · Cooperstown, NDS/N 182-68574N1816QS And E Airplane Company · Puyallup, WABuilt 1971 · S/N 177RG0216N1816RArizona Game & Fish Dept · Phoenix, AZBuilt 1974 · S/N 18502531N1816YNicholas Thomas M II · Enid, OKBuilt 1962 · S/N 17249416N18171Isaacson Arthur T · Hillsboro, MOS/N 15073840N18173Bb Aero Works Ltd · Whitehouse, OHBuilt 1972 · S/N 15073842N18174Connell William J · Woodinville, WABuilt 1976 · S/N 17702535N18177Hoffman Rick W · Elk River, MNBuilt 1972 · S/N 15073846N1817QJohnston Bernard D · Puyallup, WAFirst renewal noticeBuilt 1971 · S/N 177RG0217N1817RLfg Properties LLC · Portage, MIS/N R18200571N1817XSale Reported · Roseville, MNSale reported, pending cancellationBuilt 1965 · S/N 18255917N1818Fulton Ricky L · Alex, OKS/N 18051551N18180Woodward Aviation · Varnville, SCS/N 15073847N18182Samaha Fadi · Point Roberts, WABuilt 1975 · S/N 18263913N18189Jaam-A LLC · Matthews, NCBuilt 1972 · S/N 15073852N1818AMaas Nancy C · Redding, CABuilt 1978 · S/N 18266532N1818RSideline Services LLC · Pearland, TXBuilt 1978 · S/N R18200572N18197C150 Holdings LLC · Newark, DEBuilt 1972 · S/N 15073854N18198Ohare Douglas K · Ainsworth, NEBuilt 1972 · S/N 15073855N18199Forthman Scott Chance · Miami, FLBuilt 1972 · S/N 15073856N1819QSchmidt Mark · San Jose, CABuilt 1971 · S/N 177RG0219N1819XGrant Steven T · Sellers, SCBuilt 1964 · S/N 18255919N181ATNazario Rafael · Delray Beach, FLBuilt 1973 · S/N 18262686N181CPEighty1 Aviation LLC · Canton, GABuilt 1964 · S/N 18255766N181DHWinkler Jeffery L · Brush, COBuilt 1964 · S/N 206-0220N181EWoodhead Matthew E Trustee · Reno, NVBuilt 1979 · S/N 18267304N181JBBarrows Grayson J · Mcminnville, ORBuilt 1963 · S/N 18051329N181JMMccloy John S · Lakeland, FLBuilt 1953 · S/N 30145N181NWitt Robert A · Anchorage, AKBuilt 1956 · S/N 32416N181PKPacific Mission Aviation · Hagatna, GUFirst renewal noticeS/N U20606158N181RBBeltz Richard R · Lehighton, PABuilt 1956 · S/N 32712N181RCWheeler Douglas N Trustee · Santa Fe, NMBuilt 1978 · S/N 18052982N181RDWoodcock Air LLC · Wilmington, DES/N 33701881N181RPCain Jeffrey B · Godley, TXBuilt 1981 · S/N 18053180N181STWagontrainer LLC · Kalispell, MTBuilt 1954 · S/N 30997N181TTWilson James · Bagwell, TXBuilt 1964 · S/N 17252385N181TXAddie-Air Inc · Bridgeport, TXBuilt 1981 · S/N U20606408
Back to AD 97-01-13