OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,370

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.

N5177HPomeroy Cattle Ranch LLC · Kalispell, MTBuilt 1975 · S/N 17265361N5177TJensen Larry F · Millington, MIBuilt 1967 · S/N 219N5177XAdams John L · Carmi, ILBuilt 1969 · S/N 683N5178RHampton Flying Services LLC · Portsmouth, NHBuilt 1974 · S/N 17263395N51793Lindsey Richard A · Richmond, TXBuilt 1980 · S/N 17274347N51794Christiansen Aviation LLC · Wilmington, DES/N 17274348N5179HFlight Time Builders Inc · Memphis, TNBuilt 1975 · S/N 17265362N5179THiggs Kathleen A · Garden Plain, KSBuilt 1967 · S/N 139N5179VFairmont State University · Fairmont, WVBuilt 1980 · S/N 172RG0460N5179XKor Reese W · Piedmont, SDBuilt 1969 · S/N 189N517CAFisher Richard L Jr · Saint Helens, ORS/N 17268100N517DLDelta Leema Aviation LLC · Moncks Corner, SCBuilt 1977 · S/N 17268965N517MSJewett John G · Ellensburg, WABuilt 1978 · S/N R18200681N517SMMcelvain Pete R · Iowa Park, TXBuilt 1968 · S/N 17257318N5180RMacdonald Kaitlyn · Dillon, MTS/N 17263397N5180XSouthern Sky Holdings LLC · Macon, GABuilt 1969 · S/N 190N5181HRegistered aircraftBuilt 1975 · S/N 17265363N5181REdelen Daniel R · Clayton, NCBuilt 1974 · S/N 17263398N5181TSchmetter Kenneth E · Needville, TXBuilt 1967 · S/N 508N5181XKummer Nicolas · Wenatchee, WABuilt 1969 · S/N 191N5182ERegistered aircraftBuilt 1978 · S/N 17271756N51832Southern Aircraft Consultancy Inc Trustee · Casper, WYS/N 17274357N5183ENashville Flight School LLC · Nashville, TNS/N 17271757N5183PAig Aeronautics LLC · Guaynabo, PRBuilt 1981 · S/N 15284890N5183RThompson Aerial Service Inc · Wyndmere, NDBuilt 1974 · S/N 17263400N5183TMinier Tryg · Corralitos, CABuilt 1967 · S/N 16N5183WG S I Training Services Inc · Branson, MOBuilt 1981 · S/N P21000650N5183XStory James W · Byhalia, MSBuilt 1969 · S/N 170N51840Sky Bubble LLC · Santa Ana, CABuilt 1980 · S/N 17274359N5184EStringfellow Timothy C · Maryville, TNBuilt 1978 · S/N 17271758N5184JRiverside Flight Academy LLC · Riverside, CAS/N 17273721N5184XComstock Derrick B · Salol, MNBuilt 1969 · S/N 173N5185DMartinez Richard Christian · Stockbridge, MIS/N 17272441N5185TRomano Serge · Beaverton, ORBuilt 1967 · S/N 15N51864Zita Air LLC · Lewisburg, PABuilt 1980 · S/N 17274361N51865Savage Michael B · Lincoln, CABuilt 1981 · S/N 17274362N5186HPope Brian B · Coalgate, OKBuilt 1975 · S/N 17265365N5186LKlippel Charlie L · Huntington Beach, CABuilt 1980 · S/N 15284276N5186XRochelle Stephen L · Raymond, MSBuilt 1969 · S/N 198N5186YHowe Jamie W · Boynton Beach, FLS/N 690030N51871Az2026 LLC · Miami, FLBuilt 1980 · S/N 17274366N51875Wings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 17274369N5187ENowak Michael J · Waxahachie, TXBuilt 1978 · S/N 17271760N5187GThompson Edward A · Sunset Beach, NCBuilt 1979 · S/N 17273555N5187JDagger Falls LLC · Boise, IDBuilt 1979 · S/N 313-79N5187RTke Ltd · Thief River Falls, MNBuilt 1974 · S/N 17263404N5187TLopes Steve R · Lancaster, WIBuilt 1967 · S/N 14N5187XBerkeland Jacob J · Bricelyn, MNBuilt 1969 · S/N 685N51883Angel Aviation Inc · Peoria, AZBuilt 1980 · S/N 17274371N51885Angel Aviation Inc · Peoria, AZBuilt 1980 · S/N 17274372
Back to AD 80-25-07 R1