OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,375

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.

N31MAlley Shane C · Jackson, MOS/N 188N31MSWagon Leasing LLC · Jonesboro, ARBuilt 2018 · S/N 593-2018N31PAUtter Joseph Lynn · Springfield, MOBuilt 1967 · S/N MA-132N31PCFlight World Inc · San Juan, PRBuilt 1958 · S/N 23-1349N31PEPhantom Eagle LLC · Hot Springs, VAFirst renewal noticeBuilt 1996 · S/N 14086CN31PPPlyler Aviation Lp · Sherman, TXBuilt 1969 · S/N PP-1N31RBTigre Ecossais Aviation Inc Trustee · Wilmington, DEBuilt 1975 · S/N AA5B-0156N31RWSpot Air LLC · Burlington, TXBuilt 1977 · S/N 17268693N31SN31s LLC · Wadsworth, OHBuilt 1971 · S/N 28-7205080N31SCObryant Jeffrey A · Fairbanks, AKBuilt 1967 · S/N 79N31SETangent LLC · Phoenix, AZBuilt 2005 · S/N 978-2005N31SGHamilton Enterprises Inc · Reno, NVBuilt 1996 · S/N 377-320-132-18PN31SMWings Over Texas Aviation Inc · Killeen, TXBuilt 1965 · S/N 635N31TGNaiman Nicholas A · Ramona, CABuilt 1995 · S/N TJ2-8-38GN31THNet Air Co · Monroe, MIBuilt 1979 · S/N AA5B1142N31TJAdams Ian B · Laramie, WYBuilt 2002 · S/N 60414N31TLT M L Aircraft Inc · Narrowsburg, NYS/N 28R-7235314N31UERemc Leasing LLC · Bismarck, NDBuilt 2020 · S/N 3349N31VGTita Enterprises LLC · Apex, NCBuilt 2004 · S/N 3551N31VHAmy Inc · Wilmington, DEBuilt 2005 · S/N 3966N31VSJenny Timothy J · Remsen, NYBuilt 1999 · S/N 1273-99N31VTSnediker Daniel G · Pittsburgh, PABuilt 1966 · S/N 28-3208N31VUJav Enterprises LLC · Broomfield, COBuilt 2018 · S/N 2844179N31VXGordon Charles M Trustee · Haymarket, VABuilt 2018 · S/N 00182N31WABeausoleil Robert N · Phoenix, AZBuilt 1977 · S/N 2N31WBBaker James P · Brighton, COBuilt 1995 · S/N 22470N31WFTaylor Peter L · Beaumont, TXBuilt 1999 · S/N 1461N31WGFleischman James H · Remus, MIBuilt 1990 · S/N 1951N31WKKing Wesley A · Los Angeles, CABuilt 1995 · S/N 1060N31WM3 Point Aviation LLC · Claremont, NHBuilt 2018 · S/N CC19-0027N31WTThomas Norman W · Forest, VABuilt 1980 · S/N 172RG0291N31XEverson Dustin J · Providence, RIBuilt 1992 · S/N 671-92N31YBritton Stephen D · Delhi, LABuilt 1957 · S/N TD-41N31ZRRusso R Michael · Pipersville, PABuilt 2004 · S/N 23093N32003Gem Aviation Corp · Sugar Land, TXBuilt 1974 · S/N 28-7515043N32004Priceless Pleasures LLC · Jordan, MNBuilt 1974 · S/N 28-7515044N32008K L M Aircraft Co · Media, PABuilt 1974 · S/N 28-7505014N3200BMuehl Harvey C · Macomb, MIBuilt 1954 · S/N 22-2027N3200ERegistration Pending · Burlington, WIRegistration pendingBuilt 1978 · S/N 17271466N3200GSpinner Family Limited Partnership · White City, ORBuilt 1956 · S/N 22-4042N3200MPride Jesse D · Eagle River, AKS/N 12-1872N3200RTexeira David A · Venice, FLBuilt 1969 · S/N 28R-31126N3200ZBrady Michael E · Buffalo, NYBuilt 1959 · S/N 22-7140N32019Spicher Samuel Charles · Harrisonburg, VABuilt 1974 · S/N 28-7505017N3201GArdent Aviation LLC · Salt Lake City, UTBuilt 1978 · S/N 24-0565N3201LFowler Scott A · Lakeland, FLBuilt 1978 · S/N 24-0566N3201ZMcclain William J · Corona, CABuilt 1959 · S/N 22-7141N32020N32020 LLC · Springfield, MOBuilt 1974 · S/N 28R-7535015N3202SCramer Traci · Hatfield, PABuilt 1996 · S/N 1111SN32030Robert Starr · Schofield, WIBuilt 1974 · S/N 28-7515048
Back to AD 90-04-06 R1