OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,394

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:79-10-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
  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.

N842SHSilver Star Helicopters LLC · El Campo, TXBuilt 2005 · S/N 3819N842SVPylon Aviation Services LLC · Chandler, AZBuilt 1983 · S/N 0366N842TAkin Air LLC · Monticello, ARBuilt 1960 · S/N TD-355N84309Mcgee 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-2660N84316Smith 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-2661N84326Yang 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-2662N84330Blanche-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-2664N84350Piecko Michael T · Genoa, ILBuilt 1981 · S/N 28-8290006N84351Stanton James W · Maple, NCBuilt 1969 · S/N 17258436N84352Boundless Aviation LLC · Kailua Kona, HIBuilt 1969 · S/N 17258437N84358Child Michael A · Fort Worth, TXBuilt 1969 · S/N 17258440N8435DOrbis Advisory Services LLC · Hebron, KYBuilt 1981 · S/N 28-8290001N8435EZeller Ray G · Brookings, ORBuilt 1979 · S/N 17272200N8435FRed Tail Scholarship Foundation · Tuskegee, ALBuilt 1981 · S/N 28-8290002N8435G303 LLC · Beaumont, TXBuilt 1981 · S/N 28-8290003N8435LAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 1968 · S/N 17256635N8435UMayotte Robert · Boynton Beach, FLS/N 28-8290005N84364Innovated Control Systems Inc · Watsonville, CABuilt 1981 · S/N 28-8290008N84365Abbott Troy D · Hollywood, MDBuilt 1969 · S/N 17258441N84367Martin Arthur D · New Market, VABuilt 1969 · S/N 17258442N84369Ulrich Casey M · Waldo, KSBuilt 1969 · S/N 17258444N8436JMarshall Lee C · Hartsville, SCBuilt 1981 · S/N 28-8116320N8436RRegistration Pending · Riverton, KSRegistration pending, pending cancellationBuilt 1966 · S/N 28-22316N8436TElias Akal Aviation LLC · Deering, NHBuilt 1981 · S/N 28-8116321N8436WHidalgo Robert J · El Paso, TXS/N 28-2667N8437DClark Donald S · Atlantic Beach, FLBuilt 1957 · S/N 22-5692N8437WThomas Eric D · Placerville, CABuilt 1965 · S/N 28-2668
Back to AD 79-10-03 R2