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.

N5939SBrown Boy Aviation · Royal City, WABuilt 1966 · S/N D-8147N593RAMakonnen Iyob · Atlanta, GABuilt 1981 · S/N TH-1307N5941SSkarco LLC · Burlington, COBuilt 1966 · S/N D-8143N5947FGulf Coast Aviation LLC · Terra Ceia, FLBuilt 1967 · S/N 21058947N5947SStewart Edgar Alan · Glennallen, AKBuilt 1973 · S/N 18502169N5948F5c1 Ltd · Boerne, TXBuilt 1967 · S/N 21058948N5949FRead Travis E · Lumberton, TXBuilt 1967 · S/N 21058949N5949MSnflk Leasing LLC · Andrews, TXBuilt 1972 · S/N 421B0319N594BVJmak Corp · Seymour, TNBuilt 1978 · S/N 340A0440N594DSJsb Aviation LLC · Harrison, ARBuilt 1980 · S/N TJ-318N5952FRedmon David M · Biloxi, MSBuilt 1967 · S/N 21058952N5953Air Traders LLC · Fayetteville, ARBuilt 2003 · S/N 0641N5953FKnickerbocker Thomas C · Houston, TXS/N 21058953N5956XCox David F · Tucson, AZS/N 21058956N595ASCowan Andrew T · Lucas, TXBuilt 2004 · S/N 1105N595CFGraham Aviation LLC · The Villages, FLBuilt 2012 · S/N TH-2346N595JMSkedaddle Air Corp · Lincoln, MABuilt 2003 · S/N 0706N595JSCsk Aviation Partners LLC · Fort Smith, ARBuilt 2017 · S/N TH-2493N595LTN595lt LLC · Edwards, COS/N P21000008N595RWCarlgren Jenson E F · Santa Fe, NMBuilt 2005 · S/N 29-0349N595TVGephart Dan R · West Lafayette, INBuilt 2003 · S/N 0485N595WLeading Edge Ventures LLC · Pompano Beach, FLBuilt 1991 · S/N CE-1557N595XXHolladay Logan · Salt Lake City, UTFirst renewal noticeBuilt 1979 · S/N TJ-189N5962MKitov Resources Corp · Shorewood, WIS/N 421B0205N5967MN5967m LLC · Chantilly, VAS/N 421B0210N5969FBowles Walter Rolando Martinez · Naples, FLBuilt 1967 · S/N 21058969N596CDBlue Developments LLC · Wilmington, DEBuilt 2005 · S/N 1710N596DSN596ds LLC · Omaha, NEBuilt 2007 · S/N E-3806N596TWaggoner Scott T · Indn Hbr Bch, FLBuilt 1967 · S/N D-8445N5975JFreeland Christopher G · Brownwood, TXS/N 414-0028N597CDGarnreiter Michael Trustee · Silverado, CABuilt 2005 · S/N 1532N597TDan Howard Aircraft Sales LLC · Tulsa, OKBuilt 1967 · S/N TE-353N597THTlh Air LLC · New Castle, DEBuilt 1997 · S/N LIV-302N5981BCollins Gordon Lee Jr · Knoxville, TNBuilt 1980 · S/N E-1776N5982FCharles James Brown · Littlefield, TXS/N 21058982N5984FFct Aviation LLC · Portales, NMBuilt 1968 · S/N 21058984N5986FBingham Darold R · Idaho Falls, IDBuilt 1968 · S/N 21058986N5987GSchwend Brian · Forsyth, MTBuilt 1973 · S/N 18801166N5988MSaltzer Eric · Somerton, AZBuilt 1972 · S/N 421B0231N598ABBrynelsen Charles R · North Oaks, MNBuilt 1976 · S/N 18503136N598ASAssociated Auction & Liquidation Co · Clarksburg, TNBuilt 1984 · S/N 414A1003N598CDKabaet Aviation Charter LLC · Tarrytown, NYBuilt 2005 · S/N 1653N598DMAirswiss Inc · Wilmington, DEBuilt 1979 · S/N 402C0114N598GB598gb LLC · Lufkin, TXBuilt 2013 · S/N TH-2386N598TMeakins Shawn P · Orono, MNBuilt 1967 · S/N D-8388N5996FL M W Leasing · Midlothian, TXBuilt 1968 · S/N 21058996N5996MMedcare Emergency Medical Services Inc · Mcallen, TXBuilt 1972 · S/N 421B0334N599DSShy Darrell · Ventura, CABuilt 1967 · S/N CE-182N599PMCirrus Maximus LLC · Pasadena, CABuilt 2004 · S/N 1246N599WB7r Leasing LLC · Wilmington, DEBuilt 1988 · S/N CE-1272
Back to AD 86-13-04 R3