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.

N263DWWarren David T · Mobile, ALBuilt 1959 · S/N 51970N263HPCalifornia Highway Patrol · Mcclellan, CABuilt 2025 · S/N 20800719N263LPMarkman William J · The Dalles, ORS/N 18265959N2640FLaguna Verde Leasing Inc · Wilmington, DEFirst renewal noticeBuilt 1979 · S/N 310R1676N2640USealey Gary W · Saint Pauls, NCBuilt 1963 · S/N 17250240N2640VBube Douglas G · Clarkston, WABuilt 1974 · S/N 177RG0640N2640YMarc Aircraft Holding LLC · Soldotna, AKBuilt 1962 · S/N 18051140N2641LTm Aviation Services LLC · Riverside, CABuilt 1967 · S/N 17255841N2641RHowatt Scott · Hannah, NDBuilt 1967 · S/N 18258341N2641ZTfs Air LLC · Loveland, COBuilt 1979 · S/N 310R1804N2642GWillis Andrew B · Wasilla, AKBuilt 1959 · S/N 51942N2642LRiggin Flight Service Inc · Madison, SDS/N 17255842N2642QLongerbone Danny L · Fishers, INBuilt 1970 · S/N 17258931N2643FWortham Bethany S · Soldotna, AKBuilt 1965 · S/N 18256743N2643GBorland Gregg A · Elkhart Lake, WIBuilt 1959 · S/N 51943N2643KWashington Walt W · Collierville, TNBuilt 1978 · S/N 18053023N2643QOst Jesse E · Hunter, KSBuilt 1966 · S/N 18257843N2643RNorthern Wings LLC · Spokane, WABuilt 1967 · S/N 18258343N2643UGaring Gerald R · Schenectady, NYBuilt 1963 · S/N 17250243N2643VGorman Sean P · Superior, COBuilt 1974 · S/N 177RG0641N2643YCompany Plane LLC · Wisconsin Rapids, WIS/N 310R1687N2643ZPolizzi Christopher I · Peachtree City, GABuilt 1979 · S/N 310R1688N2644RColler Randy L · Jackson, MIBuilt 1967 · S/N 18258344N2645FMichel John Vernon III · Westminster, MDBuilt 1965 · S/N 18256745N2645GMurdoch Kyle · Burns, WYBuilt 1959 · S/N 51945N2645KFowlkes John M Trustee · Marfa, TXBuilt 1978 · S/N 18053024N2645LMchugh Eric P · Cleveland, TXS/N 17255845N2645SVenice Group LLC · Hopkinton, NHS/N 337-0945N2646FAmerican Driveaway LLC · Cowden, ILS/N 18256746N2646UEarly Patricia A · Palmyra, PABuilt 1963 · S/N 17250246N2647FGayneaux Kelly J · Midland, TXS/N 18256747N2647GAllen Steven L · Thatcher, AZBuilt 1959 · S/N 51947N2647JHumble Tony R · Signal Mountain, TNBuilt 1966 · S/N 15065647N2647KBoice Petroleum Consulting LLC · Pinedale, WYS/N 18053025N2647LCommonwealth Aviation Services LLC · Herndon, VABuilt 1967 · S/N 17255847N2647RSaber Wings LLC · Sacramento, CABuilt 1967 · S/N 18258347N2648FLincoln Sport Parachute Club Inc · Lincoln, NEBuilt 1965 · S/N 18256748N2648JColonial Air Inc · New Bedford, MABuilt 1966 · S/N 15065648N2648LZangs William J · Poplar Grove, ILBuilt 1967 · S/N 17255848N2648QBuck Irrigation Inc · Elkhart, KSBuilt 1966 · S/N 18257848N2648SRegistration Pending · Albuquerque, NMRegistration pendingBuilt 1968 · S/N 337-0948N2648URock Kenneth L · Petersburg, AKBuilt 1963 · S/N 17250248N2648VWhite Jeffrey W · Macon, GABuilt 1974 · S/N 177RG0642N2648YSw Aviation Services Inc · Queen Creek, AZBuilt 1955 · S/N 31676N2649FSkylane 2649f LLC · Kalispell, MTBuilt 1965 · S/N 18256749N2649GSwanson Gregory N · Meridian, IDS/N 51949N2649RShah Aitazaz · Shady Shores, TXBuilt 1967 · S/N 18258349N2649UMorrison Kent · Mccleary, WAFirst renewal noticeBuilt 1963 · S/N 17250249N2649ZHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0333N264CAChoice Aviation LLC · Hamilton, MTBuilt 1975 · S/N 17266035
Back to AD 97-01-13