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.

N59ABates Roger · Palm Beach Gardens, FLBuilt 1978 · S/N 21062509N59AJBird Dog Aircraft LLC · Billings, MTBuilt 1981 · S/N 18504158N59CMCalled To Care Residential Facility LLC · Goodyear, AZBuilt 1979 · S/N E-1377N59CTTornado Alley Turbo Inc · Ada, OKBuilt 1980 · S/N E-1719N59DHMay Bernard A · Medina, OHBuilt 1968 · S/N D-8891N59EMFletcher Marvin L · Fargo, NDBuilt 1984 · S/N 46-8508022N59FMCallison Rodney J · Tucson, AZBuilt 1999 · S/N 29-0177N59GMBerry Frank C · Watkinsville, GABuilt 1981 · S/N CE-964N59HMBaron International Ventures LLC · West Palm Beach, FLBuilt 1975 · S/N TH-635N59JBAero Buelo LLC · Jasper, TXBuilt 1982 · S/N E-2045N59KJSpike LLC · Cheyenne, WYBuilt 1993 · S/N EA-549N59MMPlane Fun Inc Tr Trustee · Snellville, GABuilt 2003 · S/N 42004N59PJTad Holdings LLC · Little Falls, MNBuilt 1987 · S/N E-2395N59SBLearson LLC · Tarpon Springs, FLBuilt 2002 · S/N 0196N59VKVk Health Investment Corp · Guaynabo, PRBuilt 2008 · S/N E-3833N59WAAdventist World Aviation Inc · Wilson, NCBuilt 1975 · S/N U20602958N5ALSchapansky Justin · Mount Airy, GABuilt 1973 · S/N TH-356N5AMTexas La Flyers LLC · West Monroe, LAFirst renewal noticeBuilt 1979 · S/N 414A0441N5BPTippettsolutions LLC · Fort Mill, SCBuilt 1980 · S/N TJ-315N5BZBad Bird LLC · Elon, NCBuilt 1975 · S/N TH-662N5CGSamair LLC · Blackshear, GABuilt 1979 · S/N 340A0751N5CHHartshorn William T · Tucson, AZBuilt 1968 · S/N 421-0113N5CKPhlyx Aviation · Edgewater, MDS/N D-9693N5CNLewis Gentry Holdings LLC · Orlando, FLBuilt 1978 · S/N 414A0073N5CXGumar Sherko A · Scottsdale, AZBuilt 1975 · S/N 310R0224N5DCSturges Jason Charles · Phoenix, AZBuilt 1976 · S/N E-887N5DJMyers Bradley J · Madisonville, KYBuilt 1974 · S/N 21060399N5DLAmerson Loyd Scott · Douglas, GABuilt 1979 · S/N E-1515N5EA310 LLC · Conover, NCBuilt 1975 · S/N U20602711N5ERMill Direct Textiles LLC · Rollinsford, NHBuilt 1982 · S/N T30300137N5FWWord Forrest R · San Antonio, TXBuilt 1979 · S/N TE-1167N5GKPacific Air Investments LLC · Paso Robles, CABuilt 1975 · S/N D-9831N5GWJayne John E · Hanover, NHBuilt 1987 · S/N CE1197N5HCPut A Lid On It Palm Beach Inc · Jupiter, FLBuilt 1972 · S/N D-9347N5JKLizard Two LLC · Wilmington, DEBuilt 1981 · S/N TJ-295N5KMB & B Aviation LLC · Vineyard, UTBuilt 2003 · S/N 0458N5MKTysam Aero LLC · Graford, TXBuilt 2002 · S/N 0329N5NMNelson Jeffrey S · Darby, MTBuilt 1978 · S/N 414A0042N5NNRkgrier LLC · Beckley, WVS/N 421C0446N5PAFinal Design Group LLC · Hurricane, UTBuilt 1981 · S/N EA-251N5QBPayne Thomas H · Tulsa, OKBuilt 1979 · S/N D-10246N5QETroutman Shawn L · Johnson, KSS/N 15N5SSterling David M · El Cajon, CABuilt 2006 · S/N 222N5SVPlane Metrics LLC · Fort Worth, TXBuilt 2000 · S/N LIV-375N5VThompson James A · Fleming Island, FLBuilt 1969 · S/N D-8914N5VAVirginia Department Of Aviation · Richmond, VABuilt 1976 · S/N U20603223N5VBCustom Fire Apparatus Inc · Osceola, WIBuilt 1980 · S/N TE-1179N5VLLange Vladimir · Santa Ana, CABuilt 1979 · S/N D-10223N5WADenver Timothy Arthur · Gardnerville, NVBuilt 1973 · S/N TE-903N5WFMociva Inc · Del Mar, CABuilt 1994 · S/N E-2892
Back to AD 86-13-04 R3