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.

N5DDSeghetti Brant C · San Tan Valley, AZBuilt 1974 · S/N AF17448714N5DNStinemetze Justin T · Mojave, CABuilt 1986 · S/N 892N5DPN5dp LLC · Ann Arbor, MIBuilt 1973 · S/N 28-7405033N5EBN5eb LLC · Medina, OHBuilt 1967 · S/N 30-1474N5EDDuck Donald S · Edwardsburg, MIBuilt 1948 · S/N 15-153N5EECristal Air Inc · Wilmington, DEBuilt 1993 · S/N 172N5EJJones Eric M · Southbridge, MAS/N 177RG0167N5EYOshikoo LLC · Seattle, WABuilt 2004 · S/N 70267N5FPittsburgh Institute Of Aeronautics · Pittsburgh, PABuilt 1957 · S/N DH-131N5FMWillis Nelson W · Lebanon, TNBuilt 1994 · S/N 0001N5FNM J S Corp · Howe, INBuilt 2013 · S/N 1468-2012N5FVRegistered aircraftBuilt 1981 · S/N 2254N5GHDowin Robert R · Doylestown, PABuilt 1970 · S/N 700046N5GJNorthampton Lsa LLC · Northampton, MABuilt 1978 · S/N GA7-0006N5GNNeu Lawrence R · Marion, TXBuilt 1977 · S/N XX5N5GYSeven Sierra Yankee LLC DBA · Monroeville, PABuilt 1924 · S/N JH-171N5HNBartle Henry P · Independence, ORBuilt 1991 · S/N S 55N5JBucher John R · Rch Palos Vrd, CABuilt 1966 · S/N 300N5JCSink Abram T · Hillsboro, OHBuilt 1982 · S/N 518N5JFStephens John D · Esparto, CABuilt 1973 · S/N 001N5JLRegistered aircraftBuilt 1968 · S/N TD-719N5JNOcchiuzzo Joseph A · Holyoke, MAFirst renewal noticeBuilt 1963 · S/N 28-1528N5JXFive Jx LLC · Tucson, AZBuilt 2012 · S/N 24785N5KDTexas Tailspin LLC · Amarillo, TXBuilt 1974 · S/N 155-74N5KECebeci Paul · Saint Augustine, FLBuilt 1971 · S/N 155N5KFSneddon Dale R · Carthage, MOBuilt 1986 · S/N 65N5KKClough Albert Hughes · Douglas, AKBuilt 1947 · S/N 12-1926N5LGStuller Dennis · Fort Denaud, FLBuilt 1966 · S/N 28-22238N5LYLittle Karley Y · Baytown, TXBuilt 1971 · S/N 474N5MAScola Daniel B · Port Orange, FLBuilt 1967 · S/N 30-1622N5MDDunn Vincent K · Salem, ORBuilt 1966 · S/N 3317N5NSN5ns LLC · Payson, AZBuilt 1995 · S/N NEALN5PTMunson George R · Westhampton, MABuilt 1972 · S/N 17260628N5QABear Canyon LLC · Afton, WYBuilt 1997 · S/N 1369N5QTHusky5qt LLC · Scappoose, ORBuilt 1997 · S/N 1380N5RBBanasik Associates Inc · Columbus, OHBuilt 1976 · S/N 177RG0968N5RJPilkington Lawrence O · Portland, ORS/N 739N5RQOgden Christopher S · Chewelah, WABuilt 1964 · S/N 1N5RWToms Ronald C · Lena, LABuilt 1970 · S/N 17259649N5SKKershaw Spence M · Hollywood, FLBuilt 1975 · S/N 135-HN5SMBearss Gordon M · Topeka, KSBuilt 1974 · S/N 21-0051N5SPMalley Anthony M · Arlington, TXBuilt 2005 · S/N 70144N5SRRollins Jay A · Muncie, INBuilt 1978 · S/N 73059LFN5TEBythway William M · Painesville, OHBuilt 1968 · S/N 113N5UASenneker Robert L · Dorr, MIBuilt 2001 · S/N 25103N5UZRick Aviation Inc · Newport News, VABuilt 1980 · S/N 44-8107008N5VTEmaaduddin Mohammed · Yonkers, NYBuilt 1967 · S/N 28-23176N5VYFeatherstone Tony W · Denton, TXBuilt 1973 · S/N AA5-0462N5WDSonoma Valley Aircraft Inc · Vineburg, CABuilt 1980 · S/N 105DN5WKEz Air Inc · Wilmington, DES/N 30-1853
Back to AD 90-04-06 R1