OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,369

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.

N222JAJeff Abrams LLC · Ocala, FLBuilt 2000 · S/N 3062N222JGNoyes Jeffery A · Bridgeport, TXBuilt 1959 · S/N TD-215N222KKBymers Gary E · Waunakee, WIS/N 222N222KLLohmueller Kurt M · Powder Springs, GABuilt 2005 · S/N 21308N222KMKomoroski Edward J · Frenchtown, NJBuilt 1990 · S/N 337N222KRSharon Carl G · Brookshire, TXBuilt 1979 · S/N 24-0773N222KSTriple Two Inc · Wilmington, DEBuilt 1976 · S/N 28-7790270N222LYLava Tech LLC · St George, UTBuilt 2010 · S/N 91629N222MJHonore Breen Aviation LLC · Allegan, MIS/N 12-1905N222MNMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881532N222NARodriguez Lukas · River Oaks, TXBuilt 1974 · S/N 28-7415226N222NDPlane Nonsense Inc · Middletown, DEBuilt 2001 · S/N 2842111N222NLLawson Lonnie B II · Linden, PABuilt 2001 · S/N 25137N222NYCivil Air Patrol · Maxwell Afb, ALBuilt 1985 · S/N 17276473N222PCSmith Dustin L · Corinth, MSBuilt 1987 · S/N 1N222PJSchroeder James L · Rapid City, SDBuilt 1973 · S/N 28-7305259N222PWWelch Michael C · El Dorado Hills, CABuilt 1990 · S/N 155N222RACaptain Rick LLC · Miami Lakes, FLBuilt 1973 · S/N 28R-7435127N222RJAmbrose James · Dyersburg, TNBuilt 1977 · S/N 22-1438N222RKMiller Bruce · Plano, TXBuilt 1974 · S/N 448-74N222RVWyatt Jacob A · Ogallala, NEBuilt 1992 · S/N 2305N222SPRobinson Avery Clark · Phoenix, AZBuilt 1965 · S/N 701N222TMJtm Ranches Equipment LLC · Dallas, TXBuilt 1981 · S/N 18-8109081N222TRHarper David E · Stillwater, MNBuilt 1946 · S/N 108-322N222UClukey David Alan · Bryant Pond, MEFirst renewal noticeBuilt 1957 · S/N 23-912N222UKCantine Steven L · Kotzebue, AKBuilt 1991 · S/N 2210N222USTicoair LLC · Wilmington, DEBuilt 1979 · S/N 17273491N222WGWalker Scott Aviation LLC · Woodward, OKBuilt 1978 · S/N M-2092N222XPMarshall Greg J · Alexandria, VABuilt 2021 · S/N 102N2230TWhite Pelican LLC · Union City, TNBuilt 1971 · S/N 28-7105189N2230XPoff Matthew W · Miramar Beach, FLBuilt 1979 · S/N 28-7990374N2231KBishop Elijah Ar · Ukiah, CABuilt 1947 · S/N 4958N2232Reigle Aviation · Palmyra, PABuilt 1971 · S/N 1-GPN2232ASummit Air LLC · Clarks Summit, PABuilt 1976 · S/N 28-7690460N2232BLucky Dog Land Co LLC · Caldwell, IDBuilt 1990 · S/N 512N2232EPink Skies Inc · Willoughby, OHBuilt 1978 · S/N 17271195N2232LDodson Jack Yii · Douglasville, GABuilt 1976 · S/N MB-819N2232NKnoll Guenter Wilhelm · Belton, SCBuilt 1979 · S/N 28-7990283N2232WJkj Aviation · Wilmington, NCBuilt 1979 · S/N 28-7916334N2233Jacobson Luke W · Reno, NVBuilt 1968 · S/N 62N2233BRollin Virginie C · Mountain House, CABuilt 1978 · S/N 28-7816598N2233CFreeland Robert D · Victor, MTBuilt 1978 · S/N 28-7990147N2233PAeroplanes Over Idaho · Caldwell, IDS/N 23-842N2233XSpector Arnold · Stamford, CTBuilt 1979 · S/N 28-7990368N2234FMoore Aviation LLC · Cedar Springs, MIBuilt 1978 · S/N 28-7990207N2234PDanhauer Jeffrey · Owensboro, KYBuilt 1974 · S/N 761-74N2235BConner W Larry · Los Lunas, NMBuilt 1978 · S/N 28-7916120N2235ELivingston Eric L DBA · Winchester, INBuilt 1978 · S/N 17271198N2235LCarter Dale · Riga, MIBuilt 1976 · S/N M-1905N2235WSamuels Walter E · Wilmington, NCBuilt 1969 · S/N 30-1844
Back to AD 90-04-06 R1