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.

N86AWMohave County Sheriff'S Office · Kingman, AZBuilt 1978 · S/N 414A0040N86BVMila Air LLC · Cincinnati, OHBuilt 1991 · S/N CE-1582N86CDBri Mar Aviation Corp · New Britain, CTBuilt 1997 · S/N E-3145N86DHHolloway'S Tire And Auto Service Inc · Thomaston, GABuilt 1984 · S/N 21064832N86JKMartin Christopher M · Mount Vernon, OHBuilt 2003 · S/N 0525N86KSouthwest Aircraft LLC · Fairacres, NMBuilt 1968 · S/N NAV-4-2517N86MESutherland Jason · Auburn, WABuilt 1999 · S/N E-3285N86MTWhite Knuckles Aviation LLC · Carson City, NVBuilt 1980 · S/N P21000533N86NXQuinn Dana S Trustee · East Harwich, MABuilt 2002 · S/N 0236N86PDTanric Aviation LLC · Tuscola, TXBuilt 1982 · S/N 414A0837N86PRAdams Bob L · Chugiak, AKBuilt 1977 · S/N 18503281N86SSAerobanc Of America Inc · Camarillo, CABuilt 1977 · S/N 18503334N86TEBowers Stephen W · Richland, MIS/N D-10342N86VSPlotkin Aviation LLC · Boca Raton, FLS/N 414-0955N86WBHarris Michael G · New Orleans, LABuilt 2004 · S/N 1173N8700ZBergh Gene H · Roberts, WIBuilt 1975 · S/N 18502896N8702KSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 340A0623N8702ZSutton Aircraft Salvage LLC · Palmer, AKBuilt 1975 · S/N 18502897N8703ZLynch Cody Ryan · Galveston, TXBuilt 1968 · S/N P206-0503N8704ZHunt David H · Ortonville, MIBuilt 1968 · S/N P206-0504N8706ZElliott Michael L · Raeford, NCBuilt 1968 · S/N P206-0506N8707KDelaware Corp · Topping, VAS/N 340A0982N870CDZugski LLC · Nederland, COBuilt 2002 · S/N 0305N870EALandmark Air LLC · Tampa, FLBuilt 2013 · S/N E-4008N870FSLindsey Norman A · Richardson, TXBuilt 1987 · S/N 4608051N870UOhio University · Albany, OHBuilt 2002 · S/N TH-2036N870VLCaribbean Flyers LLC · San Juan, PRBuilt 1981 · S/N 402C0616N8710QMicro Tool Inc · Idaho Falls, IDFirst renewal noticeBuilt 1980 · S/N U20605641N8710ZBurnham Kenneth J · Carr, COBuilt 1975 · S/N 18502899N8711KGraham Thomas R · Bonita Springs, FLS/N 340A0627N8711ZNeff John Sr · Lumberton, TXBuilt 1968 · S/N P206-0511N8712KKirkmeyer Thomas · Kimberly, IDBuilt 1978 · S/N 340A0628N8715ZMarconi Joseph · Hamilton, OHBuilt 1968 · S/N P206-0515N8717QState Of Alaska · Nome, AKBuilt 1979 · S/N 18503757N8717ZBoucher Kenneth G · Scotland, CTBuilt 1975 · S/N 18502901N87199Moss Herman D · Centreville, VABuilt 1975 · S/N 310R0298N8719ZFedane Rohit · Green Bay, WIBuilt 1968 · S/N P206-0519N871ANWnd Aircraft Management LLC · Miami, FLBuilt 1993 · S/N TH-1678N871JBAas Baron LLC · Houston, TXS/N TH-2038N871TXNlmds Leasing LLC · Tierra Verde, FLBuilt 2006 · S/N 29-0449N871VLZee Enterprise Inc · Chicago, ILBuilt 1980 · S/N 402C0290N87205Redskin Aviation LLC · Kalispell, MTS/N 310R0301N87208Heredia Rafael · Miami, FLBuilt 1975 · S/N 310R0302N8720KZielinski John P · Queen Creek, AZBuilt 1978 · S/N 340A0631N8720YEmpire Rental & Leasing Inc · Eden, NCBuilt 1991 · S/N CE-1555N87221Chester Darren Dw · Sioux Falls, SDS/N 310R0306N8722QPrice Scott · Eagle Point, ORBuilt 1979 · S/N 18503758N8725QN8725q LLC · Grand Junction, COBuilt 1976 · S/N U20603478N8725ZRomine George · Tucson, AZBuilt 1968 · S/N P206-0525N8727387273 LLC · Reno, NVBuilt 1975 · S/N 310R0330
Back to AD 86-13-04 R3