AD 90-04-06 R1

Registered aircraft · 68,377

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.

N733XFBeaugez Gregory C · Perkinston, MSBuilt 1977 · S/N 17268625N733XKSabol Edward J Trustee · Leominster, MABuilt 1977 · S/N 17268629N733XLAirspeed Marketing LLC · Phoenix, AZBuilt 1977 · S/N 17268630N733XMRoatis Calin V · Sacramento, CAS/N 17268631N733XNFlyn Go LLC · Spring, TXBuilt 1977 · S/N 17268632N733XZ3650 Aircraft Inc · Bakersfield, CABuilt 1977 · S/N 17268643N733YBZulu Aerospace Services LLC · Peoria, AZBuilt 1977 · S/N 17268645N733YEDiederich Fred H · Fayette City, PABuilt 1977 · S/N 17268648N733YGLeaschauer Eitan · San Jose, CABuilt 1977 · S/N 17268650N733YHBailey Gordon J · Fayetteville, GABuilt 1977 · S/N 17268651N733YPMiller Robert · Battle Creek, MIBuilt 1977 · S/N 17268657N733YRBoccaccio Donald O · Hypoluxo, FLBuilt 1977 · S/N 17268659N733YTRegistration Pending · Centereach, NYRegistration pendingBuilt 1977 · S/N 17268661N733YYTetrault Howard D · Malabar, FLBuilt 1977 · S/N 17268666N733YZSeaplane Adventures LLC · Cheyenne, WYBuilt 1977 · S/N 17268667N733ZBMidstate Aviation 1 LLC · Owosso, MIBuilt 1977 · S/N 17268669N733ZEKgr Aviation LLC · Austin, TXBuilt 1977 · S/N 17268672N733ZKStone Aviation LLC · Sacramento, CABuilt 1977 · S/N 17268677N733ZNAtmospheric Vehicle & Spacecraft Flt Exploration · Rch Palos Vrd, CABuilt 1977 · S/N 17268680N733ZPFruit Belt Flyers Inc · Saint Joseph, MIBuilt 1977 · S/N 17268681N733ZSMccown Jamey · Bayfield, COBuilt 1977 · S/N 17268684N733ZYHess Garrett J · Fullerton, CAS/N 17268690N733ZZDuncan James · La Porte, TXBuilt 1977 · S/N 17268691N734United States Department Of Agriculture · Cedar City, UTBuilt 1956 · S/N 18-5258N73401Sage Kathlene A · Bass River, MABuilt 1976 · S/N 17267431N73407Wxly Aviat LLC · Gastonia, NCBuilt 1976 · S/N 17267435N7340BThaut Lance A · Fullerton, CABuilt 1977 · S/N A1520752N7340LAzure 01 LLC · Canton, NYBuilt 1978 · S/N A1520792N7340PWard James A · Brentwood, TNBuilt 1961 · S/N 24-2519N7340WMillar Russell J · Saint Onge, SDS/N 28-1211N73411Elwood James C · Jupiter, FLBuilt 1976 · S/N 17267438N73419Cook Thomas M · Palmer, AKBuilt 1976 · S/N 17267443N7341DDunn Steven J · Youngsville, PAFirst renewal noticeBuilt 1957 · S/N 22-5130N7341GHolmes Omer Lane Jr · Metairie, LABuilt 1970 · S/N 17259041N7341JRicciardi John A · Norwalk, CTBuilt 1968 · S/N 28-24696N73420Globemaster Services LLC · Saint Jacob, ILBuilt 1976 · S/N 17267444N73423Weck Geoffrey E · Woodstock, ILBuilt 1976 · S/N 17267447N73424Quincy Flying Club Inc · Quincy, ILBuilt 1976 · S/N 17267448N73425Wings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267449N73428Johnson Brent C · Appleton, MNBuilt 1976 · S/N 17267452N73429Anson Flyers Club Inc · Wadesboro, NCBuilt 1976 · S/N 17267453N7342JWingate Nicholaus · Lawton, OKS/N 28-24671N7342LPalmer Ronald E Trustee · Bristol, NHBuilt 1975 · S/N 18-7509048N7342YHinkle Anthony · Mineola, TXBuilt 1964 · S/N 30-392N73433Salvation Neighborhood Development Corp · Riverside, CAS/N 17267457N73434Monette Verne G · Anchorage, AKBuilt 1976 · S/N 17267458N73435Air America Spares LLC · Daytona Beach, FLBuilt 1976 · S/N 17267459N73439Umo Flight School LLC · Mount Olive, NCBuilt 1976 · S/N 17267462N7343DRautio Mitchell M · Bemidji, MNS/N 22-5132N7343JSawyer Dean A · Kerrville, TXBuilt 1968 · S/N 28-24484
Back to AD 90-04-06 R1