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.

N11PYCuller John T · Arvada, COBuilt 1964 · S/N 30-533N11QTAv8rs LLC · Sugar Valley, GABuilt 1968 · S/N 30-1780N11RPN11rp LLC · Brecksville, OHBuilt 1978 · S/N 28R-7803241N11RRRichardson Randy R · St Thomas, VIS/N 28R-7803076N11YNN3412w LLC · Lithia, FLS/N 34-8070059N11YYAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1967 · S/N 30-1573N1206APelham Aircraft LLC · Dallas, TXBuilt 1966 · S/N 301206N120CDJackson Farms Callahan Division LLC · Callahan, FLBuilt 1974 · S/N 28R-7435315N120SGlenn Robert · Boulder, COBuilt 1958 · S/N 24-125N12134Everson Corey A · Madison, ALBuilt 1964 · S/N 24-3598N1216TOlsen Christopher D · Bothell, WABuilt 1972 · S/N 28R-7235238N1217TSauer Roger A · Glenburn, NDBuilt 1972 · S/N 28R-7235239N1219TLrh Equipment LLC · Pendleton, ORBuilt 1972 · S/N 34-7250265N121DBTexins Flying Club · Mckinney, TXBuilt 1972 · S/N 28R-7335024N121GHSunset Aviation LLC · Huntington, INBuilt 1977 · S/N 32R-7780262N121TWBlue Ridge Mountain Flyers Aviation LLC · Mineral Bluff, GABuilt 1977 · S/N 32R-7780301N121WAWeather Modification LLC · Fargo, NDBuilt 1979 · S/N 34-7970435N121WSOrtiz Ramon E · Spring Branch, TXBuilt 1978 · S/N 28R-7803340N1220ZColumbus State Community College · Columbus, OHBuilt 1959 · S/N 24-800N1222TPraniewicz Charles P · New Kensington, PABuilt 1968 · S/N 28R-30582N1223Munning Joseph H Md · Jasper, INBuilt 1961 · S/N 24-2906N1227TStieper David Paul · Forest Lake, MNBuilt 1972 · S/N 28R-7235241N1229TPiper Electric Inc · Deer Park, NYBuilt 1972 · S/N 34-7250267N122MCShouk Aviation LLC · Waverly, OHBuilt 2007 · S/N 2844133N1230TWings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 34-7250268N1234UInternational Air Services Inc Trustee · Carson City, NVS/N 348070336N12354Spencer Christopher · Voorheesville, NYBuilt 1968 · S/N 28R-30607N1236Entwistle Brian V · Knoxville, TNS/N 30-1167N1236TOtero Edgardo A · Tucson, AZBuilt 1972 · S/N 28R-7235244N1239TPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7250270N123APJc Air Academy Inc · Stockton, CABuilt 1977 · S/N 34-7770015N123HMComanche Air LLC · Mokena, ILBuilt 1961 · S/N 24-2912N123KCHelms Brandon M · Indian Trail, NCBuilt 1976 · S/N 32R-7680431N123LMMccleary Bryan W · Marion, OHBuilt 1967 · S/N 24-4669N123MKSolomon Steven · Cherry Hill, NJBuilt 1965 · S/N 26-141N124MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 2844092N124NREckhoff Daniel · Ramsey, MNBuilt 1960 · S/N 24-1839N1253TDellemonoche Dennis R · Tabernacle, NJBuilt 1972 · S/N 28R-7235247N1254HSherer Scott · Franklin, WIBuilt 1976 · S/N 28R-7703018N1254TStewart Doug A · Indianola, NEBuilt 1972 · S/N 28R-7235248N125FLAll Star Capital LLC · Concord, NCBuilt 1980 · S/N 34-8170025N125MTMcdonald Theresa C · Beaufort, SCS/N 2844093N1265HKingsky Flight Academy LLC · Lakeland, FLS/N 34-7770117N126HJPeterson Charles William · Midway City, CABuilt 1969 · S/N 24-4878N126MAWinter Kristin A · Spring Lake Park, MNBuilt 1969 · S/N 30-1865N126PFPylant Ruth A · Lubbock, TXS/N 30-1122N1272TMyers Brent A · Palm Bay, FLBuilt 1972 · S/N 28R-7235252N1273HCrabtree Robert E · Lookout Mountain, TNS/N 28R-7703019N1278HMetzner Brad · Visalia, CAS/N 34-7770118N127MTPilotsplane LLC · Boca Raton, FLBuilt 2003 · S/N 2844094
Back to AD 97-01-01 R1