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.

N912LFFarmer Thomas E Jr · Galveston, TXBuilt 1974 · S/N D-9617N912MH James & Sons Inc · Fennimore, WIBuilt 2001 · S/N E-3379N912SCCrest Five Associates Inc · Breinigsville, PABuilt 1991 · S/N TH-1646N912WTNew Tech Construction LLC · Wilmington, DEBuilt 1977 · S/N 340A0353N9131QTanlin LLC · Chicago, ILBuilt 1987 · S/N 4608082N9131XWomack Equipment Leasing LLC · Terre Haute, INBuilt 1987 · S/N 4608083N91324Hasty Benjamin R Jr · Lynn Haven, FLBuilt 1997 · S/N 29-0119N9132BAijaz Ahsan · Dallas, TXBuilt 1995 · S/N 29-0062N9133GConsolidated Consulting Inc · Norfolk, NEBuilt 1988 · S/N 4608111N9133SWebster Eric M · Two Rivers, WIS/N CE-647N9133VPlane Fun Inc Tr Trustee · Snellville, GABuilt 1988 · S/N 4608112N9134SDaytona Aircraft Services Inc · Daytona Beach, FLS/N TH-726N9135SChelette Garry · Chicago, ILBuilt 1976 · S/N D-9874N9136QBeech 9136q Charter Aircraft LLC · Chico, CABuilt 1970 · S/N E-248N9136SProctor Racing Group LLC · Glendora, CABuilt 1976 · S/N E-844N9137QSam Tyson Builders Inc · Monroe, NCFirst renewal noticeBuilt 1970 · S/N D-9233N9137SCiontea James C · Santa Barbara, CABuilt 1976 · S/N E-820N9138GTlc Flying Inc · Colfax, WABuilt 1973 · S/N 18801390N9138SRegistered aircraftBuilt 1976 · S/N D-9860N9139QBollings Avionics LLC · Bristol, TNBuilt 1970 · S/N E-249N913ADPatriot Freight LLC · Pewaukee, WIBuilt 2005 · S/N 1520N913BTOutnumbered Pilot LLC · Spanish Fork, UTBuilt 2005 · S/N 1271N913CNLone Tree Island Aviation LLC · Winter Park, FLBuilt 2004 · S/N 1217N913GTParow Frederickb · Elizabethtown, PABuilt 2004 · S/N 1030N913KMBlack Edward C · Orange, CABuilt 1979 · S/N CE-892N913KSPlane Fun Inc Tr Trustee · Snellville, GABuilt 2006 · S/N 29-0423N913LCDgbaviation LLC · Amarillo, TXBuilt 2007 · S/N E-3801N913MTD & D Aviation Holdings LLC · Chelsea, ALBuilt 2005 · S/N 1597N913QWA Parrotte'S View In Flight LLC · Wilmington, DEBuilt 1991 · S/N CE-1602N913SEHill Capital Leasing LLC · Phoenix, AZBuilt 1978 · S/N P21000038N9140QTonka Seaplanes LLC · Minnetonka, MNBuilt 1971 · S/N D-9235N9140STregellas Tim E · Aledo, TXBuilt 1976 · S/N D-9861N9141QBear Air LLC · Elizabeth City, NCBuilt 1970 · S/N CE-317N9141SZuckerman Charles J Trustee · San Diego, CABuilt 1976 · S/N CE-632N9142QLamb Christopher A · Perry, OKBuilt 1971 · S/N CE-338N9143QCarlson Jeffrey K · Lake Stevens, WAS/N D-9236N9144MRobertson James D · Liberty, MOBuilt 1977 · S/N 21062065N9144QN9144q LLC · Brooklyn, NYBuilt 1970 · S/N E-250N9145QWest Thomas P Jr · Bridgeport, OHBuilt 1971 · S/N TE-834N9146MJc Aircraft Leasing LLC · Wasilla, AKBuilt 1970 · S/N U20601546N9146RZoll Ross H · Glen Allen, VABuilt 1988 · S/N 4608138N9149MBoynton Scott E · Campbell Hall, NYBuilt 1970 · S/N U20601549N914BSSchwartzman Blake R · Las Vegas, NVBuilt 1991 · S/N CE-1579N914STAir Ex LLC · Chelan, WABuilt 1980 · S/N 18504010N914TLThomas Michael · Scott City, KSBuilt 2004 · S/N 1142N915Ramsey Brent C · Tulsa, OKBuilt 1980 · S/N 340A0910N9150MSkyler Aviation Inc · San Diego, CABuilt 1970 · S/N U20601550N9152QSlama Karl · Mission Viejo, CAS/N 30-0010N9153QHansing Frederick Christopher · Moorpark, CABuilt 1970 · S/N D-9239N9154QBuck Air LLC · Dover, DEBuilt 1971 · S/N CE-318
Back to AD 86-13-04 R3