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.

N20056Haney Randall M · Boaz, ALBuilt 1977 · S/N 17702624N20057Opiela Robert M · Hampton, NHBuilt 1972 · S/N 17260969N20058Ballou Skies Aviation Inc · Bucyrus, OHBuilt 1972 · S/N 17260970N20059Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2026 · S/N 20800727N2005GGreat Basin Aviation LLC · Eagle River, AKBuilt 1958 · S/N 51305N2005QCoon Roger E · Springtown, TXFirst renewal noticeBuilt 1973 · S/N 177RG0405N2005XTurnmire Jeffry B · Knoxville, TNBuilt 1965 · S/N 18256105N20060Bakken George S · Terre Haute, INBuilt 1972 · S/N 17260972N200617b Flying Club Inc · Sandpoint, IDBuilt 1972 · S/N 17260973N20063Beery Milo A DBA · Clarinda, IABuilt 1972 · S/N 17260975N20065Southern Aero LLC · Homestead, FLBuilt 1972 · S/N 17260977N20068Spartanburg Area Flight Education LLC · Spartanburg, SCBuilt 1972 · S/N 17260980N20069Montel Richard D · Candler, NCBuilt 1972 · S/N 17260981N2006GYates Rodney R · Hubbard, ORS/N 51306N2006QFarr Brad L · Uvalde, TXBuilt 1973 · S/N 177RG0406N2006RBarclay Mechanical Services Of Utah Inc · Manti, UTBuilt 1963 · S/N 18255206N2006ZN2006z LLC · South Hill, VABuilt 1963 · S/N 15059806N20070Skywarrior Flight Training LLC · Pensacola, FLS/N 17260982N20071Limaoscar LLC · Boca Raton, FLBuilt 1972 · S/N 17260983N20072Ace Aviation 20072 LLC · Pembroke Pines, FLBuilt 1972 · S/N 17260984N20073Gulf Coast Aviators LLC · Venice, FLBuilt 1972 · S/N 17260985N20074Kyzer Aviation Holdings LLC · Fort Mill, SCBuilt 1972 · S/N 17260986N20079Celestial Kinetics Flight Academy LLC · Waupaca, WIBuilt 1972 · S/N 17260990N2007QHopkins William · Reno, NVS/N 177RG0407N2007RDoc'S Flying Club LLC · Macon, GABuilt 1963 · S/N 18255207N2007TWinger Raymond E · Johnson, KSS/N 18258171N2007UBank Of Utah Trustee · Salt Lake City, UTBuilt 2026 · S/N 20800725N2007YFoster Lemuel E · Vancouver, WABuilt 1962 · S/N 17249507N2007ZRau John M · Liberty, KSBuilt 1962 · S/N 15059807N20085Fleming Ian · Peoria, AZBuilt 1977 · S/N 17702626N20089Eagle Air Inc · Schoolcraft, MIBuilt 1972 · S/N 17260999N2008GChaump Michael · Reno, NVBuilt 1958 · S/N 51308N2008QCoulter Dennis · Lincoln, CABuilt 1943 · S/N 177RG0408N20091Henderson Norman L · Bowling Green, MOBuilt 1972 · S/N 17261001N20093Patterson Kyle · Tega Cay, SCBuilt 1972 · S/N 17261003N20094Valiair Lc Trustee · Casper, WYS/N 17702627N20095Wingsleasing LLC · Wichita, KSBuilt 1972 · S/N 17261005N20097Morrison Robert J · Newport, MIBuilt 1972 · S/N 17261006N20099Wehnam Kenneth J · Shingle Springs, CAS/N R18201922N2009QTranby Wayne A · Fargo, NDBuilt 1973 · S/N 177RG0409N200AARad Runner LLC · Newton, NCBuilt 2019 · S/N 208B5501N200BJWright Thomas L · Clyde, OHBuilt 1975 · S/N 33701684N200BNRubber Duck Aviation LLC · Brunswick, GABuilt 1980 · S/N 421C0881N200DCBjg Aviation I LLC · Neelyville, MOBuilt 1981 · S/N 421C1223N200EKBw Air LLC · Pierre, SDBuilt 1984 · S/N 425-0205N200GCDancy Abram P · Shrewsbury, MABuilt 1978 · S/N 340A0503N200HPOklahoma Department Of Public Safety · Norman, OKS/N U20605693N200KSKapowsin Air Sports Ltd · Shelton, WABuilt 1986 · S/N 208B0001N200LDFenske Jeffrey D · Gold Hill, ORBuilt 1973 · S/N 21059895N200LFAeromarine Holdings LLC · Waukesha, WIBuilt 1989 · S/N 20800149
Back to AD 97-01-13