OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,375

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.

N3734ASteel Alan P · Odessa, TXBuilt 1953 · S/N 22-1977N3734LBertrand Todd A · Anchorage, AKBuilt 1965 · S/N 17253903N3734PHamilton Richard L · Monticello, FLBuilt 1955 · S/N 22-3454N3734UDaricl LLC · Shoreham, NYBuilt 1980 · S/N M-2290N3734XTechnical Education Services Inc · Virginia Beach, VABuilt 1968 · S/N 5042N3735ATurner John C · Corinth, MSBuilt 1953 · S/N 22-1978N3735RJones Larry L · Paragould, ARS/N WA-171N3735XMcmanus Edwin · Austin, TXS/N 5043N3736APlitt Benjamin T · Hortonville, WIFirst renewal noticeS/N 22-1979N3736KBloom Cory G · Indianola, IABuilt 1967 · S/N 28-23713N3736PKelly Larry M · Alexander City, ALBuilt 1955 · S/N 22-3456N3736TVelivis Bernard K · Hollis, NHBuilt 1967 · S/N 28R-30045N3736XSmith William C · San Antonio, TXBuilt 1968 · S/N 5045N3737TKenny David Jack · Frederick, MDBuilt 1967 · S/N 28R-30046N3737UAirria Holdings LLC · BerlinBuilt 1980 · S/N ME-379N3739MAdair Steven M · Collierville, TNBuilt 1947 · S/N 12-2676N3739QN3739q LLC · Colleyville, TXFirst renewal noticeBuilt 1982 · S/N ME-378N373BSPenn Mitchell · Poplar Bluff, MOBuilt 1969 · S/N 28-26555N373CACoco Aircraft Inc · Merritt Island, FLBuilt 1988 · S/N 2841014N373CBCalifornia Baptist University · Riverside, CABuilt 2017 · S/N 2844174N373EWBaker Sheryl Wolff · Elbert, COS/N 80476N373GHHaley Greg W · Frankston, TXBuilt 2013 · S/N 73495N373JWSousek Samuel V II · Shawano, WIBuilt 2020 · S/N 70373N373MKNorth Star Aviation · Mankato, MNBuilt 2025 · S/N 2881986N373SAnderson Thomas · Brooklyn, NYBuilt 1995 · S/N 1N373SERegistration Pending · Phoenix, AZRegistration pendingBuilt 1996 · S/N 18-506N3740BWood Graham A · Marshall, WIS/N WA-186N3740TBibbey Mark A · Chandler, AZBuilt 1967 · S/N 28R-30049N3740XBarnato Peter M · Twain Harte, CABuilt 1968 · S/N 5050N3740ZCarl Eric Storm Trustee · Eagle River, AKBuilt 1966 · S/N 18-7496N3741APrice John C · Bennington, KSBuilt 1953 · S/N 22-1984N3741TIowair Inc DBA · Atkins, IABuilt 1968 · S/N 28R-30957N3741ZStanton Morgan · Anchorage, AKBuilt 1963 · S/N 18-7497N3742FBenson Edward A · San Antonio, TXBuilt 1977 · S/N 0755N3742XHancock John R · Poplarville, MSBuilt 1968 · S/N 5052N3743BPittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1955 · S/N CH-169N3743PBulldog Aviation LLC · Ely, MNBuilt 1955 · S/N 22-3463N3743QTonneson Rollin J · Souris, NDBuilt 1977 · S/N 28-7790464N3743XHenderson Douglas A · Springerville, AZBuilt 1968 · S/N 5053N3744APhillips Mark W · New Underwood, SDBuilt 1954 · S/N 22-1987N3744PCaplinger Jimmy C · Justin, TXBuilt 1955 · S/N 22-3464N3744TAg Air Squadron One LLC · Saint Joseph, ILBuilt 1967 · S/N 28R-30054N3744XLongwill Dusty J · Raton, NMBuilt 1968 · S/N 5055N3744ZWild About Nature LLC · Fairbanks, AKBuilt 1960 · S/N 18-7502N3745ADock Engineering Inc · Stillwater, OKBuilt 1995 · S/N 1996-LN3745KMangels Christopher L · Wasilla, AKBuilt 1946 · S/N 1438N3745THill James C · Grand Saline, TXS/N 28R-30055N3745VHill Lesly G · Folsom, CABuilt 1948 · S/N 15022N3745ZFlint Paul L · Anchorage, AKBuilt 2001 · S/N 001N3746ASpivey Harold E · Thomaston, GAS/N 22-1989
Back to AD 90-04-06 R1