OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,497

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.

N7283RUltra Motorsports II · Boerne, TXBuilt 1974 · S/N E-630N7286RHulands Gregory G · Eagle Point, ORS/N D-9724N7287RTailwinds Inc · Norwalk, IAS/N E-637N728CTBerns Ridge Service LLC · Whittier, CABuilt 1982 · S/N 340A1533N728DSTebeaux William Jene · College Station, TXBuilt 1986 · S/N 4608047N728FRRoyal Air Freight Inc · Waterford, MIBuilt 1977 · S/N 310R1248N728HSBdr Aviation LLC · Oklahoma City, OKBuilt 2008 · S/N TH-2215N728RHBearce Kristin Priscilla · Kissimmee, FLBuilt 1988 · S/N CE-1212N728VAero Research LLC · Kalispell, MTBuilt 1975 · S/N E-641N728VPLkc Holdings Inc · Dover, DEBuilt 1978 · S/N 18503614N7293RAir New England LLC · Portsmouth, NHBuilt 1975 · S/N TH-590N72947Greer Glenn M · Eugene, ORBuilt 1972 · S/N 18800947N7298RWhite Barry · Runaway Bay, TXBuilt 1975 · S/N CE-557N7299RLindeman Russell L DBA · D Hanis, TXBuilt 1975 · S/N E-648N729CDOmega Skyways LLC · North Bethesda, MDBuilt 2001 · S/N 0025N729CWWright Matthew J · Bowling Green, OHBuilt 1987 · S/N E-2390N729LHHillis Aviation LLC · Poplar Bluff, MOBuilt 2026 · S/N TH-2552N729MRFlanagan Brian F · Roseville, CAS/N 29-0017N729TJurskis Chester · Dallas, TXBuilt 1964 · S/N D-7690N72ALQuigley Partick M · Slidell, LABuilt 1968 · S/N TE-584N72AVAvalair Aircraft Management LLC · Brookshire, TXBuilt 1977 · S/N E-1093N72BGRegistration Pending · Farmingdale, NYRegistration pendingBuilt 1981 · S/N TE-1198N72BKUpper Airways LLC · Kalispell, MTBuilt 2002 · S/N 0172N72BRPrestige Air Travel · Middletown, DES/N E-2065N72CGGarvin Carroll E · Scottsdale, AZBuilt 1980 · S/N TJ-264N72CUKuhlke K Lee · Englewood, COBuilt 2001 · S/N EA-673N72DTMalibu Aviation Inc · Wichita, KSBuilt 1985 · S/N 46-8508084N72GPWade Joseph R · Mindoro, WIBuilt 1968 · S/N E-59N72JAOtter Air LLC · Fishers, INBuilt 1979 · S/N 414A0333N72JESkyward LLC · Fort Smith, ARBuilt 2005 · S/N 1654N72JVMatrix Commerce Solutions LLC · Point Pleasant Bch, NJBuilt 2000 · S/N 05N72KGM & P Aviation LLC · Byhalia, MSBuilt 1980 · S/N 414A0513N72LEBarbee Mark E · Cody, WYBuilt 2015 · S/N L2K-175N72LRSchnell Michael L · Spearman, TXBuilt 2001 · S/N EA-676N72MBSwenson Chuck · Stanchfield, MNBuilt 1977 · S/N E-1010N72MDBenanti Philip E · Melville, NYFirst renewal noticeBuilt 1977 · S/N E-1149N72PTInverted Holdings LLC · Newnan, GAFirst renewal noticeBuilt 1973 · S/N TH-381N72PVBowman Theodore R · Santa Ynez, CABuilt 1988 · S/N E-2452N72SCLsa Aircraft Holdings LLC · Houston, TXBuilt 1984 · S/N TJ-477N72TFLeuthner Roger B · Albuquerque, NMBuilt 1999 · S/N 29-0195N72VTNot Enuf LLC · Jackson, WYBuilt 1979 · S/N 340A0654N7300VAmerican Air Sentinel Inc · Columbus, OHS/N 30155N7301BFowler Kenneth R · Cleveland, ALBuilt 1954 · S/N D-3765N7301RSwanson Naomi L · Dalton, GAS/N 6-92RMN7302RBurns James P DBA · Plainview, ILBuilt 1974 · S/N TH-472N73036Johnson Deborah K · Fairbanks, AKBuilt 1979 · S/N 20700555N7303NJordan James D · Paradise, TXBuilt 1979 · S/N 21063218N73047Spernak Airways Inc · Anchorage, AKFirst renewal noticeBuilt 1979 · S/N 20700556N7304NCoastal Aviation Export LLC · Wilmington, DEBuilt 1976 · S/N U20603607N7304VMeese Nathan C · Irving, TXBuilt 1969 · S/N 30159
Back to AD 86-13-04 R3