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.

N2962RHurn Enterpises LLC · Grand Beach, MIS/N 28R-35347N2965RSouthwinds Export Inc · Kissimmee, FLNon-citizen corporation, flight hours not reportedS/N 34-7970425N2966RTobin Michael A · Plain City, OHBuilt 1969 · S/N 28R-35351N2968THarrison Mark A · Corpus Christi, TXS/N 34-7970433N2969DSundance Aviation LLC · Las Cruces, NMS/N 34-7970436N296DMDewitt Gary S · Anacortes, WAS/N 28R-7635033N296MGGeorgia Aviation Authority · Eastman, GABuilt 2017 · S/N 2844168N2970RNorwood Norman · Sheridan, WYBuilt 1969 · S/N 28R-35354N2972RDahl Steven B · Medway, MABuilt 1969 · S/N 28R-35357N2973RQuinones Roland · Mckinney, TXS/N 28R-35358N2977RRegistered aircraftBuilt 1969 · S/N 28R-35363N2978RLong Jeffrey K · Bethel Springs, TNBuilt 1969 · S/N 28R-35365N2979RBecker Joshua · Warrington, PABuilt 1969 · S/N 28R-35366N2980QBlb Aircraft Partners LLC · Wilmington, DES/N 32R-7780274N2980RSlagle Noah J · Griffin, GABuilt 1969 · S/N 28R-35368N2982MBergeron John E · Shenandoah, TXBuilt 1977 · S/N 28R-7803158N2986RArmstrong Dustin L · Hobbs, NMS/N 28R-35375N2988RSpilman Kathleen M · Mandan, NDBuilt 1970 · S/N 28R-35671N2992RSolrei Inc · West Palm Beach, FLS/N 28R-35382N2993RSell Carl N · Spanaway, WABuilt 1969 · S/N 28R-35384N2994R2994r Aircraft Leasing LLC · Spanish Fork, UTBuilt 1969 · S/N 28R-35386N2995QTraveling Aviators LLC · West Valley City, UTS/N 32R-7780275N2995RAbj Aviation LLC · Montgomery, OHBuilt 1969 · S/N 28R-35387N2999RMatthews Flying Club LLC · Ogden, UTBuilt 1969 · S/N 28R-35391N299MGGeorgia Aviation Authority · Eastman, GABuilt 2018 · S/N 2844181N29ABStevens Timothy E · Tyrone, GABuilt 1976 · S/N 32R-7780027N29BJMax Total Time LLC · Lufkin, TXBuilt 1958 · S/N 24-398N29CWHamilton Aerospace LLC · Lovettsville, VAS/N 34-7570306N29FZTrn Aviation LLC · Mcallen, TXBuilt 1977 · S/N 28R7703052N29RMRedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1975 · S/N 28R-7535269N29SCBrown Sherrie C · Cushing, OKBuilt 1962 · S/N 24-3125N29SDRegistered aircraftBuilt 1968 · S/N 28R-30583N29SPPurpera Daryl G · Pride, LAS/N 28R-35695N2ABBailey Richard T · Oregon City, ORBuilt 1960 · S/N 24-1941N2BYMostello Andrew · Harvard, MABuilt 1977 · S/N 28R-7737129N2DVLewis Paul A · Spring, TXBuilt 1960 · S/N 24-1679N2DWSquare One Enterprises Corp · Hot Springs, ARBuilt 1973 · S/N 28R-7335368N2HSIsland Pearl Airways · Doral, FLBuilt 1979 · S/N 34-8070022N2NZFriedland Dana K Jr · Mountain Home, ARS/N 32R-7780111N2RTBarnett Keri Trustee · Brownfield, TXBuilt 1969 · S/N 24-4830N2SVPiper J D · Lawrenceville, ILBuilt 1963 · S/N 24-3428N2SXCastello Gregory R · Spencer, WVBuilt 1975 · S/N 32R-7680020N2UNSuriel Darleny G · New York, NYBuilt 1969 · S/N 28R-31080N2VGWong Jonathan · Phoenix, AZBuilt 1969 · S/N 30-1875N2VQN2vq LLC · Manassas, VABuilt 1964 · S/N 30-563N2XHAmericas Best Amt Inc · Goodyear, AZBuilt 1964 · S/N 30-473N2YPCollum Aviation LLC · Milton, FLS/N 30-452N3000FNosense LLC · Kalispell, MTS/N 34-7970044N30024Druid Aire LLC · Wilmington, DEBuilt 1978 · S/N 28R-7837311N300DESchmidt Arthur J · Tampa, FLS/N 34-7770157
Back to AD 97-01-01 R1