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.

N88RHKeystone Flyer LLC · Avon, INBuilt 1975 · S/N 32R-7680065N88RLLarson Kris K · Fullerton, CABuilt 1977 · S/N 28R-7703240N88WBJason Aviation LLC · Wilmington, DEBuilt 1964 · S/N 26-24N88WHThomas Robert R · Rochester, MNBuilt 1968 · S/N 28R-30974N88WWQwest Aviation LLC · Edwardsburg, MIBuilt 1971 · S/N 39-125N8900PCabrejos-Guillen Roberto · Wichita, KSBuilt 1965 · S/N 24-4355N8901PRead Robert S · Peoria, AZBuilt 1966 · S/N 24-4356N8902PFarris Greg T · Ann Arbor, MIBuilt 1966 · S/N 24-4357N8903PBeyer Marvin A Jr · Taft, TXBuilt 1966 · S/N 24-4358N8903YBall Half Out LLC · Mesa, AZBuilt 1970 · S/N 39-58N8905PBulle Jason L · Phoenix, AZBuilt 1966 · S/N 24-4360N8906PComanche Inc · Leoti, KSBuilt 1966 · S/N 24-4361N8906YRegistered aircraftBuilt 1970 · S/N 39-61N8907FHughes Michael Anthony · Meridian, IDBuilt 1977 · S/N 28R-7703007N8910PComanche LLC · Peachtree City, GABuilt 1966 · S/N 24-4365N8911PVarga Craig S · Chino Valley, AZBuilt 1966 · S/N 24-4366N8912FHaddock Richard R · Aiken, SCBuilt 1977 · S/N 32R7780119N8912PPotts John L · Enterprise, ALBuilt 1966 · S/N 24-4367N8914YHarris William M · Christiansburg, VABuilt 1970 · S/N 39-71N8915PLegacy Aviation Mid-Michigan LLC · Kalamazoo, MIBuilt 1966 · S/N 24-4370N8917PLogsdon James C · Hanford, CABuilt 1966 · S/N 24-4372N8917YHigh Flyers Inc · Jackson, TNBuilt 1970 · S/N 39-76N8919PHealey Patrick T · Tucson, AZBuilt 1966 · S/N 24-4374N891MDCharbonneau John E · Manhattan, KSBuilt 1960 · S/N 24-2045N891SGSouthern Aircraft LLC · Valdosta, GABuilt 1975 · S/N 34-7570311N8921POwens Gregory E · Kendallville, INBuilt 1966 · S/N 24-4377N8924YPrestininzi Robert Anthony · Fort Mill, SCBuilt 1969 · S/N 30-1997N8925PGriffith James E · Gig Harbor, WABuilt 1966 · S/N 24-4381N8925YBlue Sky Adventures LLC · Hanover, PAS/N 39-81N8926PGallagher Derek P · O Fallon, ILS/N 24-4382N8928PGeorg John B · La Crosse, KSBuilt 1966 · S/N 24-4384N892RCSmw-Cjh Corp · Wilmington, DEBuilt 1966 · S/N 24-4379N8931PDuncan Michael J · Cordova, TNBuilt 1966 · S/N 24-4387N8932P260b LLC · San Diego, CABuilt 1966 · S/N 24-4388N8934PNermernuh LLC · Chester, CTBuilt 1966 · S/N 24-4390N8934YFuller John M · Minden, NVBuilt 1971 · S/N 39-95N8936PGesenhues Bernard J · Canton, OHBuilt 1966 · S/N 24-4392N8938YUniversity Of Alaska Anchorage · Anchorage, AKBuilt 1971 · S/N 39-99N8940PDavie Andrew S · Stony Point, NYBuilt 1966 · S/N 24-4396N8942PAncelet Grant D · Crowley, LABuilt 1966 · S/N 24-4398N8944PPittner Hans C · Goshen, NYBuilt 1966 · S/N 24-4400N8944YTallman Michael Daniel · Latrobe, PABuilt 1971 · S/N 39-105N8945YPipers Are Still Better LLC · Carson City, NVS/N 39106N8946PBreding Ralph E · American Falls, IDBuilt 1966 · S/N 24-4402N8947YStroh Chuck · Yukon, OKBuilt 1971 · S/N 39-108N8948YKilpatrick Kerry · Somerset, NJBuilt 1971 · S/N 39-109N8949CMorgan Aviation LLC · Greensboro, NCBuilt 1976 · S/N 28R-7635186N8951PJames Donnie E · Collinsville, ALBuilt 1966 · S/N 24-4408N8952PBreckenridge Lester James Jr Trustee · Appleton City, MOBuilt 1966 · S/N 24-4409N8953PTendie Time Flying LLC · San Diego, CABuilt 1966 · S/N 24-4410
Back to AD 97-01-01 R1