OpenAirDocs.org
AD 90-06-03 R1

Registered aircraft · 20,683

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-06-03-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-06-03-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.

N5374KApex Aircraft Leasing LLC · Anchorage, AKBuilt 1980 · S/N 17274086N53759Pacific Lease · Elk Grove, CABuilt 1981 · S/N 17274814N5375JDaviss Joseph A · Sylacauga, ALS/N 17273768N5375RArctic Flying Club · Fairbanks, AKBuilt 1974 · S/N 17263527N5376HPires Fernando L · Hilmar, CAS/N 17265416N5376JTss Aviation LLC · Conyers, GAS/N 17273769N5377DDesantis Anthony · Memphis, TNBuilt 1979 · S/N 17272552N5377TAllen James W · Lakewood Ranch, FLBuilt 1964 · S/N 17251277N5377VShoemake Stephen Sidney · Pine Mountain, GABuilt 1980 · S/N 172RG0517N5378DMustang Sally Aviation LLC · Camden, SCBuilt 1979 · S/N 17272553N5378ENuxoll Randy G · Eagle, IDBuilt 1978 · S/N 17271841N5378KUnique Educational Experiences Inc · Signal Hill, CABuilt 1980 · S/N 17274087N5378RGittlein Paul A · Wasilla, AKBuilt 1965 · S/N 17252912N53794Rick Aviation Inc · Newport News, VABuilt 1981 · S/N 17274816N53797Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17274819N5379TBerry Kevin R · Bowie, TXBuilt 1964 · S/N 17251279N537EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2025 · S/N 172S13305N537HFSilver Express Co · Miami, FLBuilt 2000 · S/N 17280891N537KSKent State University · Stow, OHBuilt 2014 · S/N 172S11388N537NDSpartan Education LLC · Tulsa, OKBuilt 2009 · S/N 172S10990N537SP5280 Flying Club LLC · Castle Pines, COBuilt 2000 · S/N 172S8393N5380TEdwards Air LLC · Raleigh, NCBuilt 1964 · S/N 17251280N53822American Patrols Inc · Midland, TXBuilt 1981 · S/N 17274821N5382DEagles Flying Club · Saint Charles, MOBuilt 1979 · S/N 17272556N5383DTong Sheng Aviation LLC · Irvine, CABuilt 1979 · S/N 17272557N5383KAmerican Patrols Inc · Midland, TXBuilt 1980 · S/N 17274088N5383TMeyers Morgan J · Twin Falls, IDS/N 17251283N5384KVascular Wings LLC · Friendswood, TXBuilt 1980 · S/N 17274089N5384RKidd Frank E Jr · Wilson, NCBuilt 1965 · S/N 17252919N5384TJohnson William R · Virginia Beach, VABuilt 1964 · S/N 17251284N5385DDg Aviation Services Inc · Merritt Island, FLBuilt 1979 · S/N 17272558N5385JAerowood Aviation LLC · Monroe, NCBuilt 1980 · S/N 17273775N5386DDuffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1979 · S/N 17272559N5386JNaylor-Adams Aviation LLC · York, PABuilt 1980 · S/N 17273776N5386RVargo Michael D · Fremont, OHBuilt 1965 · S/N 17252921N5387KN5387k LLC · Carthage, NCBuilt 1980 · S/N 17274091N5387ROancea Traian · Oakdale, CAS/N 17252922N5387TMagnusson Charles D · Upper Sandusky, OHBuilt 1964 · S/N 17251287N53885Gc Aviation Services-1 LLC · Miamisburg, OHBuilt 1981 · S/N 17274824N5389KMcconnell Cynthia D · New Smyrna Beach, FLBuilt 1980 · S/N 17274092N5389RTetrault David E · Largo, FLBuilt 1965 · S/N 17252925N5389TChadwell Letch J · Hulbert, OKBuilt 1964 · S/N 17251289N538CJav Air Services LLC · Anchorage, AKBuilt 1981 · S/N 17274724N538EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13078N538HFSun Aircraft Management LLC · Ormond Beach, FLBuilt 2000 · S/N 17280873N538KSKent State University · Stow, OHBuilt 2014 · S/N 172S11389N538NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10832N538SPRc Flying Partners LLC · Fair Oaks, CABuilt 2000 · S/N 172S8395N538TBCorum Richard E Jr · Clemmons, NCBuilt 1963 · S/N 17249965N5390RSmith James H · Fordyce, ARBuilt 1965 · S/N 17252926
Back to AD 90-06-03 R1