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.

N2484JTundra Aviation Inc · Casselton, NDBuilt 1966 · S/N 15065584N2484LLuv2fly LLC · San Antonio, TXS/N 17255684N2484UFiske James K · North Andover, MABuilt 1963 · S/N 17250084N24856Mccreary Aviation LLC · Green Valley, AZBuilt 1977 · S/N 15280414N24857Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1977 · S/N 15280415N2485GBack Country Guys LLC · Prescott, AZBuilt 1959 · S/N 51785N2485JPercival Sheila · Watson, ILS/N 15065585N2485QPayne Scott M · Twin Bridges, MTBuilt 1966 · S/N 18257685N2485SBrewer Lester A · Magna, UTS/N 337-0785N2485YMcdonald Gregory S · Mena, ARBuilt 1962 · S/N 17249785N2486CArmstrong Patrick Trustee · Bishop, CABuilt 1954 · S/N 30786N2486GDenton Bob · Nampa, IDBuilt 1959 · S/N 51786N2486RCain James W · Big Rapids, MIBuilt 1964 · S/N 18255586N2486SDarvek LLC · Las Vegas, NVBuilt 1967 · S/N 337-0786N2486XGreat Escape Aviation LLC · Marquette, MIBuilt 1965 · S/N 18256386N2486YCarfinder LLC · Huntington Station, NYBuilt 1962 · S/N 17249786N24874Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15280427N2487GRegistration Pending · Aledo, TXRegistration pendingBuilt 1959 · S/N 51787N2487RCummings Sean · Lombard, ILBuilt 1964 · S/N 18255587N2487SMoody Bible Institute Of Chicago · Spokane Valley, WAS/N R18201344N2487UBaske Scott E · Hanna, INBuilt 1963 · S/N 17250087N2487YBradley Jeff C · Schertz, TXS/N 17249787N24884Bravo Victor LLC · Afton, WYFirst renewal noticeBuilt 1977 · S/N 15280431N24886Warrior II Ltd · Des Plaines, ILBuilt 1977 · S/N 15280432N24887Sunrise Aviation Inc · Ormond Beach, FLS/N 15280433N2488GRumley Orville C · Minco, OKBuilt 1959 · S/N 51788N2488JMcdonald Nicholas W · Phoenix, AZBuilt 1966 · S/N 15065588N2488RCorprew Gerard A · Callao, VABuilt 1964 · S/N 18255588N2488USchafer Gerhard Walter · Fairbanks, AKS/N 17250088N2488XCentral Oil Co LLC · Mcminnville, TNBuilt 1965 · S/N 18256388N24895Lokker Dirk E · Oakdale, CABuilt 1977 · S/N 15280438N2489CRegistered aircraftBuilt 1954 · S/N 30789N2489GRogers Gregory J · Plesant Hill, MOBuilt 1959 · S/N 51789N2489JVan Velson Richard Lee · Brule, NEBuilt 1966 · S/N 15065589N2489LCalifornia Aviation Services Inc · Riverside, CABuilt 1966 · S/N 17255689N2489UKauachi Melik · Brownsville, TXS/N 17250089N2489XVanderweel Martha · Wolcott, NYBuilt 1965 · S/N 18256389N248BABering Air Inc · Nome, AKBuilt 2024 · S/N 208B5796N248ERUnverferth Gregory T · Fort Jennings, OHS/N 17271977N248GTHansen Nelse · Lawrenceville, GABuilt 1981 · S/N 17274572N248KAKamaka Air LLC · Honolulu, HIBuilt 2012 · S/N 208B2408N248PAPofolk Aviation Hawaii Inc · Honolulu, HIBuilt 1988 · S/N 208B0134N248ZLightsey Aviation LLC · Jacksonville, FLBuilt 1967 · S/N 17256247N24908Hnatio Matthew J · South Deerfield, MABuilt 1977 · S/N 15280445N2490JSchmitt Rudy · Brookshire, TXBuilt 1966 · S/N 15065590N2490LWimberly Thomas F III · Bend, ORBuilt 1966 · S/N 17255690N2490RBirdie Air LLC · Wichita, KSBuilt 1964 · S/N 18255590N2490UBredbenner Carl A · Dalmatia, PABuilt 1963 · S/N 17250090N2490XFoley David A Trustee · Afton, WYBuilt 1965 · S/N 18256390N2491GShowah Christopher Douglas · Indianola, MSS/N 51791
Back to AD 97-01-13