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.

N5971WGoede Mark D · Wildwood, MOS/N 28-4021N5971ZFlight World Inc · San Juan, PRBuilt 1958 · S/N 18-6288N5972CPyler Stephen R · North Myrtle Beach, SCS/N 73905N5972DAufderheide Flying Service Inc · Dewitt, ARBuilt 1956 · S/N 18-5432N5972FFulhage Eric D · Yates Center, KSBuilt 1976 · S/N 28-7790148N5972HCastonguay Donn H · West Cornwall, CTBuilt 1949 · S/N 16-596N5972UToporkova Kamila E · Whitewater, CABuilt 1970 · S/N 28-26858N5973PSp Quality Leasing Inc · Wshngtn Ct Hs, OHBuilt 1959 · S/N 24-1066N5973QFarias Gerardo M · Panama City Beach, FLS/N 847N5973SPeck David T III · Whiting, NJBuilt 1966 · S/N MA-56N5973WValant Group Inc · Valrico, FLBuilt 1967 · S/N 28-3919N5973ZMorrisette Roland G III · Griffin, GABuilt 1964 · S/N 22-9847N5974HWarden Robert A Jr · Ordinary, VAS/N 16-600N5974LFifer O Lynn · Woodstock, ILBuilt 1969 · S/N AA1-0274N5974PWilliams Robert A · Akron, OHBuilt 1959 · S/N 24-1067N5974QTaylor Timothy T · Quitman, ARFirst renewal noticeBuilt 1965 · S/N 3205N5974SGulf Coast Aviation LLC · New Orleans, LABuilt 1966 · S/N MA-57N5974UW8s Enterprises LLC · Stillwater, OKBuilt 1970 · S/N 28-26861N5974ZFarris Kevin · Monroe, GAS/N 22-9848N5975HWilcox Darrol A · Nenana, AKS/N 16-601N5976BVarney Walter E · Charlotte, NCBuilt 2018 · S/N 25515N5976EFunkhouser Dennis E · Fredericksburg, VABuilt 1978 · S/N 17271978N5976LGoertz Anton Oscar · Santa Fe, NMS/N AA1-0276N5976QEscobar Timothy · San Antonio, TXBuilt 1965 · S/N 848N5976XFandler Frederick · Shady Shores, TXBuilt 1961 · S/N 119N5977DCarr James C · Wasilla, AKBuilt 1957 · S/N 18-5439N5977SRothwell Rocky J · Valdosta, GABuilt 1966 · S/N MA-50N5977UMorrow Robert H · Wyndmoor, PABuilt 1970 · S/N 28-26862N5977ZBrown Michael S · Kenai, AKBuilt 1965 · S/N 18-8234N5978DWinkelman Ronald A · Chugiak, AKBuilt 1956 · S/N 18-5441N5978LCorbin Thomas T · Titusville, FLBuilt 1969 · S/N AA1-0278N5978QBauer Jared R · Sugar City, COBuilt 1965 · S/N 3208N5979DVeal Tim S · Egegik, AKBuilt 1956 · S/N 18-5442N5979QBlount Aviation LLC · Metairie, LABuilt 1965 · S/N 849N5979SJohnson Jay W · Wichita, KSBuilt 1966 · S/N MA-60N5979UWings Of Grace Ministries Inc · Melbourne, FLS/N 28-26867N5979ZSchuster Timothy A · Carrington, NDBuilt 1965 · S/N 18-8237N597AGSkywest Leasing Inc · St George, UTBuilt 2024 · S/N 2881756N597DMBrandon Air LLC · Valley Stream, NYBuilt 1976 · S/N 17268041N597GCAg-Av8r Flying Services LLC · Brookline, NHBuilt 1959 · S/N 7GC-72N597JFDiamond Travel LLC · Olive Branch, MSBuilt 1977 · S/N 28-7890262N597JGKnoxville Flyers Inc · Knoxville, TNBuilt 1997 · S/N 2843087N597LDewitt Troy C · Lake Elmo, MNS/N 30-575N597LELeading Edge Aviation Inc · Bend, ORFirst renewal noticeBuilt 1986 · S/N 597N597NDNicholas James Esch · Cedar Rapids, IABuilt 1967 · S/N 670041N597RARedtail Aviation LLC · Brookville, PABuilt 2004 · S/N 40.444N597RVBeckley Jeff A · Windsor Heights, IAFirst renewal noticeBuilt 2007 · S/N 70936N597SMoore Charles W · Lees Summit, MOBuilt 1999 · S/N 23995N597SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881410N597SPViolet Sparkle Pearl LLC · Hanover, NHBuilt 2000 · S/N 172S8525
Back to AD 90-04-06 R1