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.

N341VHYachtphoto Helicopter LLC · Rehoboth Beach, DEBuilt 1993 · S/N 2303MN34202Srs Aurora LLC · Saint Germain, WIBuilt 1972 · S/N 17701700N34205Dingman Douglas W · Albuquerque, NMBuilt 1976 · S/N 177RG0982N34206Jason Air Inc · Arlington, TNBuilt 1972 · S/N 17701704N34208Hokie Flying Club Inc · Christiansburg, VABuilt 1976 · S/N 177RG0983N34209Friesen Chevrolet Inc · Sutton, NEBuilt 1972 · S/N 17701707N3420NKurth Larry A · Williston, FLBuilt 1967 · S/N 680047N3420PKeyuravong Pisonth · Anchorage, AKBuilt 1958 · S/N 23-1384N3420QBalladares Charles V · Mandeville, LABuilt 1977 · S/N 28R-7737054N3420XBurns Kevin D · Decatur, TXBuilt 1966 · S/N 3397N34212Daniel Brian J · Volcano, HIS/N 915B2N3421EWisconsin Aviation Inc · Watertown, WIBuilt 1978 · S/N 17271539N3421PLeever William L Trustee · Medford, ORBuilt 1958 · S/N 18-6775N3421XAltitude Aviation Servieces LLC · Mountain Home, IDS/N 3398N34221Baxter Jonathan · Centerville, MABuilt 1976 · S/N 177RG0985N34223Strother Brenda J · Kenai, AKBuilt 1972 · S/N 17701715N34225Dexter Paul J · Orange, MABuilt 1972 · S/N 17701717N34226Blasjo Darrell W · Hesperia, CAS/N 177RG0986N34227Neiser David R · Napavine, WABuilt 1972 · S/N 17701719N34228Thomas Andrew J · Brownsburg, INBuilt 1972 · S/N 17701720N34229Winchester Creek Aviation LLC · Waynesville, NCBuilt 1972 · S/N 17701721N3422TMangon Ronald A · Petaluma, CABuilt 1967 · S/N 17700722N34231Anderson Roger Q · Manassas, VABuilt 1972 · S/N 17701723N34232Nowacki James R · Brighton, MIBuilt 1972 · S/N 17701724N34233Stimpson Shawn S · Blackfoot, IDS/N 17701725N34235Nefc Inc · North Andover, MABuilt 1972 · S/N 17701726N3423TCardinal Aviation LLC · Springdale, ARBuilt 1967 · S/N 17700723N34241Lewis Mark · Ellisville, MOS/N 17701728N34242Cherokee Pilots LLC · Royersford, PABuilt 1972 · S/N 17701729N34244Eliel F John · Sequim, WABuilt 1972 · S/N 17701731N34248Lucia Arthur H · Blacksburg, VABuilt 1972 · S/N 17701732N3424CHarris Wayne H · Altamont, TNBuilt 1972 · S/N 17701727N3424TWiggains David · Canyon, TXBuilt 1968 · S/N 17700724N3424XCarroll Ronald M · Locust Grove, GABuilt 1966 · S/N 1120N3424ZSemon Sheldon W · Galt, CABuilt 1960 · S/N 22-7337N34250Sierra Lima Aviation LLC · Riverton, UTBuilt 1972 · S/N 17701734N34258Urias Alejandro R · Mcallen, TXBuilt 1972 · S/N 17701737N34259Sharp Kenneth M · Pueblo, COBuilt 1972 · S/N 17701738N3425AMansell Matthew E · Napoleon, MOBuilt 1953 · S/N 22-1693N3425XY E Services Inc · Bradenton, FLBuilt 1966 · S/N 1121N34265Clc Aviation LLC · Springfield, MOS/N 17701739N3426DGaither Timothy · Inman, KSBuilt 1974 · S/N 17264275N3426EJts Management Inc · Lincoln, NEBuilt 1978 · S/N 17271543N3426RCarter Thomas M · Macedon, NYBuilt 1969 · S/N 28-5675N34273Downing Dennis L · Winter Haven, FLBuilt 1972 · S/N 17701741N34274Nast Thomas B · Seattle, WABuilt 1972 · S/N 17701742N34275Bishop Nina A · Gig Harbor, WAS/N 17701743N34276Conlogue Walt R · Wilmington, NCBuilt 1972 · S/N 17701744N3427MFlagiello Marissa Edwards · San Francisco, CABuilt 1977 · S/N 28-7816341N3427NWackerle Timothy S · Marshall, MIS/N 680049
Back to AD 90-04-06 R1