OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,368

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.

N95444Kent State University · Stow, OHBuilt 1984 · S/N 15285897N95445Kent State University · Stow, OHBuilt 1984 · S/N 15285898N9544HSouthern Aero LLC · Homestead, FLBuilt 1975 · S/N 17266217N9545BSunrise Aero Inc · Ocala, FLBuilt 1981 · S/N 172RG0870N9545MStull Ronald Wayne Jr · Ward, ARBuilt 1966 · S/N 670122N95469Kent State University · Stow, OHBuilt 1984 · S/N 15285899N9546HMiller Dale L · Bozeman, MTBuilt 1975 · S/N 17266219N9546MHood Michael T · Parrottsville, TNS/N 670123N95474Kent State University · Stow, OHBuilt 1984 · S/N 15285901N95475Kent State University · Stow, OHBuilt 1984 · S/N 15285902N9547LCivil Air Patrol · Maxwell Afb, ALBuilt 1986 · S/N 17276575N9547MDenig Daniel D · Albuquerque, NMBuilt 1966 · S/N 670124N9547TJk Gray Family LLC · Concord, NCBuilt 1978 · S/N 38-78A0128N9548GMeyer Bros Ag LLC · Algona, IABuilt 1974 · S/N 18801526TN9548MPetersen Todd Anthony · Simi Valley, CABuilt 1966 · S/N 670125N9549HBenson Edward A · San Antonio, TXBuilt 1975 · S/N 17266221N9549SZippy Airways LLC · Columbus, OHBuilt 1965 · S/N 7ECA363N9549TWilliams Dan John · Phoenix, AZBuilt 1978 · S/N 38-78A0129N954JHWings Over Texas LLC · Denton, TXBuilt 1975 · S/N 17266220N954NBreda John A · Needham, MABuilt 1968 · S/N 680131N954SASunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15280626N9550BMccall Freddie W · Brewton, ALBuilt 1981 · S/N 172RG0872N9550MAccess Chicago Inc · Orland Park, ILBuilt 1966 · S/N 670127N9551BLopes Gaston A · Dallas, TXS/N 172RG0873N9551MLoafman Michael A · Bowling Green, KYBuilt 1966 · S/N 670128N9551SBerberich John E · Wasilla, AKS/N 364N9552GJesse Shipman Farms LLC · Honey Grove, TXBuilt 1974 · S/N 18801529TN9552HZulu Aircraft Leasing LLC · Grants Pass, ORBuilt 1975 · S/N 17266223N9552SSmith Ranch Inc · Broadus, MTBuilt 1965 · S/N 42N9552VRico Aviation Services Inc · Miami, FLBuilt 1974 · S/N 17264354N95537High Expectations LLC · Wilmington, DEBuilt 1984 · S/N 15285916N95539Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1984 · S/N 15285917N9553MLolob Llp · Bozeman, MTBuilt 1966 · S/N 670130N9554MJohnson Kevin L · Bowling Green, KYS/N 670131N9554VCavu LLC · Fort Collins, COBuilt 1974 · S/N 17264356N95551Florida Flight Training Center · Venice, FLBuilt 1984 · S/N 15285919N95556Redstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1984 · S/N 15285922N9555GMccormick Eugene C · Tyler, ALBuilt 1974 · S/N 18801531N9555HWilkinson William · Anchorage, AKBuilt 1975 · S/N 17266226N9555MCarroll Brendan O · Aloha, ORS/N 670132N9555SMcquillin Duane C · Palmer, AKBuilt 1965 · S/N 370N9556JS & D Spraying Service Inc · Panhandle, TXBuilt 1981 · S/N 18803821N9556MVictory Lane Aviation LLC · Concord, NCBuilt 1966 · S/N 670133N9556VMiles James D · Memphis, TNBuilt 1974 · S/N 17264358N9557BGibson Robert B · Los Alamos, NMBuilt 1981 · S/N 172RG0879N9557VSkyhawk 57v Inc · Pittsburgh, PABuilt 1974 · S/N 17264359N9558SKansas Air LLC · Linn, KSS/N 39N9559MPerez Hector R · Orange Park, FLBuilt 1966 · S/N 670136N9559TGlanz William L · Central, AKBuilt 1978 · S/N 38-78A0131N955CCN955cc LLC · Estero, FLBuilt 1969 · S/N 17258826
Back to AD 80-25-07 R1