OpenAirDocs.org
AD 97-01-01 R1

Registered aircraft · 6,916

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-01-R1')
    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-01-R1')
  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.

N7712PLenbom Mark A · Cameron, WIBuilt 1961 · S/N 24-2925N7713PFoster Mica J · Derby, KSBuilt 1961 · S/N 24-2926N7713YDarragh Jeff · Fort Myers, FLBuilt 1965 · S/N 30-802N7716PWhite Donald R · La Ward, TXFirst renewal noticeBuilt 1962 · S/N 24-2929N7718PVan Develde Robert K · Troy, MIBuilt 1961 · S/N 24-2931N7719PSchidlowsky Michael · Otis, MABuilt 1961 · S/N 24-2932N771PTPilot Training Center LLC · Miami, FLBuilt 2000 · S/N 2844027N7721CRenfro Jacqueline L · Bethel, AKBuilt 1975 · S/N 32R-7680060N7724CBiedenharn John D · Sunset Beach, CABuilt 1975 · S/N 34-7670102N7725PTully Martin · Idalou, TXBuilt 1961 · S/N 24-2939N7727PTaylor Aviation LLC · Corning, ARBuilt 1961 · S/N 24-2941N7728YArr Enterprises Inc · Yorkville, ILBuilt 1965 · S/N 30-817N7729PPendergast Gary · Clermont, FLBuilt 1961 · S/N 24-2943N7729YFogle Neil · Conroe, TXBuilt 1965 · S/N 30-818N772FTJazz Air LLC · Melbourne, FLBuilt 2000 · S/N 2844029N772WSSouthwest Technology Center School District No. 27 · Altus, OKBuilt 1967 · S/N 28R-30083N7730PCox Paul G · Bryce, UTBuilt 1962 · S/N 24-3107N7731PSchwehm Karl E · Roach, MOS/N 24-2945N7732PMckenney Michael P · Spring, TXBuilt 1961 · S/N 24-2946N7732YPurcell David S · Chandler, AZBuilt 1965 · S/N 30-821N7733PKeller Kevin M · Sylvania, OHBuilt 1961 · S/N 24-2947N7734YRussell R Bruce · Clayton, GABuilt 1965 · S/N 30-824N7735PVickers Tim F · Huntingdon, TNBuilt 1961 · S/N 24-2949N7736CSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1975 · S/N 28R-7635116N7736PJmj Aviation LLC · Kalispell, MTS/N 24-2950N7737PFlying Ankers LLC · Saint Marys, OHS/N 24-2951N7738YAristizabal Leonardo · Van Nuys, CABuilt 1965 · S/N 30-828N7739PBloom James R · Port Matilda, PABuilt 1961 · S/N 24-2953N773FTRatte David R · W Melbourne, FLBuilt 2000 · S/N 2844030N7743PWelch Brandon D · Liberty Hill, TXBuilt 1961 · S/N 24-2958N7743YSchroeder David C · Norfolk, NEBuilt 1965 · S/N 30-833N7744YCossette Aircraft LLC · Laporte, MNBuilt 1965 · S/N 30-835N7745PFleming James D · Alamosa, COBuilt 1961 · S/N 24-2960N7746PFlip Flops & Flight Plans LLC · Saint Petersburg, FLBuilt 1962 · S/N 24-2961N7746YSnow Robert I · New Caney, TXBuilt 1965 · S/N 30-837N7747YBohannon Philip Wayne · Houston, TXBuilt 1965 · S/N 30-838N7748PCardiovascular Service Associates · Downers Grove, ILBuilt 1961 · S/N 24-2963N774LRCampbell Jeffrey R · Surprise, AZBuilt 1974 · S/N 28R-7435297N7750PLeonardi Aldo · Woodland, CAS/N 24-2775N7750YWelden Charles R · Hoover, ALFirst renewal noticeBuilt 1965 · S/N 30-853N7751PGulf South Aero LLC · Raymond, MSBuilt 1961 · S/N 24-2965N7753PDarr Jacob L · Trinity, NCBuilt 1962 · S/N 24-2967N7754PMagner Air LLC · Leesburg, VABuilt 1961 · S/N 242969N7755PBubak Land And Cattle LLC · Imperial, NEBuilt 1961 · S/N 24-2971N7756P56pop LLC · Fremont, OHBuilt 1962 · S/N 24-2972N7758PSkalsky Todd A · Hartley, TXBuilt 1961 · S/N 24-2974N7758YMead Aviation LLC · Missoula, MTBuilt 1965 · S/N 30-790N7761YBytes Aviation LLC · Poolesville, MDBuilt 1965 · S/N 30-848N7764PBas Part Sales LLC · Greeley, COBuilt 1961 · S/N 24-2981N7765PRegistered aircraftBuilt 1961 · S/N 24-2982
Back to AD 97-01-01 R1