AD 90-04-06 R1

Registered aircraft · 68,377

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:90-04-06-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:90-04-06-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.

N71JAIcenogle Roger A · Inver Grove, MNBuilt 2004 · S/N 2284N71KHZoar Cubs LLC · Springville, NYBuilt 2017 · S/N CC19-0023N71KJAanstad William L · Ofallon, ILBuilt 2006 · S/N 471BN71KSLazenby Gary M · Harpster, IDBuilt 2013 · S/N 20621N71KTL L C LLC · Rapid City, SDBuilt 1965 · S/N 28-21258N71LZGriffin Ralph J Jr · Thibodaux, LABuilt 1977 · S/N 28-7816275N71NSSpeedy Nigel A · Cinnaminson, NJBuilt 2015 · S/N 001N71PKBob Hoover Academy · Salinas, CABuilt 1974 · S/N 17263272N71PMAnderson Aviation LLC · Bulverde, TXBuilt 1971 · S/N 28-7125523N71PVCeleste LLC · Playa Del Rey, CABuilt 1966 · S/N 30-1261N71QRutter David C · Downers Grove, ILBuilt 1946 · S/N 1441N71REEigsti Rodney E Trustee · Friend, NEBuilt 1995 · S/N 942N71RKOtt Randal K · League City, TXS/N 0001N71SATake Off LLC · Boise, IDBuilt 1971 · S/N 28-7125607N71SDRalph B Beatty LLC · Murrysville, PABuilt 1980 · S/N 625-80N71SGRocket Sauce Engineering LLC · Columbia, MOBuilt 1994 · S/N 556N71SHReese Jose A · Yuma, AZBuilt 1967 · S/N 28-4048N71SLSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1990 · S/N S1468N71TKKallio Thomas A · Carmel, INBuilt 2017 · S/N 90908N71UPSisson Edward E · Northome, MNBuilt 1990 · S/N EW2N71WLWild Bill'S Aviation Inc · Tustin, CABuilt 1999 · S/N 2031N71WSMello Matthew D · Exeter, CAS/N 26N71WYCape Island Aviation LLC · Millville, NJS/N 3141N71YYAgl Flight LLC · Callahan, FLBuilt 1971 · S/N AA1A-0118N71ZZPlum South Aircraft LLC · Abbeville, SCBuilt 1980 · S/N 11644N7200GWe 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-1011N7200YBroussard Don W Jr · Wynne, ARBuilt 1963 · S/N 30-224N7201DEnyeart Warren L · Eagle River, AKBuilt 1957 · S/N 22-5025N7201FPowell Jonathan C · Philadelphia, PABuilt 1968 · S/N 28-25108N7201HMcclure Richard A · Edna, TXBuilt 1978 · S/N 24-0597N7201JTrebor Aviation LLC · Prescott Valley, AZBuilt 1968 · S/N 28-24531N7201POrillac Natalie · Doral, FLBuilt 1978 · S/N 24-0599N7201VCompass Rose Aviation LLC · Fort Myers, FLS/N 24-0600N7201WTaylor Robert · Greensboro, NCS/N 28-1012N7201XMathews Daniel R · Vallejo, CABuilt 1978 · S/N 24-0601N7202GUrmston 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-2374
Back to AD 90-04-06 R1