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.

N7405XWills Terry W · Cedar Park, TXBuilt 1961 · S/N 17247905N7406PAviation Collective LLC · Fort Worth, TXBuilt 1961 · S/N 24-2593N7406VEvans Steven M · Somis, CAS/N 22-1199N7406YTucker Engineering Associates Inc · Locust, NCS/N 30-465N74079Marques David A · Gilbert, AZBuilt 1975 · S/N AA5B-0120N7407FFp Aircraft Holdings LLC · Alvord, TXBuilt 1999 · S/N 416-98N7407WTevik Michael A · Provo, UTBuilt 1963 · S/N 28-1294N74080Lowry John O · Willis, TXBuilt 1975 · S/N AA5B-0121N74086Meyer Michael · San Diego, CAFirst renewal noticeBuilt 1976 · S/N AA5B0394N74088Mcgee Neil R · Littleton, NCBuilt 1975 · S/N AA5B-0125N7408DTobin John C · Olympia, WAS/N 22-5169N7408JHiller Alex T · Lake Orion, MIBuilt 1968 · S/N 28-24773N7408KCapps Steven · Newcastle, OKBuilt 1950 · S/N 20-317N7408RAdventures Aviation LLC · Whitehouse Station, NJBuilt 1966 · S/N 28-21925N7408VM Twenty Inc · Bismarck, NDBuilt 1975 · S/N 22-1201N74090Tiger Air LLC · Chatsworth, CABuilt 1975 · S/N AA5B-0126N74092Mcgill John G · Atlanta, GABuilt 1975 · S/N AA5B-0127N74094Eastern Shore Flying Service Inc · Wilmington, DEBuilt 1976 · S/N AA5B0395N74095Benson Edwin R · Gulfport, FLBuilt 1975 · S/N AA5B-0133N74096Borden Lester N · Dalzell, ILBuilt 1975 · S/N AA5B-0134N74099Sigg David · Bluffton, SCBuilt 1975 · S/N AA5B-0135N7409DBartlett Donald R · Weirsdale, FLBuilt 1957 · S/N 22-5170N7409GAero Quest LLC D/B/A · Olive Branch, MSBuilt 1970 · S/N 17259109N7409JAdp Consultants Inc · Laurel, MDBuilt 1968 · S/N 28-24774N7409PPeters Gordon J · Salem, ORBuilt 1961 · S/N 24-2596N740HSSnook Harold F · Beaver Springs, PABuilt 1977 · S/N 18-7709067N740NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2016 · S/N 2843857N740PASkywest Leasing Inc · St George, UTBuilt 2016 · S/N 2843834N740UOhio University · Albany, OHBuilt 2005 · S/N 2842225N740WTCentral Valley Flight School LLC · Hanford, CABuilt 1969 · S/N 28R-31029N74100Derby Kent E · Denver, COBuilt 1975 · S/N AA5B-0136N74101Mickelsen Brian C · South Jordan, UTBuilt 1975 · S/N AA5B-0137N74104Supan J T Trustee · Santa Cruz, CABuilt 1975 · S/N AA5B-0139N74105Lamphier Marc S · Lawrence, MABuilt 1975 · S/N AA5B-0140N74109Piscitello Thomas J · Yulee, FLBuilt 1975 · S/N AA5B-0145N7410DHampton Michael D · Marshfield, MOFirst renewal noticeBuilt 1957 · S/N 22-5171N7410JGeorge Ladelle · Ashley, NDBuilt 1968 · S/N 28-24775N7410RElon Aviation LLC · Burlington, NCBuilt 1966 · S/N 28-21927N7410WKlassen Peter K · Seminole, TXBuilt 1965 · S/N 28-2897N7410YDuncan Paul J · Bartlett, TNBuilt 1964 · S/N 30-472N7411BWilcox Stacy S · Parker, COBuilt 1956 · S/N 7EC-443N7411DMclain Joseph L · Louisville, KYBuilt 1957 · S/N 22-5172N7411VDk Aero LLC · Wilmington, DEBuilt 1975 · S/N 22-1204N74127Richards Michael W · Lafayette, INBuilt 1975 · S/N AA5B-0147N7412JDubois Aviation Inc · Chino, CABuilt 1968 · S/N 28-24778N7412KBailis David P · Bethlehem, PABuilt 1950 · S/N 20-322N7412RZembinski Robert A · Brookfield, WIBuilt 1966 · S/N 28-21929N7412WRegistered aircraftRegistration pendingBuilt 1963 · S/N 28-1300N7413DDraper Scott · Rutland, VTBuilt 1957 · S/N 22-5174N7413JLittle Evin M · Bidwell, OHBuilt 1968 · S/N 28-24779
Back to AD 90-04-06 R1