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.

N757RVJohnson Scott E · Land O Lakes, FLBuilt 2025 · S/N 75031N757RZCox Derrell L · Pamplico, SCS/N 15279956N757SCHicks Byron · Manchaca, TXBuilt 1977 · S/N 15279959N757SDYu Hermon Lemuel C · Mays Landing, NJBuilt 1977 · S/N 15279960N757STChester Charter Inc · Chester, CTBuilt 1977 · S/N 15279974N757SWSt Charles Flying Service Inc · Portage Des Sioux, MOBuilt 1977 · S/N 15279977N757TMontgomerie Robert A · Oriental, NCBuilt 2006 · S/N 1854LN757TAHofmeister Laurence C · Punta Gorda, FLBuilt 1977 · S/N 15279981N757TDNew Horizon Aviation Inc · Warwick, RIBuilt 1977 · S/N 15279984N757THGoodrich Pilot Training Center LLC · Johnson City, NYBuilt 1977 · S/N 15279988N757TLSky Candy LLC · Scottsdale, AZBuilt 1977 · S/N 15279991N757TMMayeur Terri-Jo · Wasilla, AKBuilt 1950 · S/N 18-336N757TVTri County Rentals And Sales Inc · Lake City, FLBuilt 1977 · S/N 15280000N757TWHildebrand Russell W · Chandler, AZBuilt 2002 · S/N 23911N757UGehret Barry · Sonoma, CABuilt 1965 · S/N 933N757UDDau Anuar · Colfax, NCBuilt 1977 · S/N 15280007N757UFAviation Capital Management LLC · San Jose, CABuilt 1977 · S/N 15280009N757URRichmor Aviation Inc · Hudson, NYBuilt 1977 · S/N 15280018N757USPeasley Robert E · Lonsdale, MNBuilt 2019 · S/N 526-2019N757UTIfly LLC · Wichita, KSBuilt 1977 · S/N 15280020N757UZCoulliette Brian K · Jacksonville, FLBuilt 1977 · S/N 15280026N757VAStoup Lyndal K · Cordell, OKS/N 15280027N757VBGanesh Prabhandhakavi · Cerritos, CABuilt 1977 · S/N 15280028N757VWHeckert Dale L · Nikiski, AKBuilt 1977 · S/N 15280047N757XRosenberger R Scott · Baltimore, MDBuilt 2003 · S/N 70497N757XGJohnson Shawn A · Joliet, MTBuilt 1977 · S/N 15280081N757XHSteinhauser Raymond P · Ashland, OHBuilt 1977 · S/N 15280082N757XWPittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1977 · S/N 15280095N757YARule John D · Nampa, IDS/N 15280099N757YMDarcy Aviation LLC · Danbury, CTS/N 15280110N757YSJohn Mccaskill Enterprises LLC · Tifton, GABuilt 1977 · S/N 15280115N757YUTechnical Education Services Inc T/A · Virginia Beach, VABuilt 1977 · S/N 15280117N757ZKodysh Peter J · North Ridgeville, OHBuilt 2000 · S/N 863N757ZAAdventure Flight Aviation Inc · Springdale, ARBuilt 1977 · S/N 15280123N757ZNJin Jin Aviation LLC · Anchorage, AKBuilt 1977 · S/N 15280135N757ZRBishops' Ltd · Virginia Beach, VABuilt 1977 · S/N 15280138N757ZSDevereaux Mishelle · Raleigh, NCBuilt 1977 · S/N 15280139N757ZTRiya Aviation LLC · Tracy, CABuilt 1977 · S/N 15280140N75801Hartland Aviation LLC · New Smyrna Beach, FLBuilt 1976 · S/N 17267960N75803Kuntz Donald Alan · Whitefish, MTBuilt 1976 · S/N 17267962N75805Roney Howard D · Salem, ORBuilt 1976 · S/N 17267964N75806Jones Bros Amc Jeep Inc · Harrison, ARBuilt 1976 · S/N 17267965N75807Pearl River Community College · Poplarville, MSS/N 17267966N75809C & S Flyers LLC · Grand Lake, LABuilt 1976 · S/N 17267967N7580FLybbert Randal Lorin · Moses Lake, WAS/N 736-70N7580HFurjesi Steve J · Chehalis, WABuilt 1946 · S/N 12-460N7580KCrop Care By Air Inc · Lantry, SDBuilt 1950 · S/N 18-297N7580PWiseman Charles D · Orlando, FLS/N 24-2791N7580VBinzel Charles P · Bristol, WIBuilt 1976 · S/N 177RG0871N7580YMeekin Michael · Sutton, AKBuilt 1965 · S/N 18-8300
Back to AD 90-04-06 R1