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.

N842ACSummit Aeronautics LLC · Dania, FLFirst renewal noticeBuilt 1999 · S/N 842-99N842BJMaster Trade LLC · Detroit, MIBuilt 1977 · S/N 28-7716252N842CSSomerville James P · Anchorage, AKBuilt 1992 · S/N 670-92N842DBBrons Lawrence C · Canby, ORBuilt 2019 · S/N 70689N842DKDemiris William P · Westbrook, CTBuilt 2005 · S/N 81317N842DMCapps Steven M · Mount Pleasant, TXBuilt 1998 · S/N 18280161N842DTNxair LLC · Ridgeway, SCBuilt 2011 · S/N 82839N842JMRegistration Pending · Penngrove, CARegistration pendingS/N 480-29N842KZPowell Michael Brandon · Murfreesboro, TNBuilt 1983 · S/N M-2367N842LBBlair Lynward E · Headland, ALBuilt 1976 · S/N 252-76N842LPJet Air Inc · Iowa City, IABuilt 2001 · S/N 172S8842N842NEPringle Greg S · Sandy, UTBuilt 2010 · S/N 82637N842PTTemple Peter L · Harrisville, NHBuilt 2022 · S/N 67PN842RBLowcountry Flight LLC · Johns Island, SCBuilt 1969 · S/N 17258377N842SHSilver Star Helicopters LLC · El Campo, TXBuilt 2005 · S/N 3819N842SPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2001 · S/N 172S8747N842SVPylon Aviation Services LLC · Chandler, AZBuilt 1983 · S/N 0366N842TAkin Air LLC · Monticello, ARBuilt 1960 · S/N TD-355N842WSplit Oak Contracting Inc · Williamson, GABuilt 2001 · S/N 80813N84309Mcgee David · West Monroe, LABuilt 1969 · S/N 17258417N8430DBottorff Marshall B · Kimberling City, MOBuilt 1957 · S/N 22-5685N8430RRegistration Pending · Calera, OKRegistration pendingBuilt 1966 · S/N 28-22309N8430WZuber Thomas P · Opelika, ALBuilt 1965 · S/N 28-2660N8430YDavid Litteken · Aviston, ILBuilt 1967 · S/N 30-1588N84316Smith Jimmy C · Plano, TXBuilt 1969 · S/N 17258419N84317Waco West Inc · Dover, DEBuilt 1969 · S/N 17258420N8431LDsr Cherokee 180 LLC · Dallas, TXS/N 17256631N8431WAhearn Bernard Francis · Farmington, NHS/N 28-2661N8431YN8431y LLC · Coatesville, INBuilt 1967 · S/N 30-1589N8432Himsl Vincent S · Mattawa, WABuilt 2008 · S/N 80296N84326Yang Edward E · Killeen, TXBuilt 1981 · S/N 28-8116313N8432CEmpire Aviation · Oxford, NCBuilt 1976 · S/N 28-7625117N8432LAster Labs Inc · Shoreview, MNBuilt 1968 · S/N 17256632N8432WBinek Darwin P · Midlothian, TXBuilt 1965 · S/N 28-2662N8432YTaylor Kyle F · Enterprise, ALBuilt 1967 · S/N 30-1591N84330Blanche-Caron Elie P · Palmer, AKBuilt 1969 · S/N 17258421N84332Engler Jerry J · Kerrville, TXBuilt 1969 · S/N 17258422N84333Backup Enterprises LLC · Conway Springs, KSBuilt 1969 · S/N 17258423N84338Jrh Wings LLC · Alva, OKS/N 17258426N84339Burnt Pond Aero LLC · Ostrander, OHBuilt 1969 · S/N 17258427N8433LHeacock Jeffrey A · Hollis, MEBuilt 1968 · S/N 17256633N8433RRichards Riley · Seattle, WABuilt 1966 · S/N 28-22313N8433WKilduff James L · Wellsboro, PABuilt 1965 · S/N 28-2663N84342Choate Aviation LLC · Summerville, SCBuilt 1969 · S/N 17258429N84346Registration Pending · New Derry, PARegistration pendingS/N 17258433N84347Giovannini Marco · Malibu, CABuilt 1969 · S/N 17258434N8434DAllen Clifford R · Indianapolis, INBuilt 1957 · S/N 22-5689N8434LMemmi Charles D · Three Springs, PABuilt 1968 · S/N 17256634N8434RPeoples John R Jr · Hixson, TNS/N 28-22314N8434WAlpha-One Air Service LLC · Concord, NCBuilt 1965 · S/N 28-2664
Back to AD 90-04-06 R1