OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,471

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.

N901EHigh Five Flying LLC · Amarillo, TXBuilt 1973 · S/N 28-7425053N901FCSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2002 · S/N 2842171N901HRKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1999 · S/N 1264-99N901JHScorpion Oil & Gas LLC · Stafford, TXS/N 20159N901MPMccole Kevin · Brookline, NHS/N 17259565N901TWolgamott Thad D · Weatherford, OKBuilt 2000 · S/N 445-2000N901TGWestland Aviation LLC · Lake Havasu City, AZBuilt 1968 · S/N 17257312N901TQAdirondack Aviation LLC · Saranac Lake, NYBuilt 1977 · S/N 28-7725178N901XZTaylor James A · Memphis, TNBuilt 1977 · S/N 18-7809044N9020DBaker Donald W · China Spring, TXFirst renewal noticeBuilt 1958 · S/N 22-6169N9021LRobert Rees · Jonesboro, ARS/N 214-70N9022JLewis Kristofor M · Sparks, NVBuilt 1966 · S/N 28-3050N9023DCarberry David H · Stockton, UTBuilt 2004 · S/N 5897N9023JCook Richard J II · Princeton, ILBuilt 1966 · S/N 28-3051N9023LLammers David T · Bonney Lake, WABuilt 1970 · S/N 246-70N90249Helicopteracademy.Com LLC · Rehoboth Beach, DES/N 0039N9025JAa&R Aviation LLC · Pine Grove, PABuilt 1966 · S/N 28-3053N9026DCuthbertson Steven M · Van Alstyne, TXBuilt 1958 · S/N 22-6163N9026JRay Adam W · Stinnett, TXBuilt 1966 · S/N 28-3054N9027FErickson Jon D · Atwater, MNBuilt 1976 · S/N 28-7715299N9027HAdriatic Holdings LLC · Cheyenne, WYS/N 17265908N9028JGarcia Pinedo Adolfo · Miami, FLBuilt 1966 · S/N 28-3055N9029LMarracino Services LLC · Deland, FLBuilt 1970 · S/N 258-70N9029YJohnson Scott W · Saline, MIBuilt 1970 · S/N 18-8905N902AZSantiago Felipe · Miami, FLBuilt 1981 · S/N 17275091N902CWhite Edwin W · Eagle River, AKBuilt 2001 · S/N 2162N902CCVan Flve Klub Inc · Holt, MNS/N 9902CCN902FAVero Technical Support Inc · Pensacola, FLBuilt 1980 · S/N 17273785N902FCSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2003 · S/N 2842174N902GRWright Allan M · Los Gatos, CABuilt 2002 · S/N 2411N902HMacvey Troy R · Milan, INBuilt 1971 · S/N 17259252N902NSRegistration Pending · Pottstown, PARegistration pendingBuilt 1981 · S/N 17275415N902PADefranco Peter Jr · Hueytown, ALBuilt 2002 · S/N 2843530N9030JSunrise Aviation Group LLC · Kalispell, MTBuilt 1966 · S/N 28-3058N9030LDavis Robert L · Seymour, TNBuilt 1970 · S/N 216-70N9031JBaumgartner Matthew J · Federal Way, WABuilt 1966 · S/N 28-3059N9031LSanderlin Doulgas C · Wasilla, AKBuilt 1970 · S/N 253-70N9032LJohnson Robert W · Buffalo, SDBuilt 1970 · S/N 259-70N9033JBernstein Matthew D · North Charleston, SCBuilt 1966 · S/N 28-3062N9034JGrammer Steve J · Redding, CABuilt 1966 · S/N 28-3063N9036DKranz Monte L · Eagle Butte, SDBuilt 1958 · S/N 22-6174N9036JBernau Bodies Fitness LLC · Mesa, AZBuilt 1966 · S/N 28-3066N9036KGriffiths Gregory S · Johnson City, NYBuilt 1977 · S/N 28-7816184N9036LWhitmer Charles W · Fairbanks, AKBuilt 1970 · S/N 264-70N9036NRobinson Helicopter Co · Torrance, CABuilt 1981 · S/N 0089N9037JMcgough Julie E · Red Oak, TXBuilt 1966 · S/N 28-3067N9038DJones Michael D · Eagle River, AKBuilt 1958 · S/N 22-6176N9038HPeterson Todd B · Cameron Park, CABuilt 1975 · S/N 17265912N9038KNorthwest Aviation LLC · Gig Harbor, WABuilt 1977 · S/N 28-7816185N9038YRodriguez Juan M · Grass Valley, CABuilt 1983 · S/N FM2
Back to AD 80-04-03 R2