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.

N5348VKavon Clinreg LLC · Palm Beach Gardens, FLBuilt 1980 · S/N 172RG0511N53491Crossbrook LLC · Willoughby, OHBuilt 1981 · S/N 17274764N53494Gandarillas Andrew J · Toledo, WABuilt 1981 · S/N 17274765N5349DFisher Randall A · Salem, OHBuilt 1979 · S/N 17272537N5349LHart Brad S · Elephant Butte, NMS/N 28-4652N534FLGray Gary G · Kansas City, MOBuilt 1971 · S/N 28-7125364N534MPJones David C · Williston, VTBuilt 1991 · S/N 10066N534WCPrenter Christian E · Hermosa Beach, CABuilt 2002 · S/N 60473N53507Flight School Of Gwinnett · Lawrenceville, GABuilt 1981 · S/N 17274769N5350KCenterline Aviation LLC · Oklahoma City, OKBuilt 1980 · S/N 17274076N5350LN5350l LLC · Statesville, NCFirst renewal noticeBuilt 1968 · S/N 28-4653N5351Robinson Herb · Snowflake, AZBuilt 1997 · S/N 073N5351HHayes Jeffery M · Yatesville, GABuilt 1975 · S/N 17265411N5351QBarrett Dannie P · Halfway, ORS/N 17261778N5352LStinson Jonathan L · Douglas, GABuilt 1968 · S/N 28-4655N5352WRegistration Pending · Newton, ALRegistration pending, pending cancellationBuilt 1962 · S/N 28-413N5353FAllegany Aviation LLC · Tonawanda, NYBuilt 1976 · S/N 28-7790096N5353KCentury Air Inc · Fairfield, NJBuilt 1980 · S/N 17274078N5353WYeager Brian · Locust Grove, GABuilt 1962 · S/N 28-416N53540Orlando Aero Club Inc · Orlando, FLBuilt 1981 · S/N 17274776N53541Ps N53541 LLC · Green Bay, WIBuilt 1981 · S/N 17274777N5354DGonzalez Alejandro B · El Paso, TXBuilt 1979 · S/N 17272540N5354NPinnacle Aviation Services Inc · Encinitas, CABuilt 2002 · S/N 4496160N5355LSeward Joe T Jr · Fairmount, INBuilt 1968 · S/N 28-4658N5356DDethlefs Robert L · Clackamas, ORBuilt 1979 · S/N 17272541N5356FFly By Knight Inc · Hammond, LANon-citizen corporation, flight hours not reportedBuilt 1976 · S/N 28-7715107N5356LLehuta Steven C · Brunswick, OHBuilt 1968 · S/N 28-4659N5356UAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2002 · S/N 4496164N5356WMahler Alex · Fayetteville, ARBuilt 1962 · S/N 28-420N5356XSkywest Leasing Inc · St George, UTS/N 2843521N5356YMoore Aviation Inc · Beaver Falls, PABuilt 2002 · S/N 2843528N53571George Michael F · Ferndale, WABuilt 1981 · S/N 17274781N5357DYadair Inc · Lauderdale Lakes, FLBuilt 2002 · S/N 2843537N5357EHoffman Dennis M · Winchester, VABuilt 1978 · S/N 17271840N5357JArizona Bravo Lima LLC · Phoenix, AZBuilt 1980 · S/N 17273762N5357WJones Michael A · Greer, SCBuilt 1962 · S/N 28-421N5357XFirn Line Aviation Inc · Wasilla, AKS/N 18-7391N53588Davis Charles · Sanford, FLBuilt 1981 · S/N 17274782N5358DXin Han Aviation LLC · Atwater, CABuilt 1979 · S/N 17272543N5358LTwidwell Jon J · Olathe, KSS/N 28-4661N5358PWilliams George A · Bonifay, FLBuilt 1958 · S/N 24-306N5359FWashington Fliers Club Inc · Washington, IABuilt 1976 · S/N 28-7790098N5359LFirst Flight Corp · San Diego, CABuilt 1968 · S/N 28-4663N53600Kdrd Holdings LLC · Texas City, TXS/N 17272544N53603Wings Over Texas Holdings LLC · Denton, TXBuilt 1981 · S/N 17274786N5360JFly Montana LLC · Miles City, MTBuilt 1980 · S/N 17273763N5360LKitzmiller Peter Charles · Seattle, WAS/N 28-4664N5360WShaffer Thomas D · Round Rock, TXS/N 28-425N53611Aero Mobil Inc · Wilmington, DEBuilt 1981 · S/N 17274787N5361KLong Island Soaring Association · Shirley, NYBuilt 1980 · S/N 17274080
Back to AD 79-10-03 R2