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.

N9420NSpace Cadets Inc · El Cajon, CAS/N 28R-35132N9421NMitzoom Montana LLC · Lakeside, MTBuilt 1969 · S/N 28R-35133N9423NCox Ricky L · Bell Buckle, TNBuilt 1969 · S/N 28R-35135N9425NSpaniol Mark · Lula, GABuilt 1969 · S/N 28R-35137N9426NClodfelter Chet · Roachdale, INBuilt 1969 · S/N 28R-35138N9427NSchool Board Of Bay County Fl · Panama City, FLS/N 28R-35139N9427PPaul Burrell Aircraft LLC · Spring, TXBuilt 1969 · S/N 24-4935N9428NYatteau Michael G · Woodbridge, CABuilt 1969 · S/N 28R-35140N9430NOakley Air LLC · Oakley, MIBuilt 1969 · S/N 28R-35142N9430PBonn Fred H · Jamestown, KYBuilt 1970 · S/N 24-4938N9434PSheehan James A · Newberg, ORBuilt 1970 · S/N 24-4942N9435NDoran Jeffrey · Centerburg, OHS/N 28R-35148N9435PWahl John B · Pendleton, ORBuilt 1970 · S/N 24-4943N9436PWarren Michael W · Wiscasset, MES/N 24-4944N9438PZimmerman Kyle R · Gilbert, AZBuilt 1970 · S/N 24-4946N9440NEshowe Aviation Inc · East Peoria, ILBuilt 1969 · S/N 28R-35154N9442NClear2aviate LLC · Ionia, MIBuilt 1969 · S/N 28R-35156N9443NSchulz John B Jr · Marquette, MIBuilt 1969 · S/N 28R-35157N9443PNyhus Daniel Alan · Payson, AZBuilt 1970 · S/N 24-4951N9447NEvans Jeff W · Hannibal, MOBuilt 1969 · S/N 28R-35162N9448NMason Harold R · Quincy, WABuilt 1969 · S/N 28R-35163N9449NCole Vincent J · Ewa Beach, HIFirst renewal noticeBuilt 1969 · S/N 28R-35164N944DBManning David A · Aledo, TXS/N 2844109N9450CStadler Kristopher D · Makawao, HIS/N 34-7870188N9450PSmh Aviation LLC · Dallas, TXBuilt 1970 · S/N 24-4957N9451NHorus Aviation LLC · Ashburn, VABuilt 1969 · S/N 28R-35166N9452PRegistered aircraftBuilt 1971 · S/N 24-4959N9453NBroody George E Jr · Berwick, PABuilt 1969 · S/N 28R-35168N9453PWhitehead Dennis C · Iron Mountain, MIBuilt 1970 · S/N 24-4961N9454PJohnson Roger D · Fort Meade, FLS/N 24-4962N9455NSchreiber Jeffrey H · Mundelein, ILBuilt 1969 · S/N 28R-35170N9457NHermes Aviation Partners LLC · Boca Raton, FLBuilt 1969 · S/N 28R-35172N9457PN84dt LLC · Missoula, MTBuilt 1971 · S/N 24-4965N9458NSwaz Aviation LLC · Mesa, AZBuilt 1969 · S/N 28R-35174N9458PAmerican Standard Aviation LLC · Burleson, TXBuilt 1971 · S/N 24-4966N9459NEngel Stephen J · Plymouth, INBuilt 1969 · S/N 28R-35175N9459PRegistered aircraftBuilt 1971 · S/N 24-4967N9461NJames Neville & Company Inc · Ocala, FLBuilt 1969 · S/N 28R-35177N9462NLombardo Gene S · New Bern, NCBuilt 1969 · S/N 28R-35178N9462PInternational Air Services Inc Trustee · Carson City, NVS/N 24-4970N9464NTempleton Katherine M · Madison, WIBuilt 1969 · S/N 28R-35180N9465NStenhouse Place I LLC · Fountain Inn, SCBuilt 1969 · S/N 28R-35181N9465PFtb Aviation LLC · Arden, NCS/N 24-4974N9466KSpanaflight LLC · Puyallup, WABuilt 1976 · S/N 28R-7635244N9466NWingert Douglas L · Smithfield, KYBuilt 1969 · S/N 28R-35182N9467PRiver Aviation LLC · Wilmington, DEBuilt 1971 · S/N 24-4977N9468PSmall Alan J · Bristol, RIBuilt 1971 · S/N 24-4978N9470NEdwards Ed · Collinsville, OKS/N 28R-35187N9471CHitpas Henry R II · Beaufort, SCBuilt 1978 · S/N 28R-7837200N9471PFly Yawa Aviation LLC · Statesboro, GAS/N 24-4982
Back to AD 97-01-01 R1