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.

N366PWEuroaviation Inc Trustee · KematenBuilt 1992 · S/N EA-530N366ZMendel Carl · Port Charlotte, FLBuilt 1975 · S/N E-769N3670EFresh-Pic Harvest Inc · La Quinta, CABuilt 1980 · S/N TK-124N3671FHenson Ronald E · Bonita Springs, FLS/N EA-94N3671MFigvam LLC · New York, NYBuilt 1980 · S/N E-1705N3673RArtie Aircraft LLC · Trenton, MOBuilt 1980 · S/N TH-1150N3673UCastor Care LLC · Mount Pleasant, SCBuilt 1980 · S/N TH-1149N3674GSudduth Ronald C · Lineville, ALBuilt 1980 · S/N TH-1151N3675RCl1 LLC · Baton Rouge, LABuilt 1980 · S/N E-1711N3675TFairbairn Stephen C · Carmel, INBuilt 1980 · S/N E-1672N36787Manairco Inc · Wooster, OHBuilt 2004 · S/N E-3587N3679ZKlein Eric · Tenino, WABuilt 1980 · S/N E-1730N367BCVc Air LLC · Midland, TXBuilt 1989 · S/N CE-1409N367BMWilliams Richard · Atlanta, GABuilt 2005 · S/N 1647N367DMarquardt James H · Warner Robins, GABuilt 1979 · S/N E-1619N367HPN367hp LLC · Aberdeen, SDBuilt 1981 · S/N E-1811N367PCReynolds Doug · Huntington, WVBuilt 2007 · S/N E-3795N3680RYatra Global LLC · Bedford, MABuilt 1980 · S/N E-1717N3680UMoughon Kirby W · Melbourne, FLBuilt 1980 · S/N E-1718N3681GRed Wolf Aviation LLC · Wilmington, DEBuilt 1980 · S/N TH-1157N36829Prime Aviation LLC · Wilmington, DEBuilt 1980 · S/N E-1720N3682ZIliamna Air Taxi Inc · Iliamna, AKBuilt 1980 · S/N TH-1159N36846Armbruster LLC · Amherst, OHBuilt 1979 · S/N 310R1600N36847Thrash Howard G II · Lubbock, TXBuilt 1980 · S/N EA-115N3684ARegistered aircraftBuilt 1980 · S/N CE-916N3684HAvex X Corp · Coral Gables, FLBuilt 1981 · S/N TE-1180N3684YBluebird Holdings LLC · Morris, MNFirst renewal noticeBuilt 1980 · S/N TJ-298N36855Aerial Digital Images LLC · Huntington Beach, CABuilt 1980 · S/N EA-117N3685WJewell Warren · Seattle, WABuilt 1980 · S/N EA-113N3685YWhite Lawrence L III · La Habra, CABuilt 1963 · S/N 21058185N36862Linville Keith · Bend, ORBuilt 1979 · S/N 310R1605N3686BBrosius John W III · Dell Rapids, SDBuilt 1962 · S/N NAV42419N36877Stilwell Aviation LLC · Stilwell, KSBuilt 1980 · S/N EA-119N36884Main Aviation Inc · Visalia, CABuilt 1980 · S/N EA-121N36885Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N 340A0681N36887Aa Aircraft Adventure LLC · Joplin, MOBuilt 1982 · S/N 414A0835N3688RMckay Christopher · Point Arena, CAS/N CE-918N3689ULeonard Robert E · Mattoon, ILBuilt 1980 · S/N E-1733N368CDSavfar Aviation Inc · Wilmington, DEBuilt 2004 · S/N 1071N368CMKraemer Jeffrey J · Cold Spring, MNBuilt 2005 · S/N 29-0368N368HPHigh Performance Aircraft Inc · El Cajon, CABuilt 1981 · S/N E-1833N368JEJones Enterprises · Nacogdoches, TXBuilt 1980 · S/N TH-1145N368JHUrsine L Attitudes Ltd · Richland, WABuilt 1981 · S/N E-1920N368POfferaire Inc · Lebanon, NJBuilt 1995 · S/N E-2942N368TPDonohue Andrew · Tulsa, OKBuilt 1973 · S/N 12039N368VKranz Daniel · Hastings, MNBuilt 1968 · S/N E-21N36900Bas Part Sales LLC · Greeley, COBuilt 1980 · S/N E-1739N36908Williams D Eric · Palm Springs, FLBuilt 1980 · S/N 402C0313N3690DR B M Corporation · Cropwell, ALBuilt 1980 · S/N TJ-306N3690NDetraglia Michael C · Canandaigua, NYBuilt 1980 · S/N EA-123
Back to AD 86-13-04 R3