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.

N7047YJenkins Joe C · Wyoming, DEBuilt 1963 · S/N 30-50N7048PGerard Garrett · North Bend, OHBuilt 1960 · S/N 24-2196N7050PBork Joseph L · Mosier, ORS/N 24-2199N7050YTonys Aerial Service Inc · Great Bend, KSBuilt 1963 · S/N 30-53N7052PFlying Great Danes LLC · Chesapeake, VABuilt 1960 · S/N 24-2201N7053PManter Earl F · Delaware, OHBuilt 1960 · S/N 24-2202N7054YNordman Clay L · Catheys Valley, CABuilt 1963 · S/N 30-65N7055PKehrle Betty M · Chandler, AZBuilt 1960 · S/N 24-2205N7056PSelf Melvin Lamar Jr · Greenwood, MSBuilt 1960 · S/N 24-2206N7059PProx Jonathan P · Enterprise, ALBuilt 1960 · S/N 24-2209N7059YPhill-Air Inc · Dover, DEBuilt 1963 · S/N 30-70N7061YHoistad Flying Service Inc · Forman, NDBuilt 1963 · S/N 30-73N7062YFox Norman A · Maryville, TNBuilt 1963 · S/N 30-74N7065PReno Joshua · Krum, TXBuilt 1960 · S/N 24-2217N7066PEckel Kenneth · Hernando, MSBuilt 1960 · S/N 24-2218N7067YCactus Skybolt Aviation LLC · Athens, ALBuilt 1963 · S/N 30-80N7068PLs Engineering Inc · Salt Lake City, UTBuilt 1960 · S/N 24-2220N7068YAdvanced Aircrew Training LLC · Nashua, NHBuilt 1963 · S/N 30-81N7069PD And S Neotech Inc · Ogden, UTBuilt 1961 · S/N 24-2221N7070PHytry Randal G · De Soto, WIBuilt 1960 · S/N 24-2222N7070YBean James P · Tulsa, OKBuilt 1963 · S/N 30-83N7071PNelson Harold G · Pendleton, ORBuilt 1960 · S/N 24-2223N7071YJts Aircraft LLC · Rock Hill, SCS/N 30-84N7072PRegistration Pending · Kalispell, MTRegistration pendingBuilt 1960 · S/N 24-2224N7073PPeavy Jason L · Waco, TXBuilt 1960 · S/N 24-2225N7074YWsv Aero Inc · Wilmington, DEBuilt 1963 · S/N 30-87N7076PDevils Lake Aero Repair Inc · Devils Lake, NDS/N 24-2228N707PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7250149N7080POstmo Robert P · Wahpeton, NDBuilt 1960 · S/N 24-2232N7081YHershey Everett D · Pantego, NCBuilt 1963 · S/N 30-95N7084CFly Twin Comanche LLC · Peoria, AZBuilt 1975 · S/N 34-7670085N7084PFreeman Jet LLC · Cape Coral, FLBuilt 1960 · S/N 24-2237N7084YArkadelphia Aircraft Services Inc · Jonesboro, ARBuilt 1963 · S/N 30-99N7085PFlyum LLC · Bay City, MIBuilt 1961 · S/N 24-2238N7086PKirby Frank P Jr · Huntington, WVBuilt 1960 · S/N 24-2239N7087YRegistered aircraftN-number assigned, not yet registeredS/N 30-102N7088PDerksen Ronald E · Xenia, ILS/N 24-2241N7089PElliott James Richard · Florence, ALBuilt 1960 · S/N 24-2242N7089YReed Joellen A · Newborn, GABuilt 1963 · S/N 30-104N70905T F S Aviation Corp · Fort Lauderdale, FLBuilt 1979 · S/N 347970078N7092PPaul Eric C · Grapevine, TXBuilt 1961 · S/N 24-2246N7093YMoore James S Trustee · Gray Court, SCBuilt 1963 · S/N 30-108N7094PS & M Aviation LLC · South Boston, VABuilt 1960 · S/N 24-2249N70EF720 Degrees Inc · Santa Monica, CABuilt 1972 · S/N 28R-7335064N70GVWeidner Melvin · Elk Grove, CAS/N 24-482N70JMTriple M Investments LLC · Whitehall, PABuilt 1976 · S/N 32R-7680259N70MHN70mh LLC · Wilmington, DEBuilt 1976 · S/N 28R-7635390N70SRBray Max W · Dora, ALBuilt 1967 · S/N 28R-30122N7101YN7101y LLC · Wilmington, DEBuilt 1963 · S/N 30-119N7103PRiegel Robert L · South Pasadena, CABuilt 1960 · S/N 24-2259
Back to AD 97-01-01 R1