OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,473

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-04-03-R2')
    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-04-03-R2')
  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.

N7250DTrump Roger L · Greenville, OHBuilt 1957 · S/N 22-5076N7250JBrandenburg Carl A Jr · Goodyear, AZBuilt 1968 · S/N 28-24592N7250QSale Reported · Crystal, MNSale reported, pending cancellationBuilt 1972 · S/N 17260550N7250WHuber Peter Michael · Pulaski, VABuilt 1963 · S/N 28-1078N7251FWright Charles W · Selbyville, DEBuilt 1968 · S/N 28-25168N7251JChapman Michael S · Cardington, OHBuilt 1968 · S/N 28-24593N7251QGarcia Crystal M · Brownsville, ORBuilt 1972 · S/N 17260551N7252GLeaders Flying Service LLC · Clear Lake, MNBuilt 1970 · S/N 17258952N7252JMedina Jose · Spring, TXBuilt 1968 · S/N 28-24594N7252QRobbins Aviation LLC · Scottsbluff, NEBuilt 1972 · S/N 17260552N7253GOne Mile LLC · Canton, GABuilt 1970 · S/N 17258953N7253JLeffler William J · Tucson, AZBuilt 1968 · S/N 28-24595N7253QHarry'S Hawks · Wells, MNBuilt 1972 · S/N 17260553N7253WGross Matthew A · Ridgecrest, CABuilt 1963 · S/N 28-1081N7254FWolf Kim A · East Wenatchee, WAS/N 28-25172N7254JMinkel Chad A · Chanhassen, MNBuilt 1968 · S/N 28-24597N7254QRegistration Pending · Phoenix, AZRegistration pendingBuilt 1972 · S/N 17260554N7254WMonroe County Flyers And Sales LLC · Sweetwater, TNS/N 28-1083N72553Whittom Ron W Jr · Wasilla, AKS/N 23-1031N7255FN7255f LLC · Cedar City, UTBuilt 1968 · S/N 28-25173N7255JRury Bryan · Midlothian, TXBuilt 1968 · S/N 28-24598N7255PKubik Rodrick D · Waukee, IAFirst renewal noticeS/N 24-2431N7255QSierra Sky Aviation LLC · Kalispell, MTS/N 17260555N7256FZihala William · North Little Rock, ARBuilt 1968 · S/N 28-25174N7257DArctic Aero LLC · North Pole, AKBuilt 1957 · S/N 22-5084N7257FHedberg Jacob R · Jordan, MNS/N 28-25175N7257JHardin John M · Terrell, TXBuilt 1968 · S/N 28-24601N7257QSmith Henry C III · Essexville, MIBuilt 1972 · S/N 17260557N7257YRice Clark D · Anaconda, MTFirst renewal noticeBuilt 1964 · S/N 30-290N7258International Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N 172RG-0508N7258CRegistered aircraftBuilt 1975 · S/N 28-7690063N7258DVandemerwe Rilyn Grant · Durango, COBuilt 1957 · S/N 22-5085N7258FCochran Brent D · Sandy Valley, NVBuilt 1968 · S/N 28-25177N7259CN7259c LLC · Indianapolis, INBuilt 1975 · S/N 28-7690064N7259FLearn 2 Fly Ct LLC · Simsbury, CTBuilt 1976 · S/N 28-7715205N7259QForbes Gregory Allan · Lowell, MIBuilt 1972 · S/N 17260559N725ACFiorini Jay · Turlock, CABuilt 1999 · S/N 1254-98N725BBScenic Concepts LLC · La Crosse, WIBuilt 1976 · S/N 17267802N725BKAmerican Patrols Inc · Midland, TXBuilt 1971 · S/N 17259821N725DBMang Joseph K · West Des Moines, IABuilt 1976 · S/N AA5A-0126N725ECDraco Flight School Inc · Chino, CABuilt 1972 · S/N 17260842N725GALendor David A · Jersey City, NJBuilt 1978 · S/N GA7-0024N725HEOtt Edward C · Walnut Creek, CABuilt 2000 · S/N 441-2000N725RJWilliams Sol F · Jacksonville, FLBuilt 1971 · S/N 17260254N725ZNLaramie Flying Club Inc · Laramie, WYBuilt 1979 · S/N 17272734N726Veerhusen Daniel F · Homer, AKS/N 18-8309021N7260FRandy'S Rodz LLC · Missoula, MTBuilt 1968 · S/N 28-25178N7260WO'Day John E · Rindge, NHBuilt 1963 · S/N 28-1092N7261GKindblade Aeronautics LLC · Casper, WYBuilt 1970 · S/N 17258961N7261PHolleman William James · Simpsonville, SCBuilt 1961 · S/N 24-2437
Back to AD 80-04-03 R2