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.

N3259JPreflight Aviation Inc · Oregon, WIBuilt 1966 · S/N 15065959N3259RGlobal Marc Aire Inc · Dallas, TXBuilt 1973 · S/N U20602215N3259UMoore Christopher · Canton, PABuilt 1963 · S/N 18254659N3259VMaynard Richard L · Vilonia, ARBuilt 1974 · S/N 15076446N3259YGrantham William Edward · Doerun, GAS/N 18254259N325JSAbbott Bruce E · Seal Beach, CABuilt 1978 · S/N 15281288N325KCMount Wilson Holdings LLC · Orange, CABuilt 1981 · S/N 414A0825N325RPN325rp Corp · Willow Spring, NCBuilt 1985 · S/N P21000848N325UKilo Fox Aviation LLC · Saint Joseph, MIBuilt 1974 · S/N 15076531N326Nardi Greg · Missoula, MTS/N P33700238N3260LHerring Rhett H · College Station, TXBuilt 1967 · S/N 17256160N3260SAbner Aviation LLC · Advance, NCS/N 18255760N3260YOneal Gary · Springdale, ARBuilt 1962 · S/N 18254260N3261DCastorina John Salvatore · Anthem, AZBuilt 1955 · S/N 32059N3261SBig Island Gravity LLC · Kapaau, HIS/N 18255761N3262JBlock Oliver L · Nashville, TNS/N 15065962N3262LKd3262 LLC · Downers Grove, ILBuilt 1967 · S/N 17256162N3262SIlair LLC · Manassas, VABuilt 1964 · S/N 18255762N3263JCorrigan Air Center LLC · Hondo, TXS/N 18803623N3263LSale Reported · Arcata, CASale reportedBuilt 1967 · S/N 17256163N3263SBynum Albert L · Gadsden, ALBuilt 1964 · S/N 18255763N3264JB&K Used Auto & Equipment Llp · Fountain Run, KYBuilt 1966 · S/N 15065964N3264QWilton William H · Kailua Kona, HIBuilt 1967 · S/N 401-0064N3264TVan Iderstyne Richard D · Jekyll Island, GABuilt 1967 · S/N 17700564N3265DMiller Matthew S · Washougal, WABuilt 1955 · S/N 32063N3265ETa Brand LLC · Middletown, DEBuilt 1978 · S/N 17271483N3265JFord-Umfuhrer Austin Donavan · Carrollton, GAS/N 15065965N3265SZehntner David R · Labelle, FLBuilt 1964 · S/N 18255765N3265UPreissler Daniel E · Giltner, NEBuilt 1963 · S/N 18254665N3266EN3266e LLC · Homestead, FLBuilt 1978 · S/N 17271484N3266LWolverine LLC · Roanoke, VABuilt 1967 · S/N 17256166N3266UVingers Michael T · Dellwood, MNBuilt 1963 · S/N 18254666N3267DDavidson Danny F · Anchorage, AKBuilt 1955 · S/N 32065N3267LBetter Fly Inc · Litchfield, ILS/N 17256167N3268CLane Ryan Auctions LLC · Palmyra, PAS/N R18200262N3268JMiller Robert F · Locust Grove, GAS/N 15065968N3268KRegistered aircraftBuilt 1968 · S/N 17700519N3268QSuperior Food Distributors LLC · Naples, FLBuilt 1967 · S/N 401-0068N3268SSquier Mark R · Lake Dallas, TXBuilt 1964 · S/N 18255768N3268TKawsara Sabah M · Fort Worth, TXBuilt 1967 · S/N 17700568N326AMAviatzone LLC · Fort Lauderdale, FLS/N R18201474N326PTJt Aero LLC · Covington, GABuilt 1974 · S/N 310Q0968N3270DMcbride Robert W Jr · Cedar Park, TXBuilt 1955 · S/N 32068N3270UScott Brian W · Sagle, IDBuilt 1963 · S/N 18254670N3271LHenson Raul Andre · Fox Island, WABuilt 1967 · S/N 17256171N3271UDallas Avionics Inc · Dallas, TXBuilt 1963 · S/N 18254671N3271YWoodbury Ivan D · Bowling Green, OHBuilt 1962 · S/N 18254271N3272TSonoras John G Jr · Newport, MIBuilt 1967 · S/N 17700572N3272YOlsen Chris M · Othello, WAS/N 18254272N3273DMonitor Ventures Group LLC · Anaheim, CABuilt 1973 · S/N 33701491
Back to AD 97-01-13