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.

N19ECSerra Decca Company LLC · Seattle, WABuilt 1967 · S/N 185-1306N19FBWojnicki Chester · Mt Prospect, ILBuilt 1976 · S/N 21061668N19KYChi Yang · Lafayette, COS/N TE-1073N19LBSanders Brian L · Tehachapi, CABuilt 1982 · S/N 21064705N19LLDsr-Cherokee 180 LLC · Dallas, TXBuilt 1970 · S/N E-224N19LPZelta LLC · Wilmington, DEBuilt 2016 · S/N TH-2473N19MAAvco Security Systems Inc · Jupiter, FLBuilt 1966 · S/N D-8173N19MJCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N U20605372N19MNShields Charles F · Gilberts, ILBuilt 1978 · S/N E-1347N19MTDaviation Inc · Willoughby, OHBuilt 1976 · S/N E798N19PMFlying Turtle LLC · Carmel, INBuilt 2022 · S/N 9027N19QTInternational Aviation Group LLC · Lake Wales, FLBuilt 2003 · S/N 0593N19RAAviatzone LLC · Fort Lauderdale, FLS/N TK-44N19REEtcheverry Ray L · Bakersfield, CABuilt 1970 · S/N CE-299N19RFLynn Air Flying Club Inc · Woodinville, WABuilt 1974 · S/N E-627N19SASierra Aviation LLC · Hendersonville, TNBuilt 1980 · S/N E-1795N19SLMifflin Enterprises LLC · Mansfield, OHBuilt 1976 · S/N D-9848N19TLHall Kurt D · Fort Lauderdale, FLBuilt 1975 · S/N U20602629N19WCV35a LLC · Beacon, NYBuilt 1969 · S/N D-8998N19YLegacy Air Holdings LLC · Helena, MTBuilt 2003 · S/N L2K-193N1BDFloyds Aero Inc · Amarillo, TXS/N G-91N1BFRussell Kellum LLC · Saratoga, CABuilt 1973 · S/N TE-961N1CKWilson Nick · Glenwood, ILBuilt 1966 · S/N CE-30N1CNNothing By Chance LLC · Jackson, WYBuilt 1967 · S/N TE-313N1CSMoseley Ailsa · Wellington, FLBuilt 1946 · S/N NAV-4-106N1DJOwyhee Air LLC · Murphy, IDBuilt 1987 · S/N CE-1116N1EVGainesville Aircraft Sales Inc · Gainesville, FLBuilt 1979 · S/N E-1463N1EZLexthistle Enterprises LLC · Sunset, LABuilt 2007 · S/N L2K-426N1FHBuermann Henry · Brookfield, VTS/N 18052817N1GQAero Attack Systems (USA) Inc · Blaine, WANon-citizen corporation, flight hours not reportedBuilt 1972 · S/N 421B0236N1JJChrapczynski Daniel T · Sheffield Village, OHBuilt 1972 · S/N 30461N1KPSherman Loren R Jr · Granbury, TXBuilt 1973 · S/N 21060006N1KVParagon Aviation LLC · Greenland, NHFirst renewal noticeBuilt 2003 · S/N 40063N1KYCatherines Aviation Services LLC · Sewanee, TNBuilt 1968 · S/N CJ-3N1LQStrydom Cornelis F · Liberal, KSBuilt 1966 · S/N T210-0148N1LVMcarthur Thomas M · Annapolis, MDBuilt 1966 · S/N CE15N1LXDix Justin T · South Boston, VABuilt 1973 · S/N E-419N1MFWise Christopher J · Plano, TXS/N TH-835N1MQGc4 Aero LLC · Birmingham, ALBuilt 1976 · S/N TH-731N1PHRegistered aircraftBuilt 1983 · S/N CE-1018N1PZRegistered aircraftBuilt 1972 · S/N TE-890N1QGLos Arboles Management Company LLC · Moriarty, NMBuilt 1966 · S/N D-8328N1QMAhlhorn Travis W · New Braunfels, TXBuilt 1979 · S/N 421C0701N1RMMeggers Roger D · Baker, MTBuilt 1975 · S/N 18502686N1RTFrost Darrell G · Atlanta, TXBuilt 1966 · S/N TE-185N1SBHattan John A · Goddard, KSBuilt 1974 · S/N 18502377N1SKWienhoff Kevin Bruce · Salem, ORS/N D-9339N1TZHundredaire LLC · Wichita, KSBuilt 2008 · S/N E-3830N1UZJet X Leasing Inc · Johnson, KSBuilt 1964 · S/N D-7420N1VZKilian Michael S · Morrow, OHBuilt 1979 · S/N E-1491
Back to AD 86-13-04 R3