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.

N8839YMcguinness William V IV · Houston, TXBuilt 1969 · S/N 39-2N883ACPlane Fun Inc Tr Trustee · Snellville, GABuilt 1975 · S/N 28R-7535156N883ATDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496320N883CFolkers Daniel E · Norwalk, IABuilt 1973 · S/N 28-7325345N883CGBrock Gary G · Roseboro, NCBuilt 2008 · S/N 90904N883JJJaffe Jordan E · Horseshoe Bay, TXBuilt 2003 · S/N 910-2003N883MMoffett James D · North East, MDBuilt 1969 · S/N 28-26047N883RVMann Allen W Trustee · Post Falls, IDBuilt 1993 · S/N 21677N883TCCoughlin Brian T · Cazenovia, NYBuilt 2023 · S/N 001N883TTRoser John E · Lake St Louis, MOBuilt 2003 · S/N 60576N88401Kimball Clayton Scott · Richland, WABuilt 1974 · S/N 122-75N88405Mulhern Georgia · Waddell, AZS/N 784-75N88408Steel Mimi · Caldwell, IDBuilt 1974 · S/N 1062-75N8840FPinchorski Ronald G · Wiconisco, PABuilt 1963 · S/N 33-0185N8840NBouillon Gloria J · Somerville, MABuilt 1969 · S/N 28-25691N88412Rider Shawna · Anchorage, AKS/N 779-75N88417Alaska Department Of Fish And Game · Fairbanks, AKS/N 123-75N8841JE & G Flying Club LLC · Alliance, OHBuilt 1965 · S/N 28-2798N8841WRegistration Pending · Dilley, TXRegistration pendingBuilt 1964 · S/N 28-10390N8841YHoffman Avery E · Bethel, AKBuilt 1973 · S/N 18-7309025N8842Calvert Jared C · Ranger, TXBuilt 1929 · S/N 1006N88421Dular Emil M · Elizabethtown, KYBuilt 1974 · S/N 785-75N88424Iowa Aerial Advertising LLC · Perry, IAS/N 305-75N88425Klamar Spraying Inc · Gatzke, MNBuilt 1974 · S/N 786-75N88428Mason Fred B · Waterford, OHBuilt 1974 · S/N 162-75N8842CTerry Jay F · Rome City, INBuilt 1953 · S/N 22-1455N8842DVan Bergeyk Ronald J · Trapper Creek, AKBuilt 1958 · S/N 22-6012N8842JCrowe Steven A · Bend, ORBuilt 1965 · S/N 28-2799N8842YQuest Aviation Inc · Houlton, MEBuilt 1969 · S/N 30-2000N88437Vst Aviation LLC · Ball Ground, GABuilt 1974 · S/N 490-75N8843JDiorio Christopher J · Melba, IDS/N 28-2801N88443Jkt LLC · Douglas, WYBuilt 1974 · S/N 130-75N88446Gall Peter D · Morgantown, WVS/N 1064-75N8844JCave Anthony B · Round Rock, TXBuilt 1965 · S/N 28-2802N8844NBruegmann Fred R III · Northfield, ILBuilt 1969 · S/N 28-25695N8844YStreater Aviation LLC · Weirsdale, FLBuilt 1969 · S/N 39-3N8845Rudloff Uwe K · Lake Village, INBuilt 1973 · S/N 365-73N88451Williams Charles S · Pearland, TXS/N 131-75N88453Tribfelner Lance J · St Charles, MIBuilt 1974 · S/N 1065-75N88458Cole John R · Greenfield, INBuilt 1975 · S/N 790-75N88459Carnevale Victor N · Fayetteville, NCBuilt 1974 · S/N 1067-75N8845FDowning Darrell W · Drakesville, IABuilt 1963 · S/N 53-0208N8845JWilliams Daniel · Wallingford, KYBuilt 1965 · S/N 28-2803N88465Castleberry Inc · Ekalaka, MTBuilt 1974 · S/N 791-75N88467Atwood Christopher M · Brownsburg, INBuilt 1974 · S/N 163-75N8846CBranigan Leslie K · Amarillo, TXS/N 22-1460N8846JFighter Pilot Enterprises LLC · Eaton, COBuilt 1965 · S/N 28-2804N8846NDegener William L · Leonard, TXBuilt 1969 · S/N 28-25697N88473A C E Aviation Inc · Ashton, IDBuilt 1974 · S/N 306-75N88476Bmg Aviation Inc · Bloomington, INBuilt 1974 · S/N 495-75
Back to AD 90-04-06 R1