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.

N7052State Of Alaska · Anchorage, AKBuilt 1968 · S/N 18-8729N7052DMundell Lola Trustee · Rosston, OKBuilt 1967 · S/N 67-16739N7052FStephens Racquel C · Laguna Niguel, CABuilt 1976 · S/N 28-7790179N7052GG&H Aviation · Louisville, KYBuilt 1969 · S/N 17258752N7052QHoloman T Michael · New Smyrna Beach, FLBuilt 1972 · S/N 17260352N7052RSell Carl N · Spanaway, WABuilt 1966 · S/N 28-21750N7052WPuskala Thomas S · Iron River, MIBuilt 1962 · S/N 28-817N7053Jsrs Holdings LLC · Las Cruces, NMBuilt 1968 · S/N 18-8730N7053BStevens Alan · Meridian, IDBuilt 1956 · S/N 22-4307N7053GSpare Change Enterprises LLC · Atlantic, IABuilt 1969 · S/N 17258753N7053KMatlad Inc · Wilmington, DEBuilt 1950 · S/N 20-160N7053LVelvick Kathleen R · Peoria, AZBuilt 1989 · S/N WJ-1N7053QCabrie Aviation Inc · Charlotte, NCBuilt 1972 · S/N 17260353N7053WRed Rock Flying School LLC · Mesa, AZBuilt 1962 · S/N 28-805N7054State Of Alaska · Anchorage, AKBuilt 1971 · S/N 18-8915N70541Cl Finney Aviation LLC · Benton, KSBuilt 1969 · S/N 17258757N70549Andersen Mark · Huntley, ILBuilt 1993 · S/N 10152N7054BWinter Jerry L · Cumming, GAS/N 22-4310N7054GSands Aviation LLC · Talking Rock, GAS/N 67-16871N7054KPehoski Joseph R · Anchorage, AKBuilt 1950 · S/N 20-161N7054WLanguage Gert Johannes · Hays, KSS/N 28-820N7054YNordman Clay L · Catheys Valley, CABuilt 1963 · S/N 30-65N7055State Of Alaska · Anchorage, AKBuilt 1971 · S/N 18-8916N70555Hecht Waldo E · Vassar, MIBuilt 1946 · S/N 17564N7055QSeagraves Brad J · Rockwell, NCBuilt 1972 · S/N 17260355N7055RRegistered aircraftBuilt 1966 · S/N 28-21754N7055WRickard Donald L · Rowland Hts, CABuilt 1962 · S/N 28-823N7056State Of Alaska · Anchorage, AKBuilt 1971 · S/N 18-8917N70562Jets To Helis LLC DBA · Chandler, AZBuilt 2001 · S/N 3281N7056QFleeman Joseph R · Lawrenceburg, TNBuilt 1972 · S/N 17260356N7056WEustace Daryl R · Scottsboro, ALBuilt 1962 · S/N 28-824N7057LTri County Rentals And Sales Inc · Chiefland, FLBuilt 1967 · S/N 1281052N7057QMindy Limited LLC · Muscatine, IAS/N 17260357N7057RContreras Robert G · Norman, OKBuilt 1966 · S/N 28-21756N7057WWatkins Travis · Haughton, LABuilt 1962 · S/N 28-829N7058GDc Aerial Photos Inc · Fredericksburg, VABuilt 1969 · S/N 17258758N7058JStaggs Jerry A · Weatherford, TXS/N 67-16969N7058KGiarusso Richard John · Carlisle, IABuilt 1950 · S/N 20-165N7058RMoss Harold E II · Overland, MOBuilt 1966 · S/N 28-21757N7058WRoman Donald M Jr · New Middletown, OHBuilt 1962 · S/N 28-810N7059State Of Alaska Department Of Public Safety · Anchorage, AKBuilt 1963 · S/N 18-8043N70597Rodriguez Hulises · Chula Vista, CABuilt 1976 · S/N 17267223N7059DSmith Andrew W · Willow, AKBuilt 1957 · S/N 22-4956N7059GFrank Todd E · Corsicana, TXBuilt 1969 · S/N 17258759N7059HFly In Helicopters LLC · Florence, SCS/N 3695N7059PProx Jonathan P · Enterprise, ALBuilt 1960 · S/N 24-2209N7059SParker Helicopter LLC · Watsonville, CABuilt 1999 · S/N 2904N7059WMartin Gerard A · Boston, KYBuilt 1962 · S/N 28-811N7059YPhill-Air Inc · Dover, DEBuilt 1963 · S/N 30-70N705ABHart Aviation LLC · Emory, TXBuilt 2000 · S/N 2099
Back to AD 90-04-06 R1