OpenAirDocs.org
AD 97-01-01 R1

Registered aircraft · 6,915

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.

N3945TElsinger Vincent R · Pierre, SDS/N 28R30288N39466Xing Kong Aviation Service LLC · Atwater, CABuilt 1978 · S/N 34-7870379N3946TPotter Allen W · Clinton Corners, NYBuilt 1967 · S/N 28R-30289N39476Neal John W · Pt Pleas Bch, NJBuilt 1978 · S/N 28R-7803348N39477Marti Michael · Kasson, MNBuilt 1978 · S/N 28R-7803349N3948TSchmidt Stephen M · Tipp City, OHS/N 28R-30291N3949MMatthews Devon · San Jose, CABuilt 1978 · S/N 28R-7803204N3949THathaway Devon Scott · Buna, TXS/N 28R-30292N3949XBlue Ridge Flyers · Leesburg, VABuilt 1975 · S/N 28R-7535365N394LESage Aviation LLC · Milanville, PABuilt 1976 · S/N 32R-7680358N3950TPark 46 LLC · Savannah, GABuilt 1967 · S/N 28R-30293N39513Vitale F Richard · Colts Neck, NJBuilt 1978 · S/N 28R-7837300N3951TScott Stanley L · Milton, FLBuilt 1967 · S/N 28R-30294N3951XLucky 20 Gourmet And Adventure Club LLC · Syracuse, INBuilt 1975 · S/N 34-7670003N39522United States Air Force Elmendorf Aero Club · Elmendorf Afb, AKBuilt 1978 · S/N 34-7870385N3952TSmith William J · Seaford, VABuilt 1967 · S/N 28R30295N39530Carroll Aaron W · Sarasota, FLBuilt 1978 · S/N 34-7870386N39535Flight Services Inc · Headland, ALBuilt 1978 · S/N 28R-7837302N3953TUniversal Technical Institute Inc · Avondale, AZS/N 28R-30296N39547Workman Dean B · Newport, RIBuilt 1978 · S/N 28R-7837303N39568James David Wayne · Odessa, TXBuilt 1978 · S/N 28R-7803355N3956XHuth William L · Gulf Breeze, FLBuilt 1975 · S/N 28R-7535366N3957FSeipp Stephen C · Laurel, DEBuilt 1976 · S/N 28R-7635392N3958TPiowaty Craig M · Hilo, HIBuilt 1967 · S/N 28R-30303N39592Paratus Air Inc · Auburn, INFirst renewal noticeBuilt 1978 · S/N 34-7870395N39594J Airco LLC · Nashville, TNBuilt 1978 · S/N 34-7870396N395JJCate Kyle T · Johnstown, COBuilt 1978 · S/N 34-7870393N3960TThompson Jerry C · Goldsboro, NCBuilt 1968 · S/N 28R-30305N39611Boon & Company Aviation LLC · Charlotte, NCBuilt 1978 · S/N 28R-7803357N3961TMartin Noah R · Newcastle, CABuilt 1967 · S/N 28R-30306N3962TSilvretta LLC · Kalispell, MTBuilt 1967 · S/N 28R-30307N3962XPureflight Aviation Training LLC · Newberg, ORS/N 34-7670007N3963TBlessing Stephen L · Bethany, MOS/N 28R-30309N39646Icpc Craft LLC · Fremont, CABuilt 1978 · S/N 28R-7803358N3964TFisher Joseph A · Conway, ARBuilt 1967 · S/N 28R-30310N39655Weather Modification LLC · Fargo, NDBuilt 1978 · S/N 34-7870403N3965THudgin Louis B · Gilbert, AZBuilt 1967 · S/N 28R-30311N3968TService Oriented Aviation Readiness (S O A R) · Bolivar, MOBuilt 1967 · S/N 28R-30315N3968XMoorhead Equipment LLC · Belton, SCBuilt 1975 · S/N 34-7670009N39718Wood Allan W · Santa Fe, NMBuilt 1978 · S/N 28R-7803359N39724Huebscher Attila · Pittstown, NJBuilt 1978 · S/N 34-7870418N3972TQualitair LLC Trustee · MichelstadtBuilt 1967 · S/N 28R-30321N3972XSoares Jeffrey A · Aptos, CABuilt 1975 · S/N 28R-7535378N3973TMeissner Edward T · Hartland, WIBuilt 1967 · S/N 28R-30322N3974XAngel Aviation Inc · Peoria, AZBuilt 1975 · S/N 34-7670011N39759Shoaf Thomas P · Alamogordo, NMBuilt 1978 · S/N 34-7870419N3977TBeauman James · Indianapolis, INBuilt 1967 · S/N 28R-30327N3979JMyers Melissa · Yukon, OKBuilt 1978 · S/N 34-7870346N397PCPapadopoulos Gustave · Summerland Key, FLBuilt 1962 · S/N 24-3189N3982XSauve Tiffany A · Racine, WIBuilt 1975 · S/N 28R-7535382
Back to AD 97-01-01 R1