OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,010

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:87-10-06-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
  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.

N584KButterfield Rory A · Milan, NMBuilt 1975 · S/N 584N584LLawver William A · Panama City, FLBuilt 1972 · S/N AA5-0084N584LKTipton William M · Burlington, NCBuilt 1999 · S/N 103MN584LMTiede Russell James · Miami, AZBuilt 2003 · S/N 70171N584LQAir Shares LLC · Casper, WYBuilt 2005 · S/N 18281600N584RVFelix Leonard D Jr · Salome, AZS/N 587N584SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881403N584SFDsr Cherokee 180 LLC · Dallas, TXBuilt 1968 · S/N 17256834N584SPTexas State Technical College At Waco · Waco, TXBuilt 2000 · S/N 172S8511N5850LXeus Inc · Nottingham, PABuilt 1972 · S/N AA5-0050N5850PInto The Forest Equipment LLC · Placerville, CABuilt 1959 · S/N 24-932N5850QMcmoran Donald W · Mount Vernon, WAS/N 3134N5850UMarfair LLC · Freeport, TXBuilt 1970 · S/N 28-26681N5850WCaside Aviation LLC · Brooklyn, NYBuilt 1965 · S/N 28-2296N5851DRubbert Lorin E · Reynolds, NDBuilt 1956 · S/N 22-4530N5851LOretsky Philip H · South Haven, MIBuilt 1972 · S/N AA5-0051N5851UFoothill Aircraft Sales & Service Inc · Upland, CABuilt 1969 · S/N 28-26683N5851VMcconnell Thomas E · Grass Valley, CABuilt 1977 · S/N 28-7715273N5851WCameron Hugh R · Gainesboro, TNBuilt 1965 · S/N 28-2308N5852LOhser David G · Hudson, FLBuilt 1972 · S/N AA5-0052N5852QOldham Jared K · Richfield, WIBuilt 1965 · S/N 3135N5852WFerguson Carl R · Waupaca, WIBuilt 1965 · S/N 28-2312N5853DHapka Leon J · Halma, MNBuilt 1956 · S/N 22-4532N5853LKennedy Samuel E · Watsonville, CABuilt 1972 · S/N AA5-0053N5853PLewellen Walter G · Moreno Valley, CABuilt 1959 · S/N 24-935N5853UPost Jay M · Greenfield, OHBuilt 1970 · S/N 28-26685N5854DPro West Air LLC · West Point, UTS/N 22-4533N5854FBravo Sierra LLC · Middletown, DES/N 32R-7780021N5854LVolpe Brandon M · Baton Rouge, LABuilt 1972 · S/N AA5-0254N5854NShort Brian D · Rock Island, ILBuilt 1978 · S/N 14399N5854UMagic Valley Aero Club Inc · Twin Falls, IDBuilt 1970 · S/N 28-26686N5854WAtluas LLC · Dallas, TXBuilt 1965 · S/N 28-2333N5855DMiller Justin · Boaz, ALBuilt 1956 · S/N 22-4534N5855HNortheast Cub LLC · Hudson, NYS/N 16-473N5855LSchauf Cindy R · Colwich, KSBuilt 1972 · S/N AA5-0055N5855WZachry David · West Point, GABuilt 1965 · S/N 28-2358N5856DStephen George · Land O Lakes, WIBuilt 1956 · S/N 22-4535N5856LOrland Flying Service Inc · Bunnell, FLBuilt 1972 · S/N AA5-0056N5856PDemontalvo Aaron M · Mansfield, TXBuilt 1959 · S/N 24-938N5856QDison Timothy A · Nolensville, TNS/N 3137N5856WSergeant Mary E · Harvard, ILBuilt 1965 · S/N 28-2361N5857LHill James III · Gainesville, FLBuilt 1972 · S/N AA5-0057N5857VHague Parkerson B · Virginia Beach, VAS/N 28-7716207N5858WPaulisin George W · Crossville, TNBuilt 1965 · S/N 28-2368N5859NPegasus Flight LLC · Carbondale, ILS/N 14404N5859PSnider Scott E · Turner, MTBuilt 1959 · S/N 24-941N5859QHill Larry J · Idaho Falls, IDBuilt 1965 · S/N 795N5859VHaney Paul · Navarre, FLBuilt 1977 · S/N 28-7790504N585AMPj Aviation LLC · Richmond Hill, GABuilt 2005 · S/N 18281585N585AWChristiansen Aviation LLC · Wilmington, DEBuilt 2017 · S/N 2843934
Back to AD 87-10-06 R1