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.

N82LWMuskox Ministries · Fairbanks, AKBuilt 1973 · S/N U20602054N82MSShifflett Kenneth · Olive Branch, MSBuilt 1966 · S/N D-8108N82PHHarold Hart & Associates Inc · Tampa, FLBuilt 2005 · S/N 42082N82SAOrange Skies LLC · Falls Church, VABuilt 2004 · S/N 0902N82TAJanes Paul A · Ontario, ORBuilt 1968 · S/N 402-0156N82TRExecutive Autopilots DBA · Sacramento, CABuilt 1972 · S/N 414-0273N82UCMajesty Air Inc · Wilmington, DEBuilt 1972 · S/N TH-276N8300NErect A Tube Inc · Harvard, ILBuilt 1968 · S/N D-8719N8300QSafeco Leasing LLC · Port Alsworth, AKBuilt 1976 · S/N U20603161N8300ZWillowridge Farm · Winchester, KYBuilt 1993 · S/N EA-551N8309NNewman Michael Jay · Sherborn, MABuilt 1968 · S/N D-8720N830BJElm III Operating Company LLC · Edmond, OKBuilt 1979 · S/N 340A0738N830CCCreson John L Jr · Augusta, GABuilt 1970 · S/N TH-31N830CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2002 · S/N 0158N830SUJames John S · Perkins, OKBuilt 1978 · S/N TE-1126N830SWN830sw LLC · Valley Center, KSBuilt 1978 · S/N 18503631N830TDWhite And Blue LLC · Auburn, CABuilt 1987 · S/N E-2397N830TPValhalla Partners LLC · Atlanta, GABuilt 1984 · S/N 46-8408015N830TTThuen Douglas · Andover, NJBuilt 1972 · S/N 3400186N8310NPearson J David · Nashville, TNBuilt 1968 · S/N CE-204N8310QRaven Girl LLC · Eagle River, AKBuilt 1978 · S/N 18503650N8318NAir Power Associates LLC · O Fallon, MOBuilt 1968 · S/N D-8723N831AMSky Candy LLC · Scottsdale, AZBuilt 2005 · S/N 1578N831AZ847cx LLC · St George, UTBuilt 2001 · S/N 0003N831BMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1979 · S/N 414A0340N831CAMaurer Allen L · Akron, OHBuilt 2008 · S/N E-3874N831CDNathan Smith Ministries · Belmont, NCBuilt 2005 · S/N 1580N831GETs&L Aircraft LLC · Alexandria, MNS/N TJ-293N831JBDjd Properties LLC · Victoria, TXBuilt 1980 · S/N TJ-279N831JCLaw Office Of Jerome A Clay · Stockton, CABuilt 2003 · S/N 0546N831PRThomas Bruce A · Mount Juliet, TNS/N U20603452N831RMBarber John R Trustee · Port Orange, FLS/N E-1685N831RRFresh Farms Inc · King City, CABuilt 1986 · S/N 21064994N831SGDelahoussaye Investments LLC · Leander, TXBuilt 2003 · S/N 0647N831TAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1995 · S/N 29-0031N831WCEpic Vibes Consulting Group Lp · Princeton, NJS/N 414-0467N8321NAstle John K · Brighton, MIBuilt 1968 · S/N D-8722N8325NKontour Shawn K · Wheatland, WYBuilt 1968 · S/N D-8730N8326NLimitless Experience Inc · Middletown, DEBuilt 1968 · S/N D-8728N8328N789 Aviation LLC · Medina, OHBuilt 1968 · S/N D-8735N832HFalkenthal Robert J · Beaumont, CABuilt 1977 · S/N E-1047N832LMScherado Kenneth · Las Vegas, NVBuilt 2004 · S/N 0832N832RSHaps Shack Express LLC · Asheville, NCBuilt 1978 · S/N E-1345N833Dick David W · Roseburg, ORBuilt 1988 · S/N CE-1217N8332NMoon Kai LLC · Laguna Niguel, CABuilt 1968 · S/N D-8740N8334QVolatile Aero Ventures LLC · Boulder City, NVS/N U20603195N8335QFlying M Aviation LLC · Twin Falls, IDFirst renewal noticeBuilt 1978 · S/N 18503659N8336NDejong James D · Doon, IABuilt 1968 · S/N D-8737N8337NLivesay Gregory K · Mckinney, TXBuilt 1968 · S/N D-8739N8338HBayviewer LLC · Sarasota, FLS/N EA-399
Back to AD 86-13-04 R3