OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,364

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.

N1068FDubois Marcus S · Olive Branch, MSBuilt 1979 · S/N 17272943N1068MWolfenden Allen K · Rocklin, CABuilt 1971 · S/N 17259988N1068RG & H Aviation · Louisville, KYBuilt 1992 · S/N 24-3246N1068XChapel Hill Flying Club Ind DBA · Sanford, NCBuilt 1993 · S/N 24-3302N1069GWilliams Jack · Lake Havasu City, AZBuilt 1989 · S/N 24-3135N106ACUpside Down Vt LLC · Milton, VTS/N 648-91N106EBBryan Gordon · Gilbert, AZBuilt 1997 · S/N 384-97N106ESOliverson Lee Ann N · Sandy, UTS/N 17272099N106GCJones Michael D · Warner Robins, GABuilt 1975 · S/N 17264663N106GTGendron Paul F · Vero Beach, FLS/N 17270199N106RMAdvanced Aviation Solutions LLC · Jasper, INBuilt 1983 · S/N R18201932N106UCInsuraclaim LLC · Boca Raton, FLBuilt 1981 · S/N 15285419N10719Florida Independent Truck Repair Inc · Greeneville, TNBuilt 1990 · S/N 24-3141N1071UCrowder Zachary · Merritt Island, FLBuilt 1989 · S/N 24-3140N1071YBreaux John Jr · Minden, NVS/N 24-1124N10725N22154 Inc · Wilmington, DES/N 24-3143N1072ESabbatino Robert F · New Milford, CTBuilt 1977 · S/N 976-77N1072NStephens Donald G · Huntington Beach, CABuilt 1981 · S/N 24-1125N1072YRyan Aaron · Wichita Falls, TXBuilt 1995 · S/N 24-3369N1072ZCorbett Henry E · Salem, ORBuilt 1981 · S/N 24-1126N1073EMurphys Flying Service LLC · Thomasville, GABuilt 1977 · S/N 1209-77N1073FFlydreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1979 · S/N 17272946N1073UHasan Shah Pc · Fishers, INBuilt 1990 · S/N 24-3146N1074LPurpose Flight Inc · Wilmington, DES/N 97777N1074MBranca Richard A · Sebastian, FLBuilt 1990 · S/N 24-3147N1074SReyes Mario A · Corpus Christi, TXBuilt 1981 · S/N 24-1127N1074TIowa Lakes Community College · Estherville, IABuilt 1973 · S/N 17262233N1074YRegistered aircraftBuilt 1990 · S/N 24-3149N1075CHoward Chase A · Moore, SCBuilt 1989 · S/N 24-3126N1075EWeiland Adam W · Evergreen, COBuilt 1977 · S/N 1214-77N1075MDewitt Scott C · Corpus Christi, TXBuilt 1973 · S/N 177RG0295N10764Tennessee Technical Writers LLC · Knoxville, TNBuilt 1990 · S/N 24-3155N1076NSmith Walton F · Ranchester, WYBuilt 1990 · S/N 24-3154N1077EGoebel William R · Rhome, TXBuilt 1977 · S/N 609-77N1077GBonilla Caleb N · Cream Ridge, NJBuilt 1990 · S/N 24-1692-14N1077LKeffer Chadwick · Edwardsville, ILBuilt 1990 · S/N 24-3158N1077UTenney Romaine · Knoxville, TNBuilt 1990 · S/N 24-1693-14N1077VIntegrity Aero LLC · Boerne, TXBuilt 1990 · S/N 24-3160N1078MGeorge Gary D · Humble, TXBuilt 1971 · S/N 17259801N1079KSmith Plane LLC · Las Vegas, NVBuilt 1990 · S/N 24-3159N1079MGeneral Aviation LLC · Henderson, NVBuilt 1971 · S/N 17259802N1079PSmith Randy · Dallas, TXBuilt 1990 · S/N 24-3163N1079SAcorn Flying Club Of Roanoke LLC · Roanoke, VABuilt 1990 · S/N 24-3169N1079VBecker Ronald G · Cresson, TXS/N 24-3165N107ACBad Attitude LLC · Lisbon, OHBuilt 1991 · S/N 650-91N107AWDust Donald E · London, OHBuilt 1978 · S/N 474-79N107BAFairmont State University · Fairmont, WVS/N 17269320N107CGColon Orlando · San Juan, PRBuilt 1982 · S/N 17275826N107ESWalpole John W · Iola, TXBuilt 1976 · S/N 17266853N107MSJprg Aviation Inc · Orlando, FLBuilt 1978 · S/N 17270569
Back to AD 80-25-07 R1