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.

N19962Koosman Shawn · Dresser, WIBuilt 1972 · S/N 17260891N19967Bdc Aero LLC · Miami, TXS/N 17260895N1996ADidisse Robert T · Mccall, IDBuilt 1953 · S/N 22-1092N1996HLord Alan T · Reynoldsburg, OHBuilt 1977 · S/N 28R-7737023N1996JPrestige Worldwide Air LLC · Kalispell, MTBuilt 1995 · S/N 24-3374N1996WMelton Joshua D · Mitchell, INBuilt 1974 · S/N MB-677N1996XRegistered aircraftBuilt 1978 · S/N 38-78A0777N19971Woitas Jody R · Rogers, ARBuilt 1972 · S/N 17260898N19972Virzi Michael A · Independence, OHBuilt 1972 · S/N 17260899N19976West Mi Shooting Alliance For Excellence In Safety · Marne, MIS/N 17702618N19977Moody Matthew Joseph · Homewood, ALBuilt 1977 · S/N 17702619N1997EOlsen Grain & Livestock Inc · Whitewater, MTBuilt 1978 · S/N 17271114N1997YMcculley Lowell Bruce · Front Royal, VABuilt 1964 · S/N 284N1998Berwyn Cynthia K · Southaven, MSBuilt 1997 · S/N 2319N19982Hayton James B · Sedro Woolley, WABuilt 1972 · S/N 17260909N19983Twin Falls Fliers Inc · Twin Falls, IDBuilt 1972 · S/N 17260910N19987Sprinz Steven B · Rimrock, AZBuilt 1972 · S/N 17260914N19988Havener Ronald R · Overland Park, KSBuilt 1972 · S/N 17260915N1998FSpartan Education Group LLC · Tulsa, OKBuilt 1998 · S/N 17280347N1998LAyala Gerardo · San Antonio, TXBuilt 1976 · S/N M-1854N19992United Manufacturing Inc · Holland, MIBuilt 1972 · S/N 17260917N19996Wings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 17260919N19997Neel Aviation LLC · Lakeland, FLBuilt 1972 · S/N 17260920N1999PByler Dennis E · Wasilla, AKBuilt 1955 · S/N 22-2710N1999QGentry Harry J · Canton, OHBuilt 1973 · S/N 177RG0399N1999WWung Jay · Corvallis, ORBuilt 1986 · S/N 24-1564N1999YToth Thomas I · Federal Way, WAS/N 286N199AMVeterinary Imaging Solutions Inc · Davis, CABuilt 2002 · S/N 2201N199ARBarr Air Patrol LLC · Mesquite, TXBuilt 1981 · S/N 17274778N199AVEcho Mike LLC · Baldwin, NYBuilt 1981 · S/N 28-8116283N199BBennett Aviation LLC · New York, NYBuilt 2021 · S/N 3375N199BLSolera Aviation LLC · Bozeman, MTBuilt 2025 · S/N 2881956N199CBSmisek James W · Frankston, TXBuilt 1976 · S/N AA5A0226N199DHDunn James · Fair Oaks, CABuilt 2005 · S/N 2215N199DLClue Vista LLC · San Juan Capo, CABuilt 1997 · S/N 725N199DPNoble Todd D · Hudson, INBuilt 1983 · S/N 981N199ECRegistered aircraftBuilt 1999 · S/N 23982N199GGFarris Clifford T · Acworth, GABuilt 2000 · S/N 002N199GSHare Christopher W · Conroe, TXBuilt 2002 · S/N 5025N199GWRaleigh Flying Club LLC · Chapel Hill, NCS/N 28-7990268N199JFlight For Diabetes LLC · Richmond, ILBuilt 1996 · S/N 006N199JBOew Aviation LLC · Sumter, SCBuilt 1971 · S/N 28R-7135100N199JCHeavy Metal Air LLC · Farmingdale, NYFirst renewal noticeBuilt 2006 · S/N 1031-2006N199JFFronk Jan P · Provo, UTS/N 2N199JTPena Rivera Luis A · Zephyrhills, FLBuilt 1960 · S/N 24-2323N199LBL A B Flying Service Inc · Renton, WAS/N 790N199MCFly N199mc LLC · Nevada City, CABuilt 1977 · S/N 17268570N199RWRush Casey K · Troy, KSBuilt 1991 · S/N REW-01N199SBertrand William R · Lubbock, TXBuilt 2000 · S/N 24831N199SBRegistered aircraftBuilt 2002 · S/N 25575
Back to AD 90-04-06 R1