OpenAirDocs.org
AD 90-06-03 R1

Registered aircraft · 20,687

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.

N737XURaynor Andrew C · Kingman, AZS/N 17269761N737XWWeiss Gregory K · Colorado Springs, COBuilt 1977 · S/N 17269763N737XZBrown John P Jr · Winter Garden, FLBuilt 1977 · S/N 17269766N737YADuffys Aircraft Sales And Lsg Inc · Neillsville, WIBuilt 1977 · S/N 17269767N737YBBurke Donald T · Scranton, NDBuilt 1977 · S/N 17269768N737YEAeroventures Flying Club Inc · Lilburn, GABuilt 1977 · S/N 17269771N737YFVero Technical Support Inc · Pensacola, FLBuilt 1977 · S/N 17269772N737YGAgassiz Flyers Inc · Herman, MNBuilt 1977 · S/N 17269773N737YPYankee Papa LLC · Wilmington, DEBuilt 1977 · S/N 17269780N737YQTec Aviation Inc · Pasco, WABuilt 1977 · S/N 17269781N737YSCk Max LLC · Stanford, KYBuilt 1977 · S/N 17269783N737YT80075 Aircraft Corporation LLC · Wilmington, DEBuilt 1973 · S/N 17261481N737YULake Elmo Aero LLC · Lake Elmo, MNBuilt 1977 · S/N 17269785N737YVLees Sea Air · Kiana, AKBuilt 1977 · S/N 17269786N737YZWininger Spencer C · Wichita, KSBuilt 1977 · S/N 17269790N737ZACounty Of Santa Cruz · Santa Cruz, CABuilt 1977 · S/N 17269791N737ZCMoody Air Ventures LLC · Nolanville, TXBuilt 1977 · S/N 17269793N737ZDHp Air Inc · Cape Coral, FLBuilt 1977 · S/N 17269794N737ZGDuck Air LLC · Mooresville, NCBuilt 1977 · S/N 17269797N737ZJLazy Eights Holdings LLC · Greenwood, INBuilt 1977 · S/N 17269799N737ZKAk Fly Inc · Kasilof, AKBuilt 1977 · S/N 17269800N737ZNEquinoxx Flight Systems LLC · Lawrenceville, GABuilt 1977 · S/N 17269803N737ZPJahawk Leasing LLC · Sugar Grove, ILBuilt 1977 · S/N 17269804N737ZRTennessee Seaplane Company LLC · Knoxville, TNBuilt 1977 · S/N 17269806N737ZTEdwards Ronald R · Clinton, ARBuilt 1977 · S/N 17269808N737ZVJax Aero LLC · Jacksonville, FLBuilt 1977 · S/N 17269810N737ZWS & S Aviation Co · Ball Ground, GAS/N 17269811N73800Soul Aviation LLC · Newport Beach, CABuilt 1976 · S/N 17267690N73808Delta Aviation Inc · Monticello, MNBuilt 1976 · S/N 17267691N7380GOrlandi Properties LLC · Blairstown, NJBuilt 1970 · S/N 17259080N7380TAndersen William A · Flagstaff, AZBuilt 1959 · S/N 46980N73813Smoot Russell L · Louisville, KYBuilt 1976 · S/N 17267693N73816Nedved Aviation LLC · Mitchell, SDBuilt 1976 · S/N 17267696N73819Botter Marlene S Trustee · Kent, WABuilt 1976 · S/N 17267699N7382AWretschko Brian W · Phoenix, AZBuilt 1956 · S/N 29482N73830Asbury Paul G · Charleston, TNBuilt 1976 · S/N 17267706N73837Bloomex Aviation LLC · Montvale, NJS/N 17267711N7383LChicken Hawk Aviation LLC · Strasburg, COS/N 17273259N7383TLeach Jeff · Terlingua, TXS/N 46983N73846Bernstein Matthew D · North Charleston, SCBuilt 1976 · S/N 17267717N73848Dorson Daniel J · Eden Prairie, MNBuilt 1976 · S/N 17267719N7384EFierman Jo Angela · Madison, GABuilt 1978 · S/N 17272100N7384TMclaughlin James L · Centerburg, OHS/N 46984N73852Carrion Jesus · Staten Island, NYBuilt 1976 · S/N 17267721N73855Dury Aviation Services Inc · Portage Des Sioux, MOBuilt 1976 · S/N 17267723N7385AColli Guido F · Miami, FLBuilt 1957 · S/N 29485N7385TSeed And Sky Provisions LLC · College Station, TXS/N 46985N73864Martz Richard W · Alta Loma, CABuilt 1976 · S/N 17267729N73868Ca Aero LLC · Fairfield, NJBuilt 1976 · S/N 17267730N7386ADrum Keith Brian · Clover, SCBuilt 1956 · S/N 29486
Back to AD 90-06-03 R1