OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,495

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.

N75GBPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1975 · S/N 402B0912N75GLSkyshare LLC · Boulder, COBuilt 1973 · S/N 21059814N75HPN5949s LLC · Hereford, TXBuilt 1984 · S/N EA-415N75LBL & A Bennett Second Family Lp · Renton, WABuilt 2001 · S/N 40014N75LGMarr Lance · Portland, ORBuilt 1978 · S/N P21000015N75MGJupiter Am-18 LLC · Red Lodge, MTBuilt 2003 · S/N 0657N75PJJohnson Peter G · Tower, MNBuilt 1975 · S/N U20602705N75PVPvr Construction LLC · Wilmington, DEBuilt 2018 · S/N E-4116N75RCJoffe Zalman · Bahama, NCBuilt 1981 · S/N 21064325N75RMDodson International Parts Inc · Rantoul, KSS/N EA-402N75SAGoldbeck Aviation LLC · Columbus, INBuilt 2004 · S/N 0955N75SKRick Broke Entertainment LLC · Conyers, GABuilt 1974 · S/N 421B0646N75SSMurdock Kent A · Roll, AZBuilt 1963 · S/N D-7140N75TH24c LLC · Edmond, OKBuilt 2022 · S/N E-4147N75VRSlt Global Alliances LLC · Las Vegas, NVBuilt 1979 · S/N P21000429N75YAHayes David M · Edgewood, TXBuilt 1965 · S/N 21058665N75ZMC & S Aviation · Roswell, GABuilt 2004 · S/N 1045N7600NKeller Douglas O · West Linn, ORBuilt 1977 · S/N U20603704N7601NIndustrial Maintenance Inc · Pryor, OKS/N E-68N7603NBucher John R · Rch Palos Vr, CABuilt 1968 · S/N E-71N7604NFriedman David B · Martinez, CABuilt 1968 · S/N E-72N7605URyan Air Inc · Anchorage, AKBuilt 1978 · S/N 20700443N7607NBonn Aire LLC · Henderson, NVBuilt 1968 · S/N E-76N7609NPro X Aviation Services LLC · Anderson, INFirst renewal noticeBuilt 1969 · S/N TE-747N7609QPierson Janice R Trustee · Scio, ORBuilt 1978 · S/N 18503626N760CDInternational Air Services Inc Trustee · Carson City, NVBuilt 2001 · S/N 0084N760CHWilliamson Jimmy · Lake Havasu City, AZS/N LK2-146N760PHopper Marvin · Farmerville, LABuilt 2004 · S/N 0988N760RMAircraft Partner Holdings Inc Trustee · BerlinBuilt 1975 · S/N 414-0815N760THKingwood Aviation LLC · Hermosa Beach, CABuilt 2007 · S/N E-3800N7610CSawtooth Flying Service Inc · Mccall, IDBuilt 1977 · S/N U20603924N7610MEickhoff Steven M · Fountain, MNBuilt 1977 · S/N 21062030N7610NHarrison Danny L · Byrdstown, TNBuilt 1968 · S/N TC-1137N7613NN7613n LLC · Lewes, DEBuilt 1968 · S/N TE-613N7615NHelms Aviation Inc · Long Lake, NYBuilt 1977 · S/N U20603706N76185Snell Marion Lea · Ackerly, TXS/N 18503013N761AFranz Construction Inc · Sidney, MTS/N 18504424N761AGChalk 2 Inc · Apple Valley, CABuilt 1977 · S/N 21062097N761AKHub Properties Ltd · Wilmington, DEBuilt 1977 · S/N 21062100N761ALPacific Valley Aviation Inc · Arbuckle, CABuilt 1977 · S/N 21062101N761AMGood Enuf LLC · Wilmington, DEBuilt 1977 · S/N 21062102N761ANWinger Cattle Company Inc · Johnson, KSBuilt 1977 · S/N 21062103N761AQOrangesocks Aviation LLC · Chesterland, OHBuilt 1977 · S/N 21062105N761BDRockwell Richard E · Aledo, TXBuilt 1977 · S/N 21062118N761BEAnderson Kristian L · Albuquerque, NMBuilt 1981 · S/N P21000660N761BLLong Ernest D · Trabuco Canyon, CABuilt 1977 · S/N 21062125N761BVN761bv LLC · Sioux Falls, SDBuilt 1977 · S/N 21062134N761BYB&E Leasing LLC · Dubuque, IABuilt 1977 · S/N 21062137N761BZAltair Aircraft LLC · Gainesville, FLBuilt 1977 · S/N 21062138N761CTudo Bem Aviation LLC · Austin, TXS/N 0429
Back to AD 86-13-04 R3