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.

N4019ZPercy Nolan C · Saint Francisville, LAS/N 18-7971N401ADAlexander Brad K · Melissa, TXS/N 154-74N401BJJohnson William L · Union City, INS/N 1N401CDMccartney Terry A · Spirit Lake, IDBuilt 2006 · S/N 1N401DKBuford Copter Co LLC · Colorado City, TXBuilt 1988 · S/N 0929N401DSDelaware State University · Dover, DEBuilt 1972 · S/N 34-7250156N401DTKairos Holdings LLC · Huntsville, ALBuilt 1981 · S/N 17275165N401FLRinaldi Isaac Paul · Richardson, TXBuilt 1971 · S/N 28-7125175N401GLUlrich Lee · Rio Linda, CABuilt 2014 · S/N 73218N401HWPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020283N401HXThree Forks Flying Club Inc · Three Forks, MTFirst renewal noticeBuilt 1974 · S/N 17263490N401KCWellman Russell L · Danville, VAS/N 1001N401LALee Hunter · Colorado Springs, COBuilt 1965 · S/N 2949N401LDBrady Kevin J Trustee · Afton, OKBuilt 1977 · S/N AA5B0511N401LSEl Paso Aero Inc · El Paso, TXBuilt 1982 · S/N 17275784N401PASkywest Leasing Inc · St George, UTBuilt 2001 · S/N 2843444N401PKJones Roderick H DBA · Thomasville, GABuilt 1998 · S/N 1438N401RSawyers Ron S · Hayden, IDBuilt 1991 · S/N 1647N401RHTofte Shawn A · Lewis Center, OHBuilt 1999 · S/N 1986N401TCPrecision Ag Air LLC · Pendleton, INS/N 20279N401VFSchoenberger Neil J · Saint Petersburg, FLBuilt 2013 · S/N 91486N401ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881647N4020DInnovative Design Group Inc · Watkinsville, GABuilt 1999 · S/N 21063CN4020XCox Nathaniel E · Ocala, FLBuilt 1970 · S/N 5149N4020ZFinch Ernest B · Anchorage, AKBuilt 1963 · S/N 18-7972N4021Nighthawk N8231g LLC · Pompano Beach, FLBuilt 1979 · S/N 17272149N4021BElrod Brent W · Cashion, OKBuilt 1975 · S/N 1N4021HToth Richard C · Tinley Park, ILBuilt 1947 · S/N 12-3448N4022MBeautte James Edward · Fairland, OKBuilt 1947 · S/N 12-2899N4022ZKahn Steven H · Port Alsworth, AKBuilt 1963 · S/N 18-7974N40230Harris Dan C · Rockford, TNS/N 1470N40234Mallow David N · Rio, WVS/N 18-7509115N40238Blue Ridge Community College · Weyers Cave, VAS/N 1474N4023FFreese Barry L · Leonardtown, MDBuilt 1976 · S/N 28-7715003N4023LCenteno Ramon A · Oak Creek, WIBuilt 1973 · S/N AA1B-0267N4023MObrien William D · Duluth, MNBuilt 1947 · S/N 12-2905N4023XRhodes Stephen · Marion, NCBuilt 1969 · S/N 5123N4023ZLunenschloss Michael L · Anchor Point, AKBuilt 1963 · S/N 18-7975N40246Harper Matthew C · Anchorage, AKBuilt 1975 · S/N 18-7509118N4024JKeleti Laurie · Lakewood, NJBuilt 1975 · S/N 28-7525271N4024MSale Reported · Monroeville, ALSale reportedS/N 12-2909N4024XFaussett Thomas J · Greenville, MIS/N 5124N4024ZBrown Timathy S · Wasilla, AKBuilt 1963 · S/N 18-7977N4026HParker Gerald L · Stevensville, MDBuilt 1947 · S/N 12-3454N4026NSeiger T W DBA · Medford, ORBuilt 1968 · S/N 680021N4026XAlderin Charles A · Center, NDBuilt 1969 · S/N 5126N4027HEhrenfelt Linda Mae · Pierre, SDBuilt 1947 · S/N 12-3455N4027MBoyle Fred W · Cape May, NJBuilt 1947 · S/N 12-2911N4027NC2c LLC · Chesterfield, MOBuilt 1968 · S/N 680161N4027PAg Air Squadron One LLC · Saint Joseph, ILBuilt 1958 · S/N 23-1502
Back to AD 90-04-06 R1