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.

N45315Taylor Caleb H Trustee · Rancho Santa Fe, CABuilt 1979 · S/N AA5B1167N45319Dale Timothy · Simsbury, CTBuilt 1979 · S/N AA5B1168N4531FOneill Robert J · Rocklin, CABuilt 1976 · S/N 28R-7635415N4531HTerris Edward A · BucksBuilt 1948 · S/N 15-305N4531JQualitair LLC Trustee · MichelstadtBuilt 1968 · S/N 28R-30389N4531SMajors Flying Club · Greenville, TXBuilt 1979 · S/N AA5B1164N4531ZFelts Jacob I · Kalispell, MTBuilt 1960 · S/N 22-8036N45322Alvord Scott Richard · Yorba Linda, CABuilt 1979 · S/N AA5B1180N4532ARasmussen Duane T · Culbertson, MTBuilt 1956 · S/N 22-3841N4532BSpeedbird Ventures LLC · Driftwood, TXBuilt 1979 · S/N AA5B1169N4532HAdvanced Flight Systems Inc · Canby, ORBuilt 1979 · S/N 24-0792N4532JCohen Kyle Lee · Houston, TXBuilt 1968 · S/N 28R-30390N4532KFranklin Paul A · Independence, ORBuilt 1979 · S/N AA5B1171N4532MObrien James P · Mullen, NEBuilt 1947 · S/N 11-36N4532NSkytypers Inc DBA · Las Vegas, NVBuilt 1979 · S/N AA5B1173N4532PMorowitz Jeremy T · Greenwich, CTBuilt 1979 · S/N AA5B1175N4532RWherley Matthew J · Plato, MNBuilt 1965 · S/N 28-21236N4532UAtlas Builders LLC · Valdosta, GABuilt 1979 · S/N AA5B1176N4532WAbernathy Aviation LLC · Morristown, TNBuilt 1976 · S/N 13041N4532XMarrs Daniel J · Red Wing, MNBuilt 1975 · S/N 28-7615025N45336Kelley Joshua S · Anchorage, AKBuilt 1976 · S/N 177RG1107N4533AMount David B · Fairbanks, AKBuilt 1956 · S/N 22-3842N4533FHall Jonathan D · Allison Park, PABuilt 1979 · S/N AA5B1181N4533PFoltz Jeffrey W · Richmond, TXBuilt 1979 · S/N AA5B1185N4533QBritton David L · Franklin, OHS/N AA5B1186N4533WNoco Bluesky LLC · Loveland, COBuilt 1976 · S/N 13042N4533ZDavis Taylor M · Doylestown, PABuilt 1961 · S/N 22-8038N45343Bobbish Charles G · Reston, VABuilt 1979 · S/N AA5B1265N45344Adventure North Flying Service LLC · Baudette, MNBuilt 1979 · S/N AA5B1266N45349Wall Johan D · Brookston, TXBuilt 1976 · S/N 177RG1109N4534DOliver Larry C · Citrus Heights, CABuilt 1979 · S/N AA5B1262N4534E34 Echo Group · Spring Branch, TXBuilt 1978 · S/N 17271622N4534HRevoir Scott R · Hastings, NYBuilt 1948 · S/N 15-307N4534JCartaya Lazaro C · Miami, FLS/N 28R-30393N4534LBottem Lee T · Broken Arrow, OKBuilt 1979 · S/N AA5B1263N4534RDuwelius Charlotte Sue DBA · Hermiston, ORBuilt 1965 · S/N 28-21238N4534TSunrise Aviation Inc · Ormond Beach, FLBuilt 1972 · S/N 34-7250127N4534VSammons Ryne William · Bargersville, INBuilt 1979 · S/N AA5B1264N4534X4534xray Flyers Ltd · Lima, OHBuilt 1975 · S/N 28R-7635071N4534ZKay Bennie L · Brigham City, UTBuilt 1960 · S/N 22-8039N45359Clapp Edwin G III · Fargo, NDBuilt 1976 · S/N 177RG1112N4535DFrancis Mark D · Holden Beach, NCBuilt 1979 · S/N AA5B1267N4535JMooney Executive Partnership · Kent, WABuilt 1968 · S/N 28R-30394N4535LCratz33 LLC · Cincinnati, OHBuilt 1979 · S/N AA5B1269N4535TCrews Joseph G · Cleveland, MSBuilt 1971 · S/N 28-7105222N4535VSanders Aviation LLC · Boerne, TXBuilt 1979 · S/N AA5B1272N45362Morrow Rodney T · Yorktown, INBuilt 1979 · S/N AA5B1287N45367Christensen Robert T · Presho, SDBuilt 1976 · S/N 177RG1113N4536BHolsten Guy V · Mineral, VABuilt 1979 · S/N AA5B1276N4536JSale Reported · Merrill, WISale reportedBuilt 1968 · S/N 28R-30395
Back to AD 90-04-06 R1