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.

N61645Lima-001 LLC · Muscatine, IABuilt 1975 · S/N 17264698N61648Tnt Airworks LLC · Hibbing, MNS/N 17264699N6164FBlue River Aviation LLC · Palmer, AKBuilt 1979 · S/N 17273158N61651Clw Aviation LLC · Springville, ALBuilt 1975 · S/N 17264702N61655Air Planes LLC · Soddy Daisy, TNBuilt 1975 · S/N 17264704N61656Dismang Chad C · Boynton, OKS/N 17264705N61657Bell Ornithopters Flying Club Inc · Eastlake, COBuilt 1975 · S/N 17264706N61658Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1975 · S/N 17264707N61659Bowerman Richard E · Wetmore, MIBuilt 1975 · S/N 17264708N61663Mohamed Eman Z · Lubbock, TXBuilt 1975 · S/N 17264712N61670Registered aircraftBuilt 1975 · S/N 17264717N61671Charlotte Flyers Inc · Fort Myers, FLBuilt 1975 · S/N 17264718N61672American Patrols Inc · Midland, TXBuilt 1975 · S/N 17264719N61676Vectors LLC · Sterling, VABuilt 1975 · S/N 17264721N61677Morcom Aviation Services Inc DBA · Everett, WABuilt 1975 · S/N 17264722N6167CSnyder Larry G · Holland, NYBuilt 1979 · S/N 21063818N61680Kaye Linda · Grove, OKBuilt 1975 · S/N 17264724N61683Migdalski Randall C · Pembroke Pines, FLBuilt 1975 · S/N 17264727N61684Odyssey Aircraft LLC · Topeka, KSBuilt 1975 · S/N 17264728N61687Advanced Rehab Specialties Pa · Leesburg, FLS/N 17264731N61689Bc 414 LLC · Los Angeles, CABuilt 1975 · S/N 17264732N6168SFerrell William W II · Flagstaff, AZBuilt 1980 · S/N R18201635N61692Pittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1975 · S/N 17264734N61696Bakker Margaret E Trustee · Petaluma, CABuilt 1975 · S/N 17264737N61697L&W Aircraft Investment LLC · Homestead, FLBuilt 1975 · S/N 17264738N61699Erickson Steve · St Michael, MNBuilt 1975 · S/N 17264740N6169RN999gk LLC · Nantucket, MAS/N 172RG0102N616AADowns Kenneth · Houston, TXBuilt 1975 · S/N 17265524N616RLDeeb David Antony · Shelton, CTBuilt 1981 · S/N 24-1159N616SFAmelia Reid Aviation LLC · San Jose, CABuilt 1980 · S/N 172RG0740N616SKSuperior Flying Services LLC · Superior, WIBuilt 1979 · S/N 17273381N616SMDoo Dah Inc · Wilmington, DEBuilt 1990 · S/N 24-1691-14N61700Torres Ramon L · Mulberry, FLS/N 17264741N61701Jls Aviation LLC DBA · Fredericksburg, VABuilt 1975 · S/N 17264742N61703Beising Steven · Las Vegas, NVBuilt 1975 · S/N 17264744N61704Glick Mervin L · Stanardsville, VABuilt 1975 · S/N 17264745N61707Spartan National Holdings LLC · Missoula, MTBuilt 1975 · S/N 17264747N61709Caldwell Clifton · Sterling City, TXBuilt 1975 · S/N 17264748N6170SNice Flight LLC · Medford, ORBuilt 1980 · S/N R18201637N61710Bob Hoover Academy Inc · Salinas, CABuilt 1975 · S/N 17264749N61713Miller Melanie L · Spanaway, WABuilt 1975 · S/N 17264750N61718Ortman Bernard R · Bozeman, MTBuilt 1975 · S/N 17264753N61727Mays Gloria J · College Station, TXBuilt 1975 · S/N 17264755N6172DBlue Spruce Aviation LLC · Fairview Park, OHBuilt 1979 · S/N 17272617N61733Pan Air Flying Club Inc · Miami, FLBuilt 1975 · S/N 17264760N61737Executive Flight Institute LLC · Murrieta, CABuilt 1975 · S/N 17264763N61738Finn Development LLC · Kaysville, UTBuilt 1975 · S/N 17264764N61739Southern Aero LLC · Homestead, FLS/N 17264765N6173SRet Gianni · Kerrville, TXS/N R18201660N61743Carruth John T · Danvers, MNBuilt 1975 · S/N 17264768
Back to AD 80-25-07 R1