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.

N25922Byrd-Pettit Caroline A · Smithfield, NCS/N 15280859N25927Cuddie Robert R · Marble Falls, TXBuilt 1939 · S/N 3873N25929Trevisan Hugo S · Polk City, FLBuilt 1981 · S/N 38-81A0105N2592FDunlap Burton D · Mooresville, NCS/N 111N2592LLondke Kevin S · Lexington Park, MDBuilt 1979 · S/N 38-79A0774N2592PRogers Lee B · Anchorage, AKBuilt 1955 · S/N 18-4336N2592SSchaller Lee · New Athens, ILS/N 18-7909166N25932California In Nice Inc · San Jose, CABuilt 1977 · S/N 15280864N2593RWeatherly Lloyd W · Wittmann, AZS/N 28-5654N2593WUehlin Bradley S · Danbury, NEBuilt 1965 · S/N 3282N25948Indiana State University · Terre Haute, INBuilt 1977 · S/N 15280875N2594GRuddle Kaleb T · Lawrenceburg, TNBuilt 1967 · S/N 448N2594MBertke Matthew B · Anchorage, AKS/N 12-1037N2594NDivinity Enterprises LLC · Wilmington, DEBuilt 1979 · S/N 38-79A0933N2594WMcclure Richard A · Victoria, TXBuilt 1965 · S/N 945N25950Gist Phillip C · Fort Worth, TXBuilt 1977 · S/N 15280877N25959South Texas Air Force LLC · Mission, TXS/N 38-81A0087N2595WReid Lois M · Dallas, TXBuilt 1965 · S/N 946N2596ARoach Wesley R · Marietta, GABuilt 1952 · S/N 22-875N2596BWynn Ralph H · Tulsa, OKBuilt 1978 · S/N 38-79A0143N2596EMeigs Jonathan H · Corning, NYBuilt 1978 · S/N 38-78A0483N2596JMarkshausen Zeke R · Santa Paula, CABuilt 1979 · S/N 18-7909121N2596PCarlson Eric S · Kodiak, AKBuilt 1978 · S/N 879N2596WClark Richard · Towanda, PABuilt 1965 · S/N 3283N25976Skylogix Aircraft LLC · La Verne, CAS/N 15280890N25979Andrews University · Berrien Springs, MIS/N 15280892N2597FDonovan Gerald A · Los Lunas, NMBuilt 1965 · S/N 2N2597ZSchroeder Herbert D · Plano, TXBuilt 1977 · S/N 1001-77N2598GRybacki Peter L · Great Barrington, MABuilt 1967 · S/N 423N2598PLeonard David J · Bettles Field, AKBuilt 1955 · S/N 18-4346N2598RRiff Raff Air LLC · Isle La Motte, VTBuilt 1969 · S/N 28-5655N2598WSunset Aviation LLC · New Iberia, LABuilt 1965 · S/N 949N25995Wings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15280903N25998Carlin Delbert J · Blanchard, OKS/N 15280905N2599RNeo Aero LLC · Youngstown, OHBuilt 1969 · S/N 28-5656N2599WBinger Thomas C · Stillwater, MNBuilt 1965 · S/N 950N2599ZAirborne Images Inc · Encino, CABuilt 1977 · S/N 319-77N259ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496080N259CBCalifornia Baptist University · Riverside, CABuilt 2018 · S/N 2881004N259CFMander John E · Kingston, TNBuilt 2003 · S/N BB2059N259DWSmith Jason · Calliham, TXBuilt 2003 · S/N 3492N259GFPerformance Aircraft Sales Inc · Lincoln, NEBuilt 1997 · S/N 17280259N259JBSchmidt Jeffrey · Indianapolis, INS/N 620N259MAWotell Frank C · Orland Park, ILBuilt 2004 · S/N 481-2003N259MGGeorgia Aviation Authority · Eastman, GABuilt 2021 · S/N 2881452N259PEParis Air Inc · Vero Beach, FLBuilt 1977 · S/N 28-7716226N259RAReynolds Darryl G · Wills Point, TXBuilt 1998 · S/N 17280444N259RCMendenhall Robert T · Arlington, WABuilt 2003 · S/N 90041N259RDMeyers Trent R · Redfield, IABuilt 1992 · S/N 259RDN259RPAusmus Jonathan · New Braunfels, TXBuilt 1996 · S/N 1221-96
Back to AD 90-04-06 R1