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.

N6688YHolt Kyle · Cottontown, TNBuilt 1979 · S/N EA-47N66896Diesbach Benjamin · Cincinnati, OHBuilt 1979 · S/N E-1623N6689JAce Technical Services LLC · Hernando, MSBuilt 1979 · S/N D-10321N6689NMoore Christopher J · Mebane, NCBuilt 1979 · S/N E-1622N6689VSchafer Daniel B J · Plainview, TXBuilt 1967 · S/N 30039N668DB686 Aviation LLC · Lakewood, COBuilt 1975 · S/N 21061003N668DESteele Kevin · Phoenix, AZBuilt 1983 · S/N EA363N668JGCapps Steven M · Mount Pleasant, TXBuilt 1999 · S/N E3266N668ZSDrumwright Gerald L · Ormond Beach, FLBuilt 1979 · S/N D-10258N66907Flynn Curtis J · Granbury, TXBuilt 1979 · S/N D-10322N6690GKey Lime Real Estate Inc · Lutz, FLBuilt 1979 · S/N E-1625N6690YThree Green LLC · Towanda, KSBuilt 1979 · S/N E-1627N66913Mp Air LLC · Stonewall, LABuilt 1979 · S/N E-1631N66916Technet Aviation LLC · Charlotte, MIS/N D-10327N66918Lbc1 LLC · Mount Olive, NCBuilt 1980 · S/N TH-1104N66919Gta Air Inc · Addison, TXBuilt 1979 · S/N E-1634N66928International Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N E-1628N6692RToga LLC · Scottsdale, AZBuilt 1980 · S/N EA-55N66932Worstell Kris D · Gordonville, TXBuilt 1979 · S/N E-1630N6694NGear Down LLC · Dalhart, TXBuilt 1978 · S/N 21063150N6694VNieting James · Minnetonka, MNBuilt 1967 · S/N 30012N6695DExtrusions Inc · Fort Scott, KSBuilt 1980 · S/N E-1657N6695HMegan Anderson Nursing Services Inc · Yucaipa, CABuilt 1980 · S/N D-10343N6695NJosselyn David A · Riverside, CABuilt 1979 · S/N CE-895N6696DMayfly Aviation LLC · Quincy, FLBuilt 1980 · S/N E-1636N6696VMccollough William B · Murrells Inlet, SCS/N 30008N6696WClift William R II · Princeton, KYBuilt 1980 · S/N D-10329N6696YAlcri Inc · Lewes, DES/N E-1639N6696ZMonahans Affordable Homes LLC · Monahans, TXBuilt 1980 · S/N EA-56N6697VCleveland Lorne T · Tyler, TXS/N 30006N669CSAir Seven LLC · Independence, OHBuilt 2015 · S/N TH-2445N669JMMerrell Bros Aviation LLC · Kokomo, INBuilt 1980 · S/N 340A0971N669RPFanning William J · Dallas, TXBuilt 1979 · S/N E-1618N66ABCallis Jerrod G · California, KYBuilt 1969 · S/N CE-292N66AFSalmon Steven B · Liberty, MOBuilt 1980 · S/N TH1132N66BLLemon Bryant William Jr · Albuquerque, NMBuilt 1981 · S/N 185-04175N66BTTrazer LLC · Parkland, FLBuilt 1964 · S/N 21058437N66CEM&S Real Estate Management Inc · Granbury, TXS/N 21061391N66CLLiberty Eagle LLC · Helena, MTBuilt 1980 · S/N 421C1019N66DFClark Samuel D Trustee · Wilson, WYBuilt 1977 · S/N 210-621-41N66DHKingsbury Raymond S · Farmington, MNS/N 320E0041N66DRInternational Air Services Inc Trustee · Carson City, NVBuilt 1966 · S/N CE-47N66EE3cgs LLC · Santa Barbara, CABuilt 1967 · S/N CD-1132N66ELSutter Ernest · The Woodlands, TXBuilt 2004 · S/N L2K-244N66GAAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1980 · S/N 20700657N66HBSawtooth Travel Solutions LLC · Twin Falls, IDBuilt 1976 · S/N E-888N66HSAlbertson Jon E · Helena, MTBuilt 1973 · S/N 73-30595N66JLLucia Joanne · Agawam, MABuilt 1975 · S/N E-711N66KDEnalp Investments LLC · Metairie, LABuilt 2003 · S/N E-3505N66KWPeavy Michael J Trustee · Chico, CAS/N CE-948
Back to AD 86-13-04 R3