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.

N2476RBascom Richard J Trustee · Elkhart, IABuilt 1964 · S/N 18255576N2476UFive States Holdings LLC · Helena, MTBuilt 1963 · S/N 17250076N24773Grusy Norman D · Portland, ORS/N 15280369N24775Cal Aggie Flying Farmers Inc · Davis, CABuilt 1977 · S/N 15280371N2477GRamsey Stephen C · Aspen, COBuilt 1958 · S/N 51777N2477RJohnson Michael W · Kensington, OHBuilt 1964 · S/N 18255577N24781Shaw Erin · Reno, NVBuilt 1977 · S/N 15280375N2478FSchad Paul E · Gainesville, TXBuilt 1966 · S/N 18051680N2478GGilliland Sandra K · Julian, NCBuilt 1959 · S/N 51778N2478QAbraham Curtis L · Byron, WYBuilt 1966 · S/N 18257678N2478RWeber Alan M · Manteca, CABuilt 1964 · S/N 18255578N2478UBraun Kevin J · Aberdeen, SDS/N 17250078N2478XCrooked Lake Aero LLC · Hammondsport, NYBuilt 1965 · S/N 18256378N2478YHockenson Roy D · Auburn, WABuilt 1962 · S/N 17249778N2479CTo The Wind LLC · Salmon, IDBuilt 1954 · S/N 30779N2479LMoore Joseph A · Kingwood, WVBuilt 1966 · S/N 17255679N2479QPriest David E · Caldwell, IDBuilt 1966 · S/N 18257679N2479U2479u Aviation LLC · Fernandina Beach, FLBuilt 1963 · S/N 17250079N2479XKruse Interests LLC · League City, TXS/N 18256379N2479YDmac Aircraft LLC · Savannah, GABuilt 1962 · S/N 17249779N247APNorth Joseph · Cocoa, FLBuilt 1970 · S/N 17259066N247CBDream Machine Leasing LLC · Glenbrook, NVBuilt 1981 · S/N U20606194N247DLCentral Florida Flight LLC · Ocoee, FLBuilt 1966 · S/N 17254201N247EFNobles Vernon H Jr · Calabasas, CABuilt 1968 · S/N 310P0023N247GSHyannis Air Service Inc DBA · Hyannis, MABuilt 1982 · S/N 402C0637N247HPCalifornia Highway Patrol · Sacramento, CABuilt 2025 · S/N 20800720N247JPSpirit Air Inc · Salmon, IDBuilt 2013 · S/N 208B5047N247KMNorthern Lights Ventures LLC · Moose Pass, AKBuilt 1975 · S/N U20602872N247LWHailey & Harmony Enterprises LLC · Las Vegas, NVS/N 172RG0314N2480GGassaway Mitchell E · Carrollton, TXBuilt 1959 · S/N 51780N2480LStephens Ryan J · Dallas, PABuilt 1966 · S/N 17255680N2480URaczynski Adam · Far Rockaway, NYBuilt 1963 · S/N 17250080N24816Graves James A Trustee · Norman, OKBuilt 1977 · S/N 15280396N2481CPippert Jim · Dysart, IABuilt 1954 · S/N 30781N2481GEaster Brett D · Enumclaw, WABuilt 1959 · S/N 51781N2481LGhaemmaghami Ommid · Mckinney, TXBuilt 1966 · S/N 17255681N2481REngh Robert G · Laurel, MTBuilt 1964 · S/N 18255581N2481UWilliams Jeremy · Searsport, MES/N U20602380N2481YFellers Farms LLC · Burlington, OKBuilt 1962 · S/N 17249781N2482CMiller Richard W · Bellingham, WABuilt 1954 · S/N 30782N2482LTrubowicz Maciej Piotr · Cornelius, NCBuilt 1966 · S/N 17255682N2482QFox John E · Boonville, CABuilt 1966 · S/N 18257682N24831Bishop Darin R · Livermore, CABuilt 1977 · S/N 15280403N2483FMiller Clinton J · Traverse City, MIBuilt 1966 · S/N 18051685N2483GLenox Mark W · Idaho Falls, IDS/N 51783N2483JWestern Pilot Service Inc · Phoenix, AZBuilt 1979 · S/N 18803467TN2483QMarch Kenrick D · Kingwood, TXBuilt 1966 · S/N 18257683N2483RSkydive Twin Cities LLC · Baldwin, WIS/N 18255583N2484CLejeune Aerial Applications LLC · Basile, LABuilt 1954 · S/N 30784N2484FJones William Ransom · Anchorage, AKBuilt 1966 · S/N 18051686
Back to AD 97-01-13