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.

N570UOhio University · Albany, OHBuilt 2001 · S/N 2844054N5712PGibson Kevin M · Denver City, TXBuilt 1959 · S/N 24-786N5716FClaridge Management Group LLC · Sunrise, FLBuilt 1976 · S/N 32R 7780018N5717PGraber Tim B · Santee, CABuilt 1959 · S/N 24-791N5720PPatterman Emil S · Fort Worth, TXS/N 24-794N5722PCrazy 8 Aviation LLC · Ridgecrest, CABuilt 1959 · S/N 24-796N5725PJason Waddell Pllc · Oklahoma City, OKBuilt 1959 · S/N 24-799N5728PElite Aviation LLC · Grants Pass, ORBuilt 1959 · S/N 24-802N57298Trent Daniel R Sr · Point Pleasant, WVBuilt 1973 · S/N 28R-7435074N5729PSturt Michael H · Whitehouse, OHBuilt 1959 · S/N 24-803N57305C And D Company LLC · Lake Park, MNS/N 28R-7435077N57324Richards Jeremy · Franklin, TNBuilt 1973 · S/N 28R-7435080N57325Baker Ken C · Tehachapi, CABuilt 1973 · S/N 28R-7435081N57338Meyer Jerry W · Conway, ARBuilt 1973 · S/N 28R-7435082N5733PStrattner Brian J · Chesapeake, VABuilt 1959 · S/N 24-807N57343Arrow Plane Inc · Chapel Hill, NCBuilt 1973 · S/N 28R-7435083N5743VBohm David · Walnut Creek, CABuilt 1977 · S/N 28R-7703152N5745PMiller Aaron T · New Braunfels, TXS/N 24-819N5746PYinyan Tech US Inc · Brea, CANon-citizen corporation, flight hours not reportedBuilt 1959 · S/N 24-820N5748PBaxter Randall T · Maple, NCBuilt 1959 · S/N 24-823N5750PRoberts Donald W · Flower Mound, TXBuilt 1959 · S/N 24-825N5751PKrager Aviation LLC · Perry, UTBuilt 1959 · S/N 24-826N5758PBarr Michael J · Colorado Springs, COBuilt 1959 · S/N 24-834N5759PDemars Michael · California, MDBuilt 1959 · S/N 24-836N5760PLoughlin Robert J · Midland, TXBuilt 1959 · S/N 24-838N5765PWomack Calvin E · Lakeside, TXBuilt 1959 · S/N 24-843N5766PMid Pacific Aero Services LLC · Honolulu, HIS/N 24-844N5767PMcdowra Christopher L · Paris, TXS/N 24-845N5768PBrooks David Paul · Mantorville, MNBuilt 1959 · S/N 24-846N5771PWhisky Zulu Inc · Klamath Falls, ORBuilt 1959 · S/N 24-849N5772PKasakoff Lloyd Abraham · Houston, TXBuilt 1959 · S/N 24-850N5775PChelf James Michael · Cedar Park, TXBuilt 1959 · S/N 24-853N5778PHunton Hugh R II · Midlothian, TXBuilt 1959 · S/N 24-857N5779PLechner Kevin P · Wurtsboro, NYBuilt 1959 · S/N 24-858N577DPLustfeldt Gordon L · Normal, ILBuilt 1959 · S/N 24-848N577TWBunn Jaime · New Canton, ILS/N 32R-7780122N5780PWall Scott · Franksville, WIBuilt 1959 · S/N 24-859N5782PPaviation LLC · Lewes, DEBuilt 1959 · S/N 24-861N5784PMiller Jeffery Allen · Menifee, CAS/N 24-863N5785PSmith Clyde R Jr · Lock Haven, PABuilt 1959 · S/N 24-864N5786PMckowan Sheila R · Chatsworth, CAS/N 24-865N5788Knot Speed Ltd · Wilmington, DEBuilt 1966 · S/N 24-4580N5789PNiche Pharmaceuticals LLC · Shorewood, MNBuilt 1959 · S/N 24-868N5790VJohnson James E · Calhoun, LAS/N 28R-7703153N5792PLadet William D · Las Vegas, NVS/N 24-871N5798PCiotta Anton Albert · Wallingford, CTBuilt 1959 · S/N 24-878N5799PMorgan E Neal · San Diego, CABuilt 1959 · S/N 24-879N579GZEuroaviation Inc Trustee · KematenBuilt 1978 · S/N 28R7803212N57AASouth Texas Weather Modification Association · Pleasanton, TXBuilt 1962 · S/N 24-3303N57CKCarefree Aviation LLC · Lock Haven, PABuilt 2014 · S/N 2844149
Back to AD 97-01-01 R1