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.

N9019SSky Master LLC · Blue Earth, MNS/N D-7949N901CSMarco Steven S · Atlanta, GABuilt 1990 · S/N CE-1477N901FJN901fj LLC · Miami, FLBuilt 1974 · S/N D-9657N901TCBoho LLC · Lewes, DEBuilt 1993 · S/N CE-1737N9020VCartwright David F · Menomonee Falls, WIBuilt 1969 · S/N TE-768N9021V9021 LLC · Sheridan, WYS/N TH-233N9022QHeading 360 LLC · Safford, AZBuilt 1970 · S/N CE-309N9022SWalker April M · Keller, TXBuilt 1965 · S/N D-7950N9022VBlu Dog Aviation LLC · Greenwich, NYBuilt 1971 · S/N E-276N9023QRegistered aircraftBuilt 1970 · S/N TH-68N9023STwo Wings LLC · Pierre, SDBuilt 1965 · S/N D-7951N9024VMinick Allen R · Beatrice, NEBuilt 1971 · S/N TE-837N9026MGlenn Stephen B · Texarkana, TXBuilt 1977 · S/N 21062051N902ATAbet · Freeport, MEBuilt 1991 · S/N E2623N902BAEcho Charlie LLC · Manvel, NDBuilt 1979 · S/N 414A-0324N9030RWilliams Transportation LLC · St Paul, MNBuilt 1967 · S/N 185-1244N9032MWillke Theodore Lawrence II · Tacoma, WAS/N 21062052N9033FMarshall Randy M · Dallas, TXBuilt 1990 · S/N CE-1456N9033QDavid E Weissman · San Diego, CABuilt 1970 · S/N D-9208N9034SMcnurlin Thomas C · Tucson, AZBuilt 1965 · S/N D-7960N9034VVanderhoof Consulting LLC · Omaha, NEBuilt 1972 · S/N E-368N9035QBrown Vintage Airlines LLC · Mansfield, OHBuilt 1970 · S/N CE-310N9036MChalk 2 Inc · Apple Valley, CABuilt 1977 · S/N 21062053N9036VRobbins Ethan · North Grafton, MABuilt 1970 · S/N E-233N9039VCarper Paul · Conroe, TXBuilt 1973 · S/N E-391N903ATEga Three LLC · Gadsden, TNBuilt 1991 · S/N E2627N903CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0047N903DSMooney Bird LLC · Wilmington, DEBuilt 2006 · S/N 29-0421N903RMSmith Jordan · Athens, ALBuilt 2004 · S/N 0903N903VCrawford Carlos G · Osprey, FLBuilt 1974 · S/N E-562N9041CAlexander Stephen L · Sugar Land, TXBuilt 1977 · S/N D-10096N9041SMarzich Frank M · Rockford, ILBuilt 1965 · S/N D-7963N9041VSera Adam J · New Market, MDS/N CE-429N9042STruly Ted · Sherman, TXBuilt 1965 · S/N D-7964N9042W42w LLC · Jackson, MOBuilt 1974 · S/N E-605N9044SAshby Peter L Sr · Cadillac, MIBuilt 1965 · S/N D-7941N9044VThomas Richard D · Orange City, FLBuilt 1972 · S/N TH-216N9045QJohnson Steven F · Ennis, TXBuilt 1970 · S/N E-231N9046FCenturion Aviation LLC · Lewes, DEBuilt 1979 · S/N 210-63014N9048QNogle And Black Aviation Inc · Champaign, ILBuilt 1970 · S/N D-9189N9048SWienke Maximillian Martin · Sheppard Afb, TXBuilt 1966 · S/N D-8035N9049GSmokey Bay Air Inc · Homer, AKBuilt 1977 · S/N U20603795N904ADNorth South Aviation LLC · Belgrade Lakes, MEBuilt 1974 · S/N E-624N904ATBeitler Jonathan J · Camden, MEBuilt 1991 · S/N E2629N904MMKane Alan · Pinehurst, NCBuilt 2005 · S/N 29-0396N904STAir Alpes Services Corp · Wilmington, DEBuilt 2005 · S/N 1473N9050SPense Jeff · Jenks, OKBuilt 1965 · S/N D-8038N9053QOrville Ventures LLC · Leawood, KSBuilt 1970 · S/N D-9196N9056MGlasscock David M · Matthews, NCBuilt 1977 · S/N 21062055N9056SKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1978 · S/N E-1301
Back to AD 86-13-04 R3