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.

N737YFVero Technical Support Inc · Pensacola, FLBuilt 1977 · S/N 17269772N737YGAgassiz Flyers Inc · Herman, MNBuilt 1977 · S/N 17269773N737YPYankee Papa LLC · Wilmington, DEBuilt 1977 · S/N 17269780N737YQTec Aviation Inc · Pasco, WABuilt 1977 · S/N 17269781N737YSCk Max LLC · Stanford, KYBuilt 1977 · S/N 17269783N737YT80075 Aircraft Corporation LLC · Wilmington, DEBuilt 1973 · S/N 17261481N737YULake Elmo Aero LLC · Lake Elmo, MNBuilt 1977 · S/N 17269785N737YVLees Sea Air · Kiana, AKBuilt 1977 · S/N 17269786N737YZWininger Spencer C · Wichita, KSBuilt 1977 · S/N 17269790N737ZACounty Of Santa Cruz · Santa Cruz, CABuilt 1977 · S/N 17269791N737ZCMoody Air Ventures LLC · Nolanville, TXBuilt 1977 · S/N 17269793N737ZDHp Air Inc · Cape Coral, FLBuilt 1977 · S/N 17269794N737ZGDuck Air LLC · Mooresville, NCBuilt 1977 · S/N 17269797N737ZJLazy Eights Holdings LLC · Greenwood, INBuilt 1977 · S/N 17269799N737ZKAk Fly Inc · Kasilof, AKBuilt 1977 · S/N 17269800N737ZNEquinoxx Flight Systems LLC · Lawrenceville, GABuilt 1977 · S/N 17269803N737ZPJahawk Leasing LLC · Sugar Grove, ILBuilt 1977 · S/N 17269804N737ZRTennessee Seaplane Company LLC · Knoxville, TNBuilt 1977 · S/N 17269806N737ZTEdwards Ronald R · Clinton, ARBuilt 1977 · S/N 17269808N737ZVJax Aero LLC · Jacksonville, FLBuilt 1977 · S/N 17269810N737ZWS & S Aviation Co · Ball Ground, GAS/N 17269811N73800Soul Aviation LLC · Newport Beach, CABuilt 1976 · S/N 17267690N73808Delta Aviation Inc · Monticello, MNBuilt 1976 · S/N 17267691N7380DKirby Robert H · Hallsville, TXBuilt 1957 · S/N 18-5745N7380GOrlandi Properties LLC · Blairstown, NJBuilt 1970 · S/N 17259080N7380JBednarek Michael H · Centerville, OHBuilt 1968 · S/N 28-24742N7380LAsiatico Ruperto M · Virginia Beach, VABuilt 1978 · S/N A1520799N7380WRohlfes David M · Newcastle, CABuilt 1963 · S/N 28-1263N73813Smoot Russell L · Louisville, KYBuilt 1976 · S/N 17267693N73816Nedved Aviation LLC · Mitchell, SDBuilt 1976 · S/N 17267696N73819Botter Marlene S Trustee · Kent, WABuilt 1976 · S/N 17267699N7381SSeitz Anthony Wayne · Heppner, ORBuilt 2012 · S/N 2090N7381WTogliatti Robert A · Lakewood, OHBuilt 1963 · S/N 28-1265N7382DSchneider Aerial Inc · Rugby, NDBuilt 1957 · S/N 18-5747N7382JMinor Air LLC · Joplin, MOS/N 28-24744N7382PAir Jav Aviation · Paso Robles, CAS/N 24-2592N73830Asbury Paul G · Charleston, TNBuilt 1976 · S/N 17267706N73837Bloomex Aviation LLC · Montvale, NJS/N 17267711N7383JCox Jakori Akeem · Las Vegas, NVBuilt 1968 · S/N 28-24745N7383WRed Rock Flying School LLC · Mesa, AZBuilt 1963 · S/N 28-1267N73846Bernstein Matthew D · North Charleston, SCBuilt 1976 · S/N 17267717N73848Dorson Daniel J · Eden Prairie, MNBuilt 1976 · S/N 17267719N7384DSteinbrecher Kevin · North Pole, AKS/N 18-5749N7384EFierman Jo Angela · Madison, GABuilt 1978 · S/N 17272100N7384KSid R Jensen · Idaho Falls, IDS/N 20-293N7384WRader Kyle L · Hutto, TXBuilt 1963 · S/N 28-1268N7384YMccafferty Robert S · Duluth, GABuilt 1964 · S/N 30-438N73852Carrion Jesus · Staten Island, NYBuilt 1976 · S/N 17267721N73855Dury Aviation Services Inc · Portage Des Sioux, MOBuilt 1976 · S/N 17267723N7385JGardner Chuck R · Estherville, IABuilt 1968 · S/N 28-24747
Back to AD 90-04-06 R1