OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,497

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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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.

N43DAAero Management Holdings LLC · Hot Springs, ARBuilt 1976 · S/N 340A0112N43DBMuller Michael C · Peachtree City, GABuilt 1968 · S/N TE-617N43DW10-4 Aviation LLC · Waco, TXBuilt 1974 · S/N 310R0135N43FMBaseline Digital Inc · Satellite Beach, FLBuilt 1998 · S/N 29-0139N43HPBarbara Aviation Inc · Middletown, DEBuilt 1977 · S/N TH-885N43HWPiper Nicholas W · Nanjemoy, MDBuilt 2000 · S/N 29-0259N43KBNeves John Herbert Jr · Livermore, CAS/N 2N43KTTowles Michael D · Corona Del Mar, CABuilt 1993 · S/N E-2808N43KYPinto Carlos Eduardo · Tucson, AZBuilt 1972 · S/N 21059563N43MEEvans Matthew B · Granbury, TXBuilt 1978 · S/N P21000046N43MRFlight Contract Services Inc · Las Vegas, NVS/N 414A-0016N43QCAviation LLC · Kalispell, MTBuilt 1984 · S/N TJ-467N43YIsbell Edwin Chad · Spring, TXBuilt 1974 · S/N E-576N4402JBruton Paul · El Campo, TXBuilt 1980 · S/N T18803736TN4405AJohnson Marvin E · Garfield, WABuilt 1970 · S/N D-9141N4407RRhyneer Loren S · Anchorage, AKBuilt 1976 · S/N 18502946N440BETextron Aviation Inc · Wichita, KSBuilt 2015 · S/N TH-2440N440CDN440cd LLC · Williamsburg, VABuilt 2005 · S/N 1515N440DDeeble Kenneth M · Dayton, MTBuilt 1964 · S/N D-7461N440DL421 Partners LLC · Crown Point, INBuilt 1983 · S/N 421C1401N440GVon Pasecky Ronald · Gilbert, AZBuilt 1976 · S/N D-9911N440LJByington William · Minden, NVS/N 421C0299N440LWBig Dawg Air LLC · Ringgold, GABuilt 2013 · S/N E-4016N440QB&T Aviation LLC · Columbia, SCBuilt 1964 · S/N D-7410N440SUFutrell Kenneth R · New Smyrna Beach, FLBuilt 1977 · S/N E-1115N440TJs Aviation Group LLC · Sedona, AZBuilt 1976 · S/N CE-681N4410TLavin Gregory S · Chugiak, AKBuilt 1982 · S/N 18504335N4412QWoods Flying Service LLC · Memphis, MOBuilt 1971 · S/N 18800812N4414RKirk Ledoux · Stanwood, WABuilt 1979 · S/N U20605111N4417WReyling Joseph E · Glasgow, MTBuilt 1974 · S/N E-529N4418ABorchert Pete · Prescott, AZBuilt 1970 · S/N D-9142N4419AMccants Robley D · Mesa, AZS/N D-9147N441GWEugetech LLC · Bettendorf, IABuilt 2004 · S/N 1060N441TPUnited Contractors Inc · Costa Mesa, CABuilt 1978 · S/N 414A0057N441TTSunbird Airlines Inc · San Juan, PRBuilt 1981 · S/N 402C0441N441WW4kd Corporation · Wilmington, DEBuilt 1975 · S/N CE-606N4421RJ & B Aircraft Leasing LLC · Lufkin, TXBuilt 1985 · S/N 46-8508051N4422NValiair Lc Trustee · Casper, WYBuilt 1978 · S/N P21000099N4427WRockwall LLC · Wye Mills, MDBuilt 1974 · S/N D-9605N4428CPayne Jeffrey C Trustee · Stockton, CABuilt 1980 · S/N EA-59N4429LShingebiss LLC · Independence, ORBuilt 1982 · S/N 21064647N442AKKelly Aviation Inc · Tampa, FLBuilt 1977 · S/N 310R0984N442CCRaymond Andrew A · Crescent, IAS/N 414A0483N442FMHogan Quinn H Trustee · Milwaukee, WIBuilt 1979 · S/N 414A0303N442GRAk Air Leasing LLC · Homer, AKBuilt 1972 · S/N U20601811N442PTAutodealersonly.Com Inc · Brunswick, GABuilt 1999 · S/N 30-0018N442RGRivas Andrew · Flagstaff, AZBuilt 1990 · S/N CE-1437N442RWRobertson David · Cullman, ALS/N TE-885N442SSN442ss LLC · Middletown, OHBuilt 1965 · S/N P206-0121N442TTQualitair LLC Trustee · MichelstadtBuilt 2004 · S/N 1012
Back to AD 86-13-04 R3