OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,396

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.

N737ZGDuck Air LLC · Mooresville, NCBuilt 1977 · S/N 17269797N737ZJLazy Eights Holdings LLC · Greenwood, INBuilt 1977 · S/N 17269799N737ZKAk Fly Inc · Kasilof, AKBuilt 1977 · S/N 17269800N737ZNEquinoxx Flight Systems LLC · Lawrenceville, GABuilt 1977 · S/N 17269803N737ZPJahawk Leasing LLC · Sugar Grove, ILBuilt 1977 · S/N 17269804N737ZRTennessee Seaplane Company LLC · Knoxville, TNBuilt 1977 · S/N 17269806N737ZTEdwards Ronald R · Clinton, ARBuilt 1977 · S/N 17269808N737ZVJax Aero LLC · Jacksonville, FLBuilt 1977 · S/N 17269810N737ZWS & S Aviation Co · Ball Ground, GAS/N 17269811N73800Soul Aviation LLC · Newport Beach, CABuilt 1976 · S/N 17267690N73808Delta Aviation Inc · Monticello, MNBuilt 1976 · S/N 17267691N7380DKirby Robert H · Hallsville, TXBuilt 1957 · S/N 18-5745N7380GOrlandi Properties LLC · Blairstown, NJBuilt 1970 · S/N 17259080N7380JBednarek Michael H · Centerville, OHBuilt 1968 · S/N 28-24742N7380WRohlfes David M · Newcastle, CABuilt 1963 · S/N 28-1263N73813Smoot Russell L · Louisville, KYBuilt 1976 · S/N 17267693N73816Nedved Aviation LLC · Mitchell, SDBuilt 1976 · S/N 17267696N73819Botter Marlene S Trustee · Kent, WABuilt 1976 · S/N 17267699N7381SSeitz Anthony Wayne · Heppner, ORBuilt 2012 · S/N 2090N7381WTogliatti Robert A · Lakewood, OHBuilt 1963 · S/N 28-1265N7382DSchneider Aerial Inc · Rugby, NDBuilt 1957 · S/N 18-5747N7382JMinor Air LLC · Joplin, MOS/N 28-24744N7382PAir Jav Aviation · Paso Robles, CAS/N 24-2592N73830Asbury Paul G · Charleston, TNBuilt 1976 · S/N 17267706N73837Bloomex Aviation LLC · Montvale, NJS/N 17267711N7383JCox Jakori Akeem · Las Vegas, NVBuilt 1968 · S/N 28-24745N7383WRed Rock Flying School LLC · Mesa, AZBuilt 1963 · S/N 28-1267N73846Bernstein Matthew D · North Charleston, SCBuilt 1976 · S/N 17267717N73848Dorson Daniel J · Eden Prairie, MNBuilt 1976 · S/N 17267719N7384DSteinbrecher Kevin · North Pole, AKS/N 18-5749N7384EFierman Jo Angela · Madison, GABuilt 1978 · S/N 17272100N7384WRader Kyle L · Hutto, TXBuilt 1963 · S/N 28-1268N73852Carrion Jesus · Staten Island, NYBuilt 1976 · S/N 17267721N73855Dury Aviation Services Inc · Portage Des Sioux, MOBuilt 1976 · S/N 17267723N7385JGardner Chuck R · Estherville, IABuilt 1968 · S/N 28-24747N73864Martz Richard W · Alta Loma, CABuilt 1976 · S/N 17267729N73868Ca Aero LLC · Fairfield, NJBuilt 1976 · S/N 17267730N7386GCrosswind Flyers Inc · Newton, NJBuilt 1970 · S/N 17259086N7386KAffiliated Equipment Leasing LLC · New Castle, DEBuilt 1950 · S/N 20-295N7387DTodd Doug G · Brainerd, MNBuilt 1957 · S/N 18-5752N7387EKiefhaber Thomas R · Cincinnati, OHBuilt 1978 · S/N 17272101N7387GSale Reported · Redondo Beach, CASale reportedBuilt 1970 · S/N 17259087N7388DParcel James H · Anchorage, AKS/N 18-5753N7388MLange Marc B · Spokane Valley, WABuilt 1958 · S/N 55688N7388WLiebsack Steven G · Torrance, CABuilt 1966 · S/N 28-3757N73895Osprey Holding Co LLC · Foley, ALBuilt 1976 · S/N 17267734N73898Con Moto Aviation LLC · Hemet, CABuilt 1976 · S/N 17267735N73899Hill Randall S · Lodi, WIBuilt 1976 · S/N 17267736N7389KBiek Jacob A · Onsted, MIS/N 20-298N7389WMcnulty Ian M · Willis, TXS/N 28-1274
Back to AD 79-10-03 R2