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.

N896DFVenture North Aviation LLC · Cloquet, MNBuilt 2024 · S/N 2881696N896DLLane David A · Yuba City, CABuilt 2006 · S/N 80896N896SCHansen Ernest F · Sequim, WABuilt 2020 · S/N 001N89702Carter Flygare Inc · Sacramento, CABuilt 1978 · S/N 15282830N8970JAll Tech Machine & Tool Inc · Greenwood, ARBuilt 1965 · S/N 28-2993N8970VWinding Creek Aviation LLC · Snellville, GABuilt 1974 · S/N 17264326N89718Schad Paul E · Gainesville, TXBuilt 1978 · S/N 15282839N8971DThomas James W · Jay, FLBuilt 1958 · S/N 18-6408N8971JSwearingen Louis S · Summerfield, FLBuilt 1965 · S/N 28-2994N8971MDixon Gary Lynn II · Ooltewah, TNBuilt 1973 · S/N 177RG0371N8971VGibson Aviation Services LLC · Hudson, WIBuilt 1974 · S/N 17264327N8971YLaubscher John E · Cazenovia, NYBuilt 1972 · S/N 39-134N89721Propability One LLC · Daytona Beach, FLBuilt 1983 · S/N 17276010N8972CBosn Richard O · Scottsbluff, NEBuilt 1976 · S/N 28-7690174N8972DClarke Timothy B · Howard, SDBuilt 1958 · S/N 18-6411N8972JPascua Jonathan J · Coventry, RIBuilt 1966 · S/N 28-2995N8972VPearce Michael J · Phoenix, AZBuilt 1974 · S/N 17264328N89735N89735 LLC · Stuart, FLBuilt 1978 · S/N 15282847N8973CUrbach Jourdan B · Sherman Oaks, CABuilt 1953 · S/N 22-1557N8973DSnider Scott E DBA · Turner, MTBuilt 1958 · S/N 18-6412N8973FAvelan Enterprises Inc · Elm Grove, LABuilt 1973 · S/N 430195N8973JMuleshoe Flight Club LLC · Muleshoe, TXBuilt 1965 · S/N 28-2996N8973VOcean Flyers LLC · Chatham, NJBuilt 1974 · S/N 17264329N8973YAire Ryder LLC · Roseville, MNS/N 39-139N89743Heavy Metal Air LLC · Farmingdale, NYBuilt 1978 · S/N 15282850N89753Aerohead Planes LLC · Savannah, GAS/N 15282853N8975VMauser James E · Zionsville, PABuilt 1974 · S/N 17264331N8976Bouchard Paul Marcel · Yellville, ARBuilt 1998 · S/N 3318N89764South Aero LLC · Albuquerque, NMS/N 15282857N8976CPetruso Rosemary D Co-Trustee · Saint Louis, MOBuilt 1953 · S/N 22-1554N8976DWilliams Aircraft LLC · Anchorage, AKBuilt 1956 · S/N 18-4887N8976JGreat Plains Aviation LLC · Lincoln, NEBuilt 1966 · S/N 28-2999N8976RSteenrod Kenneth Allen · Parsons, KSBuilt 1979 · S/N GGV 001N8976YAfricano Aircraft Management LLC DBA · Chicago, ILS/N 39-142N89770Seals Richard W · Torrance, CAS/N 15282860N8977DWilliams Aircraft LLC · Anchorage, AKBuilt 1956 · S/N 18-5083N8977JJohnson Bradley F · West Babylon, NYBuilt 1966 · S/N 28-3000N8977LSarigul Klijn Nesnn · Dixon, CABuilt 1974 · S/N AA1B-0427N8977RCozine Mark R · Cherokee, IABuilt 1960 · S/N 7KC-1N89780Huffman Jacob M III · Burleson, TXBuilt 1978 · S/N 15282865N8978CMenke Clint A · Cozad, NEBuilt 1953 · S/N 22-1558N8978DShuman Cecil R Trustee · Chugiak, AKBuilt 1958 · S/N 18-6418N8979DBurnett Kris W · Anchorage, AKBuilt 1975 · S/N 18-7509053N8979MBean George W Jr · Fort Worth, TXBuilt 1964 · S/N TD-564N8979RSeeley Lenard D · Osage, WYBuilt 1960 · S/N 13N8979VAvel Aircraft Inc · West Chicago, ILBuilt 1974 · S/N 17264335N897ALJansky Sand & Gravel Inc · Hallettsville, TXBuilt 1973 · S/N 28R-7335331N897DCRed Baron LLC · Middletown, DES/N 20012CN897DSHolliday Richard A · Fort Worth, TXBuilt 1996 · S/N 1928N897ECMatacia Thomas Eugene · Evergreen, NCBuilt 1969 · S/N 28R-35376
Back to AD 90-04-06 R1