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.

N724Morrison Richard L Trustee · Anchorage, AKBuilt 1999 · S/N 2009N72400Brown Michael · Greeneville, TNFirst renewal noticeBuilt 1999 · S/N 2031N72403Drury Edward D · Little Silver, NJS/N 33701576N7240FDewberry Dylan C · Springfield, ORBuilt 1968 · S/N 28-25153N7240GKendallville Flying Club Inc · Auburn, INBuilt 1970 · S/N 17258940N7240JFlytt LLC · Naples, FLBuilt 1968 · S/N 28-24577N7240YHodges David S · Reidsville, GABuilt 1964 · S/N 30-264N72418Bishop Raymond Max · Chandler, AZBuilt 1964 · S/N RB-3N7241CHeritage Timothy D · Glendale, AZBuilt 1975 · S/N 28-7625073N7241DFrisby James A · Palmer, AKBuilt 1957 · S/N 22-5262N7241JHopkins Justin C · Benson, AZFirst renewal noticeS/N 28-24578N7241WBurtchett Tyler D · Buckeye, AZBuilt 1963 · S/N 28-1075N72421N83882 Inc · Huntington, NYBuilt 1968 · S/N 17257407N7242FDjair · Winchester, VAS/N 28-25155N7242GIrizarry Heriberto J · Homestead, FLBuilt 1970 · S/N 17258942N7242WSouthwest Fluid Products Inc · Weatherford, TXS/N 28-1065N72432Kaono Jerry C · Carson, CABuilt 1973 · S/N 33701581N7243FBlack Diamond Real Estate · Roseville, CABuilt 1968 · S/N 28-25159N7243GKrumbine David A · Lebanon, PABuilt 1970 · S/N 17258943N7243JNova Flight LLC · Gainesville, VABuilt 1968 · S/N 28-24583N7243VRobarge Chad Steven · Duluth, MNBuilt 1947 · S/N 123238N7243WLejeune Ovey Eugene · Roanoke Rapids, NCBuilt 1963 · S/N 28-1066N72448Clay Jason I · Imperial Beach, CABuilt 1957 · S/N 185841N7244QBuckley Gregory L · Melba, IDS/N 17260544N7244YJ Mac Aviation Services LLC · Andalusia, ALBuilt 1964 · S/N 30-269N72454Dawson Adam J · Eveleth, MNBuilt 1952 · S/N 18-1715N7245FLeinart Brannon B · Merit, TXBuilt 1968 · S/N 28-25161N7245JKallen David A · Northville, NYBuilt 1968 · S/N 28-24586N7245KKnuckles Dennis P Trustee · Custer, SDBuilt 1950 · S/N 18-140N7246CValiair Limited Co Trustee · Casper, WYBuilt 1975 · S/N 28-7615048N7246GHale Warren P · Martinsburg, MOBuilt 1970 · S/N 17258946N7246JCooper Christopher B · Crowley, TXBuilt 1968 · S/N 28-24587N7246QHaines Anne K · Ligonier, PABuilt 1972 · S/N 17260546N7246YMoyer Thomas L · Fayetteville, GABuilt 1964 · S/N 30-271N72475Pripps Seth · Appleton, WIBuilt 1946 · S/N 9643N7247DTodey Mark A · Rathburn, IABuilt 1957 · S/N 22-5073N7247KLangley Preston B · Warwick, NDBuilt 1950 · S/N 18-142N7248DLeeuw Timothy P · Dillon, MTBuilt 1957 · S/N 22-5074N7248QEricson Steven L · Dorris, CABuilt 1972 · S/N 17260548N72493Cook Tyler · Seldovia, AKBuilt 1975 · S/N 18775N7249DHansen Larry G · Alliance, NEBuilt 1957 · S/N 22-5075N7249FAndrews Josh S · Warsaw, MOBuilt 1968 · S/N 28-25166N7249GTate Donald E · Jonesburg, MOBuilt 1970 · S/N 17258949N7249JJohnson Dale F · Marion, INBuilt 1968 · S/N 28-24591N7249PDavis Scott · Bingham, NEBuilt 1960 · S/N 24-2425N7249QTrailgate Tailgate Systems Inc · Belle Vernon, PABuilt 1972 · S/N 17260549N7249YCt Capital LLC · Austin, TXS/N 30-274N724AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843790N724BJWade Joel M · Lake Stevens, WAS/N 5456N724CASouth Shore Flying Club Inc · South Weymouth, MABuilt 1999 · S/N 2843224
Back to AD 90-04-06 R1