OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,396

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:79-10-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:79-10-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.

N71PMAnderson Aviation LLC · Bulverde, TXBuilt 1971 · S/N 28-7125523N71REEigsti Rodney E Trustee · Friend, NEBuilt 1995 · S/N 942N71SATake Off LLC · Boise, IDBuilt 1971 · S/N 28-7125607N71SHReese Jose A · Yuma, AZBuilt 1967 · S/N 28-4048N71UPSisson Edward E · Northome, MNBuilt 1990 · S/N EW2N7200GWe Fly High LLC · Helena, MTBuilt 1969 · S/N 17258900N7200JBell Dylan Will Nash · W Columbia, TXBuilt 1968 · S/N 28-24471N7200LWorley Matthew · Cordova, TNBuilt 1974 · S/N AA5-0500N7200PThompson Grover A · Locust, NCBuilt 1960 · S/N 24-2386N7200QFisher Eric C · San Francisco, CABuilt 1972 · S/N 17260500N7200WAgri Air LLC · Fairfax, MOBuilt 1963 · S/N 28-1011N7201DEnyeart Warren L · Eagle River, AKBuilt 1957 · S/N 22-5025N7201FPowell Jonathan C · Philadelphia, PABuilt 1968 · S/N 28-25108N7201JTrebor Aviation LLC · Prescott Valley, AZBuilt 1968 · S/N 28-24531N7201WTaylor Robert · Greensboro, NCS/N 28-1012N7202GUrmston Benjamin R · Sherborn, MABuilt 1969 · S/N 17258902N7202JAir Indiana LLC · Noblesville, INBuilt 1968 · S/N 28-24533N7202KCollins Michael P · Cordova, AKS/N 18-93N72035Christiano Brett T · Pasco, WABuilt 1967 · S/N 17700240N7203FLaird Grant M · Puryear, TNBuilt 1968 · S/N 28-25111N7203GVenard Inc · Murdo, SDS/N 17258903N7203JRegistration Pending · Tifton, GARegistration pendingBuilt 1968 · S/N 28-24534N7203ZConrad Coy S · Tobaccoville, NCBuilt 1965 · S/N 18-8306N7204GGibson James E · Tenino, WABuilt 1969 · S/N 17258904N7204PPittner Hans C · Goshen, NYBuilt 1960 · S/N 24-2374N7204QTexas Air Rangers LLC · Mckinney, TXBuilt 1972 · S/N 17260504N7204WKlein Kaylin · Stillwater, OKBuilt 1963 · S/N 28-1017N7205GJones Keith · Tucson, AZBuilt 1969 · S/N 17258905N7205PL F Rothschild & Company Inc · Shingle Springs, CANon-citizen corporation, flight hours not reportedS/N 24-2375N7205QN7205q LLC · Titusville, FLBuilt 1972 · S/N 17260505N7206CDwyer Benjamin J · Colorado Springs, COBuilt 1976 · S/N 28-7625072N7206FVoyage Capital Ventures LLC · Knightdale, NCBuilt 1968 · S/N 28-25114N7206LWilliams Harry D III · Summerland Key, FLS/N 22-5030N7206QN7206q LLC · Myrtle Beach, SCBuilt 1972 · S/N 17260506N7206WSchimmel O L · Port Hueneme, CABuilt 1963 · S/N 28-1020N7207Board Of Trustees · Battle Creek, MIBuilt 1962 · S/N 18-7859N7207DHerrick David L · Mont Vernon, NHBuilt 1957 · S/N 22-5031N7207FLandmark Title Inc · Clovis, NMBuilt 1968 · S/N 28-25115N7207GCowden Flying Services Inc · Fort Worth, TXBuilt 1969 · S/N 17258907N7207JErhardt Industries LLC · Ottumwa, IABuilt 1968 · S/N 28-24540N7207QMountain Peaks Aviation LLC · Clancy, MTBuilt 1972 · S/N 17260507N7207WValkaria Flyers LLC · Palm Bay, FLBuilt 1963 · S/N 28-1021N7208DCopper River Airmotive LLC · Copper Center, AKBuilt 1957 · S/N 22-5032N7208FWignot Andrew R · Oceanside, CABuilt 1968 · S/N 28-25117N7208GBurgess Keith · Arnoldsville, GABuilt 1969 · S/N 17258908N7208JWelby Samantha · Eastampton, NJBuilt 1968 · S/N 28-24541N7208WSky View Aviation LLC · Porter, OKS/N 28-1117N7209DBlue Weayne E · Rochester, NYBuilt 1957 · S/N 22-5033N7209FNew Garden Township · Landenberg, PABuilt 1968 · S/N 28-25118N7209GElite Planes LLC · Menifee, CABuilt 1969 · S/N 17258909
Back to AD 79-10-03 R2