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.

N4909GRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1979 · S/N 17273456N4909SRice Philip V · Sublette, KSBuilt 1970 · S/N 28R-35681N4909ZVersatile Aviation LLC · Waterford, MIBuilt 1961 · S/N 22-8494N490AFEiffert Matthew T · Ukiah, CABuilt 1970 · S/N 17701493N490BYancey Patrick D · Spirit Lake, IDS/N 1994N490GRWarnock Tony J · Mobile, ALS/N 97N490RRegistered aircraftBuilt 1999 · S/N 490RN490RVSmith William R · Seneca, PABuilt 2008 · S/N 20090N490SPSky Training LLC · West Milford, NJBuilt 1998 · S/N 172S8031N49105Carlyle Properties LLC · Columbia Falls, MTS/N 203N4910BCooper Ronald C · Fowlerville, MIBuilt 1979 · S/N 15283702N4910DN4910d LLC · Delavan, WIBuilt 1979 · S/N 17272394N4910JGyure Ronald J · Fort Worth, TXBuilt 1968 · S/N 28R-30629N4910LPeake Alexander · Tacoma, WABuilt 1967 · S/N 28-4275N4910PWilkens Jacob James · Eagle River, AKBuilt 1962 · S/N 18-7832N4911FFreed Michael L · Sylmar, CABuilt 1976 · S/N 28-7725035N4911LMccown Brian W · Janesville, CABuilt 1967 · S/N 28-4276N4911ZSamson Robert L · Phoenix, AZBuilt 1961 · S/N 22-8496N49120Aviation Capital Management LLC · San Jose, CABuilt 1979 · S/N 15283425N49123Ascend Aviation LLC · Bountiful, UTBuilt 1977 · S/N 15281152N49125Morey Airplane Co Inc · Middleton, WIBuilt 1979 · S/N 15283426N49126Flight Expo Inc · Princeton, MNS/N 15283427N4912FNab LLC · Wichita, KSBuilt 1976 · S/N 28-7715079N4912GHardee Christopher D · Smyrna, TNBuilt 1979 · S/N 17273459N49138Osborn Scott R · Rch Palos Vrd, CABuilt 1979 · S/N 15283430N4913DRosies Procurement LLC · Midlothian, TXBuilt 1979 · S/N 17272395N4913GLeading Edge Flight Academy LLC · Bend, ORBuilt 1979 · S/N 17273460N4913LHaven Mark · Springfield, TNBuilt 1967 · S/N 28-4278N49142Zion Summit Holdings LLC · Wesley Chapel, FLBuilt 1977 · S/N 15281161N49144Westfall Benjamin C · Coeur D Alene, IDBuilt 1977 · S/N 15281163N4914FCb N4914f LLC · Coventry, CTBuilt 1976 · S/N 28-7715080N4914LWallace Aviation Inc · Wallace, NEBuilt 1967 · S/N 28-4279N49150Skytrain Aviation LLC · Sumner, ILS/N 15281167N49151Zhang Victoria · Daytona Beach, FLBuilt 1979 · S/N 15283432N49159Comer Jacob W · Troy, MOBuilt 1977 · S/N 15281172N4915JFox Richard A · Boynton Beach, FLBuilt 1968 · S/N 28R-30634N4915LRoss Robert J · Landisville, PABuilt 1967 · S/N 28-4280N4915PAubry Nicolas L · Port Jefferson, NYBuilt 1981 · S/N 15284840N4915ZPamment Melvin M · Arlington, KYBuilt 1961 · S/N 22-8501N49161Rohan Gerard K Sr · Marion, WIBuilt 1978 · S/N 15281174N4916GOngstad Anne Whitman · Robinson, NDBuilt 1979 · S/N 17273463N4916JRegistration Pending · Townsend, GARegistration pendingBuilt 1968 · S/N 28R-30635N4916LMl Monkeybar Inc · Mammoth Lakes, CABuilt 1967 · S/N 28-4281N4916TArithansa LLC · Big Bear City, CABuilt 1972 · S/N 28-7225281N4917AAtp Aircraft 7 LLC · Wilmington, DEBuilt 2008 · S/N 4496254N4917GCarter Richard W · Bumpass, VABuilt 1979 · S/N 17273464N4917JTendall Timothy A · Sudbury, MABuilt 1968 · S/N 28R-30637N4917LBlankenbaker Myron K · Jacksonville Beach, FLBuilt 1967 · S/N 28-4282N4917ZGibsons Gas Inc · Holland, NYS/N 22-8506N49189Anderson Seth A · Buckeye, AZS/N 15281182
Back to AD 90-04-06 R1