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.

N5828DSchulz Lucas H · New Boston, MIBuilt 1956 · S/N 22-4503N5828QGreater Cincinnati Aero Club LLC · Alexandria, KYBuilt 1965 · S/N 3123N58294Nance James Aaron · Woodbridge, VABuilt 1979 · S/N 18-7909055N5829QHenery L Bodmer Inc · Kenmare, NDBuilt 1965 · S/N 780N5829UFarrell Mark O · Pittsburgh, PABuilt 1969 · S/N 28-26660N582BBAftab Younus · Pleasanton, CABuilt 1984 · S/N BLACKWOOD 0001N582BLSolera Aviation LLC · Bozeman, MTBuilt 2025 · S/N 2881959N582MHuffman Prairie LLC · Claymont, DEBuilt 1991 · S/N 1608N582MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2004 · S/N 40.398N582NDChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 4496261N5830CKueber Jake T · Anchorage, AKBuilt 1962 · S/N 18-7778N5830WWard Orval G · Bentonville, ARBuilt 1965 · S/N 28-2148N5830YMost Gordon G · Thedford, NEFirst renewal noticeS/N 18-8411N58319Schweizer Rsg LLC · Fort Worth, TXBuilt 1979 · S/N 390761N5831HJenrich Scott J · Lake Stevens, WABuilt 1949 · S/N 16-448N5831LCooks Aviation LLC · Conover, NCBuilt 1972 · S/N AA5-0231N5831QCueva Arturo A · Los Angeles, CABuilt 1965 · S/N 781N5831WSonafrank Eric J · Somerset, INBuilt 1965 · S/N 28-2149N5832HForcey Charles F · Westville, INBuilt 1949 · S/N 16-450N5832JAerial Advertising Services · Livermore, CAS/N 17273842N5832LPlesea Lucian · Redlands, CABuilt 1972 · S/N AA5-0232N5832PBrooks William L · Vienna, VABuilt 1959 · S/N 24-913N5832QHli Aviation LLC · Red Banks, MSBuilt 1965 · S/N 3125N5832UBecker Randall T · Santa Rosa, CABuilt 1970 · S/N 28-26663N5833DBixler Scott E · Rising Fawn, GABuilt 1956 · S/N 22-4509N5833HSchipul Melissa J · New Milford, CTBuilt 1949 · S/N 16-446N5833JAlbatross Air Inc · Beaver, WVBuilt 1980 · S/N 17273843N5833QDyer Albert L · New Smyrna Beach, FLBuilt 1965 · S/N 782N5833WJts Aircraft LLC · Rock Hill, SCBuilt 1965 · S/N 28-2159N5833ZGrossman Larry R · White Pigeon, MIBuilt 1963 · S/N 22-9664N5834HPierce Gilbert H · Germantown, TNBuilt 1949 · S/N 16-453N5834LFount Valley Flying Club LLC · Kidron, OHS/N AA5-0034N5834QGill Harold P · Bolton, MABuilt 1965 · S/N 3126N5834UNewburn William A Jr · Fresno, CABuilt 1969 · S/N 28-26665N5834WDowdy Joseph N · Blacksburg, VABuilt 1965 · S/N 28-2186N58359Warner Robert G Jr · Broomall, PABuilt 1979 · S/N 1290861N5835ZNiemela Blair K · Wasilla, AKBuilt 1963 · S/N 22-9688N58363Hartle Aaron Duane · Vicksburg, MIBuilt 1979 · S/N 690796N5836ZGaines Jesse B · Bryan, OHBuilt 1963 · S/N 22-9689N58371Bilton Aircraft Management Inc · Umatilla, FLBuilt 1979 · S/N 690794N5837LDudock John M Jr · Birch Run, MIBuilt 1972 · S/N AA5-0037N5837UDeblass Christopher C · Cranford, NJBuilt 1969 · S/N 28-26668N58384Sonnichsen Landen D · Delta Junction, AKS/N 990829N5838HPoliti Terris P · Lake Placid, NYFirst renewal noticeBuilt 1949 · S/N 16-457N5838LCox Andrew C · Scappoose, ORBuilt 1972 · S/N AA5-0038N5838MMuller Isaac Paul · Nampa, IDBuilt 2026 · S/N 5838N5838WJohn Andrew P · Auburn, MES/N 28-2207N58390Cassada Mark C · Hillsborough, NCS/N 75-870N58397Frost Darrell G · Atlanta, TXBuilt 1979 · S/N 1090833N5839HKinney Philip D · Audubon, MNBuilt 1949 · S/N 16-456
Back to AD 90-04-06 R1