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.

N7535YN7535y LLC · Sylvania, OHBuilt 1964 · S/N 30-598N7536JRicol Aviation LLC · Naples, FLBuilt 1968 · S/N 28R-30910N7537JGetsie Thomas A · Monroeville, PABuilt 1968 · S/N 28R-30911N7537YCecerr Paul E · Olive Branch, MSS/N 30-601N75386Three Piloteers LLC · Bloomington, INBuilt 1976 · S/N 28R-7635294N75387Latitude 63 LLC · Anchorage, AKBuilt 1976 · S/N 32R-7680298N7538YEdwards John G · Stoneville, NCBuilt 1964 · S/N 30-602N75391Brennan Matthew J · Loveland, OHBuilt 1976 · S/N 34-7670246N75397Modern Farm LLC · Chandler, AZBuilt 1976 · S/N 32R-7680301N75398Skybochs LLC · Kaysville, UTS/N 32R-7680302N7539YChristianini Cassio Pereira · Plantation, FLBuilt 1964 · S/N 30-603N753KSCoastal Alabama Aviators LLC · Daphne, ALBuilt 2015 · S/N 2844159N753SPKor Wesley D · White, SDBuilt 1961 · S/N 24-2740N7542YLyle Eugene W · Honesdale, PABuilt 1965 · S/N 30-606N7544JHewitt Robert J · Ringwood, NJS/N 28R-30917N7545JP D Q Space Arrow Inc · Atlanta, GABuilt 1968 · S/N 28R-30918N7545PFriebert Stephen E · Elk Grove, CABuilt 1961 · S/N 24-2752N7546YBrilliant Holdings LLC · Winfield, MOBuilt 1965 · S/N 30-609N7547JMiller Larry N · Warr Acres, OKBuilt 1968 · S/N 28R-30921N7548JSnider Steve P · Anacortes, WABuilt 1968 · S/N 28R-30922N7548PSecolad N7548p LLC · Madison, INS/N 24-2756N7549PAlbano Alan T · Elbert, COBuilt 1961 · S/N 24-2757N7551FBushwackers Leasing LLC · Calera, OKS/N 32R-7780062N7551JKaercher Douglas A · Havre, MTBuilt 1968 · S/N 28R-30926N7551PKassik Ryan W · Commerce City, COS/N 24-2759N7551YWills Terry W · Cedar Park, TXBuilt 1964 · S/N 30-614N7552PSaunders Frank H · Salinas, CABuilt 1961 · S/N 24-2760N7553JThunder Arrow Corp · Santa Monica, CANon-citizen corporation, flight hours not reportedBuilt 1968 · S/N 28R-30929N7555JKeller Terry · Sedona, AZBuilt 1968 · S/N 28R-30931N7555YHirvonen Jukka Matti · Oak Ridge, NCBuilt 1964 · S/N 30-618N7556JKern Aviation LLC · Shawnee, KSBuilt 1968 · S/N 28R-30933N7558PAngst Matthew J · Wilmington, OHBuilt 1961 · S/N 24-2767N7559JHale Edward L · Kingfisher, OKBuilt 1968 · S/N 28R-30937N7560JRankin Kevin J · Maryville, MOBuilt 1968 · S/N 28R-30938N7560PFlying Warriors LLC · Kearney, NEBuilt 1961 · S/N 24-2769N7560YRa Procurement LLC · Maypearl, TXBuilt 1964 · S/N 30-623N7561PHand Nicholas P · Tahlequah, OKBuilt 1961 · S/N 24-2770N7561YStinson Aviation LLC · Middletown, DEBuilt 1964 · S/N 30-624N7562JPrice Jesse L · Fargo, NDBuilt 1968 · S/N 28R-30940N7562PMinden Aircraft Repair Inc · Minden, NVBuilt 1961 · S/N 24-2771N7562YOtten John P · Lingle, WYBuilt 1964 · S/N 30-625N7563JKring Neal A · Ash Flat, ARBuilt 1968 · S/N 28R-30941N7564JElliott Gregg S · Eaton Rapids, MIS/N 28R-30942N7565JSteffensen David J · Grimesland, NCBuilt 1968 · S/N 28R-30943N7565PWagner Chelsea Mele · Santa Cruz, CAS/N 24-2774N7565YVictor Robert W Jr · Topeka, KSBuilt 1964 · S/N 30-629N7566YS & D Adventure LLC · Middletown, DEBuilt 1964 · S/N 30-630N7567JFidelis Universal Technology Inc · Chino Hills, CABuilt 1968 · S/N 28R-30946N7568JRoberts Donald B · Albion, ILBuilt 1968 · S/N 28R-30947N7568PBroussard James · Colmesneil, TXBuilt 1961 · S/N 24-2779
Back to AD 97-01-01 R1