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.

N584FLQuantum Aviation Services LLC · Lakewood Ranch, FLBuilt 1971 · S/N 28-7125439N584KButterfield Rory A · Milan, NMBuilt 1975 · S/N 584N584LLawver William A · Panama City, FLBuilt 1972 · S/N AA5-0084N584LKTipton William M · Burlington, NCBuilt 1999 · S/N 103MN584LMTiede Russell James · Miami, AZBuilt 2003 · S/N 70171N584RVFelix Leonard D Jr · Salome, AZS/N 587N584SShobe Andrew S A · Clarksville, MDBuilt 1977 · S/N 28R7737112N584SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881403N584SFDsr Cherokee 180 LLC · Dallas, TXBuilt 1968 · S/N 17256834N584SPTexas State Technical College At Waco · Waco, TXBuilt 2000 · S/N 172S8511N584UConverse Donald A · Los Alamitos, CABuilt 1986 · S/N 862N584YKBachman David A · Griggsville, ILBuilt 1973 · S/N AA1B-0286N5850LXeus Inc · Nottingham, PABuilt 1972 · S/N AA5-0050N5850QMcmoran Donald W · Mount Vernon, WAS/N 3134N5850UMarfair LLC · Freeport, TXBuilt 1970 · S/N 28-26681N5850WCaside Aviation LLC · Brooklyn, NYBuilt 1965 · S/N 28-2296N5850ZMiller Helen J · Springfield, OHBuilt 1963 · S/N 22-9705N5851DRubbert Lorin E · Reynolds, NDBuilt 1956 · S/N 22-4530N5851LOretsky Philip H · South Haven, MIBuilt 1972 · S/N AA5-0051N5851UFoothill Aircraft Sales & Service Inc · Upland, CABuilt 1969 · S/N 28-26683N5851VMcconnell Thomas E · Grass Valley, CABuilt 1977 · S/N 28-7715273N5851WCameron Hugh R · Gainesboro, TNBuilt 1965 · S/N 28-2308N5851ZBurklund Joel H · Minneapolis, MNBuilt 1963 · S/N 22-9706N5852HKelley Don Lee · Loon Lake, WABuilt 1949 · S/N 16-462N5852LOhser David G · Hudson, FLBuilt 1972 · S/N AA5-0052N5852QOldham Jared K · Richfield, WIBuilt 1965 · S/N 3135N5852WFerguson Carl R · Waupaca, WIBuilt 1965 · S/N 28-2312N5852ZTuttle James R · Cherryvale, KSS/N 22-9708N5853DHapka Leon J · Halma, MNBuilt 1956 · S/N 22-4532N5853LKennedy Samuel E · Watsonville, CABuilt 1972 · S/N AA5-0053N5853PLewellen Walter G · Moreno Valley, CABuilt 1959 · S/N 24-935N5853UPost Jay M · Greenfield, OHBuilt 1970 · S/N 28-26685N5854DPro West Air LLC · West Point, UTS/N 22-4533N5854LVolpe Brandon M · Baton Rouge, LABuilt 1972 · S/N AA5-0254N5854UMagic Valley Aero Club Inc · Twin Falls, IDBuilt 1970 · S/N 28-26686N5854WAtluas LLC · Dallas, TXBuilt 1965 · S/N 28-2333N5855DMiller Justin · Boaz, ALBuilt 1956 · S/N 22-4534N5855HNortheast Cub LLC · Hudson, NYS/N 16-473N5855LSchauf Cindy R · Colwich, KSBuilt 1972 · S/N AA5-0055N5855WZachry David · West Point, GABuilt 1965 · S/N 28-2358N5856DStephen George · Land O Lakes, WIBuilt 1956 · S/N 22-4535N5856HWaco West Inc · Dover, DEFirst renewal noticeBuilt 1949 · S/N 16-474N5856LOrland Flying Service Inc · Bunnell, FLBuilt 1972 · S/N AA5-0056N5856QDison Timothy A · Nolensville, TNS/N 3137N5856WSergeant Mary E · Harvard, ILBuilt 1965 · S/N 28-2361N5856ZHankins Jon A · Fort Mohave, AZBuilt 1963 · S/N 22-9712N58571Stanger Joseph E · Willow, AKS/N 77-45N5857LHill James III · Gainesville, FLBuilt 1972 · S/N AA5-0057N5857VHague Parkerson B · Virginia Beach, VAS/N 28-7716207N5858HKoch Michael R · Nemo, SDBuilt 1949 · S/N 16-478
Back to AD 90-04-06 R1