OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,369

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:80-25-07-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:80-25-07-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.

N6683UReisner Kenneth D · Lecompte, LAS/N 2410N6684RRoberts Alec · Boulder, COS/N 427N6684UFowler Kenneth G · Newport, TNBuilt 1976 · S/N 24-0036N6685UMccroskey Wesley D · Kingston, TNBuilt 1963 · S/N 2412N6686NClarity Aviation LLC · Anchorage, AKBuilt 1978 · S/N 21063146N6686RAnderson Benjamin P · Bellevue, NEBuilt 1964 · S/N 429N6686UNorstegaard Mark A · Sturgis, SDBuilt 1963 · S/N 2413N6688NLedson Steven Noble · Sonoma, CAS/N 21063148N6688RFarley Clayton · Hanford, CABuilt 1964 · S/N 431N6689UStillman Troy C · Neenah, WIBuilt 1963 · S/N 2416N668BCThompson Mark D · Edgewood, TXBuilt 2015 · S/N 570-2015N6691RSgt Land And Cattle Co LLC · Bennington, KSBuilt 1964 · S/N 434N6691USchleis Ralph F · Manitowoc, WIBuilt 1963 · S/N 2418N66931Laguna Verde Leasing Inc · Wilmington, DES/N 15281668N6693HSwithenbank Leonard Co-Trustee · Fort Bragg, CABuilt 1975 · S/N 17265539N6693UShapiro Kier I · Oxnard, CABuilt 1963 · S/N 2420N66941Blue Mountain Airways LLC · Woodstock, GABuilt 1978 · S/N 15281676N66946Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15281681N66948Kuriger Michael R · Santa Clarita, CABuilt 1978 · S/N 15281683N6694EThunderbird Aviation LLC · Littleton, COBuilt 1978 · S/N 17272050N6694NGear Down LLC · Dalhart, TXBuilt 1978 · S/N 21063150N6694RRegistered aircraftBuilt 1964 · S/N 437N6694UWilson Larry · Campbellsville, KYBuilt 1963 · S/N 2421N66954Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281689N6695MRegistration Pending · Sheridan, WYRegistration pendingBuilt 1976 · S/N 17266695N6695RKepner Charles M · Shepherd, MIBuilt 1964 · S/N 438N66964Tyler Daniel Jr · Durango, COS/N 17275994N6696UAtkinson Matthew D · Theodore, ALS/N 2423N66970California Airways LLC · Hayward, CABuilt 1978 · S/N 15281696N66971Meridian Airport Authority · Meridian, MSBuilt 1978 · S/N 15281697N66977Unique Educational Experiences · Signal Hill, CABuilt 1978 · S/N 15281699N66978Tupper Daniel A · Groveland, CABuilt 1983 · S/N 17275995N6697RJ Bar Ranch LLC · Downey, IDBuilt 1964 · S/N 440N6699UGuy Carlo A · Ramona, CABuilt 1963 · S/N 2426N669CPEmerald Isle Apartments LLC · Los Angeles, CABuilt 2021 · S/N 1481-2021N669NEAcme Aircraft Flying Club LLC · Kalispell, MTBuilt 1981 · S/N 15285368N669XDiehl Steven K · Homestead, FLBuilt 1966 · S/N 68N66AALift Aviation LLC · Kingston, MABuilt 1977 · S/N 17270025N66CDKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1996 · S/N 1215-96N66GVPearson Robert L IV · Spartanburg, SCBuilt 1974 · S/N 17263861N66HMRegistered aircraftBuilt 1981 · S/N 24-1182N66JMRussman Nicholas S · Farmersville, TXBuilt 1981 · S/N 15285251N66LKeating Gregory D · Carpenter, SDBuilt 1966 · S/N 60N66MACp Aviation · Santa Paula, CABuilt 1985 · S/N 17276376N66MMTake Flyt LLC · Eagle Lake, MNBuilt 1976 · S/N 17266632N66PArchangel One LLC · Lewes, DEBuilt 1978 · S/N 17270824N66PMMajestic Air LLC · Lowell, MIBuilt 1979 · S/N 500-79N66PRPeterjohn Management II LLC · Pound Ridge, NYBuilt 1980 · S/N 17273879N66SEDaubenberger Joseph R · Hood River, ORBuilt 1973 · S/N 368-73N66TEFly4fun LLC · El Segundo, CABuilt 1978 · S/N P21000154
Back to AD 80-25-07 R1