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.

N6328PSabath Kenneth J Trustee · Powell, WYBuilt 1978 · S/N P21000170N6328YKoehn Lacey · Van Horn, TXBuilt 1981 · S/N 21064338N6329CUnited Indian Mission DBA · Tucson, AZBuilt 1977 · S/N U20603844N6329YDiablo Aviation LLC · Pleasanton, CABuilt 1981 · S/N 21064339N632CDBirch Run Aviation LLC · Wayne, PAS/N 1641N632SRowe Paul J · Fairport, NYS/N EA-126N6330CLos Angeles County Sheriffs Department · Long Beach, CABuilt 1980 · S/N 21063866N6330KWyle Stephen · Los Angeles, CABuilt 1982 · S/N E-2030N6331SDobberfuhl Roy · Cedarburg, WIBuilt 1975 · S/N CE-618N6331YSierra Blanca Asset Management Inc · Cisco, TXS/N CE-1000N6332SHanson Steven R · Clovis, NMBuilt 1975 · S/N TE-1071N6334SHokuf Erik L · Bemidji, MNBuilt 1975 · S/N TH-702N63361Apollo Aviation Group LLC · Saint Petersburg, FLBuilt 1982 · S/N TE-1199N6336UBravo Whiskey LLC · Missoula, MTBuilt 1985 · S/N 21064937N6339CBowles Donald E Jr · Dallas, TXBuilt 1980 · S/N 21063871N633APGunter Aviation LLC · Bainbridge, GABuilt 1991 · S/N CE-1632N633BMOver The Top Cattle Co LLC · Perkinston, MSBuilt 1971 · S/N CE-357N633CDPolaris Fire Protection Inc · Port Charlotte, FLBuilt 2002 · S/N 0369N633CKScherczinger Richard · Mooresville, NCBuilt 1989 · S/N CE-1395N633GEFly High LLC · Seminole, TXS/N 1487N6344YCole William G · Garner, NCBuilt 1981 · S/N 21064344N6345ZAerial Transport LLC · Dover, DEBuilt 1981 · S/N U20606246N6346UN6346u LLC · Pleasant Hill, CABuilt 1982 · S/N EA-278N6349UAirmann LLC · Mount Sterling, KYBuilt 1982 · S/N EA-281N634MGeorge Mike J · Springfield, ILBuilt 1955 · S/N G-761N634WSun South Of Jennings LLC · Jennings, LABuilt 2002 · S/N 0164N6351XGilles David L · Clifton, TXS/N TH-1312N6353UBas Part Sales LLC · Greeley, COBuilt 1985 · S/N 21064941N6355CDutch Air LLC · Kalispell, MTBuilt 1980 · S/N 21063874N6356TTangoair LLC · Birmingham, ALBuilt 1981 · S/N CE-933N6357XMaanum Scott R · Park Rapids, MNBuilt 1980 · S/N U20605863N6358SStancil Joseph E Jr · Eagle River, AKBuilt 1982 · S/N U20606557N6359BRoss Stout Architect Inc · Indian Wells, CABuilt 1978 · S/N 21062749N6359WScarlett Cameron O · Madison, WIBuilt 1981 · S/N P21000757N635APLambert Kurt P · Albuquerque, NMBuilt 1974 · S/N D-9674N635MAAirswiss Inc · Wilmington, DES/N 402C0634N635PGJ3 Aviation LLC · Conway, ARBuilt 2005 · S/N TH-2125N635PPBodor Geza S · Denver, COBuilt 1967 · S/N D-8637N635SAGrellet-Aumont Pierre A · East Quogue, NYBuilt 2000 · S/N E-3336N635VSun Up Farm LLC · Nacogdoches, TXBuilt 1966 · S/N D-8083N6361CMaples Lee Trustee · Belle, MOBuilt 1982 · S/N D-10384N6362AMillican Clifford A · Burleson, TXBuilt 1979 · S/N 21063523N6364BKgnf LLC · Grenada, MSBuilt 1978 · S/N 21062750N6364CSukhakarta Rentals LLC · Cedar Park, TXBuilt 1980 · S/N 21063875N6365UPino Carlos R · Santa Fe, NMBuilt 1985 · S/N 21064944N636BERios Ralph · Chester, VABuilt 1992 · S/N E-2687N636BTWestwind Digital Corp · Mahwah, NJBuilt 1972 · S/N 340-0168N636CPurcell Dave M · Bowling Green, KYBuilt 2002 · S/N 0406N636CHHr Hoss LLC · Roanoke, TXBuilt 2008 · S/N E-3859N636EAdams Aerial Solutions LLC · Decatur, ILBuilt 1978 · S/N E-1262
Back to AD 86-13-04 R3