OpenAirDocs.org
AD 87-18-06 R1

Registered aircraft · 6,238

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-18-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-18-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.

N77YEHaagenson Trevor O Trustee · Carnelian Bay, CABuilt 1975 · S/N TE-1074N77YTN77yt LLC · New Canaan, CTBuilt 1979 · S/N EA-10N7800YH&H Aviation Of Oklahoma LLC · Oklahoma City, OKBuilt 1978 · S/N D-10072N780YPack Larry L · Grand Blanc, MIBuilt 1978 · S/N TH-935N781LDKeane James P · West Islip, NYBuilt 1978 · S/N D-10132N781WCOak And Pine Ranch LLC · Kalispell, MTBuilt 1987 · S/N CE-1156N7835VRoney John P · Charlotte, NCBuilt 1978 · S/N D-10155N783JR13 Aviation LLC · Chelan, WABuilt 1979 · S/N TJ-231N783TMElliott Frank A · Oxford, MSBuilt 1973 · S/N D-9489N7858PRegistered aircraftBuilt 1978 · S/N TJ-183N785SRitchie Race Scott · Odessa, TXS/N EA-334N786TSTurnquist Paul Sr · Lincoln, MEBuilt 1976 · S/N E-901N7878YKujanski Jon G Trustee · Saint Charles, ILBuilt 1991 · S/N CE-1563N787CCMegaship Ventures LLC · Baytown, TXBuilt 1985 · S/N TH-1490N787JKMark M Jackson Do LLC · Sarasota, FLS/N E-1159N787JVRegistered aircraftBuilt 1977 · S/N D-10082N787LLDouglas Aviation Ltd · South Barrington, ILS/N CE-1182N787MRMoon Aviation LLC · Oklahoma City, OKBuilt 1997 · S/N E-3144N787RMJohnson Plane Services · Greenbrier, TNBuilt 1993 · S/N CE-1719N7888SHangar One Lc · Clear Lake, IABuilt 1989 · S/N CE-1368N788CF3w Group Inc · Hot Springs, ARBuilt 1977 · S/N TH-870N788KRegistered aircraftBuilt 1977 · S/N D-9992N789FMRadio Flyer LLC · Fox Point, WIBuilt 2000 · S/N EA-652N789JArr Planes LLC · Chattanooga, TNBuilt 1984 · S/N E-2145N789PZWalters Aviation Group LLC · San Diego, CABuilt 1984 · S/N TH-1424N789RGBonanza N789rg LLC · Oro Valley, AZBuilt 1973 · S/N D-9483N789SLRoye Bart Laine · Slaton, TXBuilt 1975 · S/N TJ-12N78BCMastin William · Fort Worth, TXBuilt 1989 · S/N EA-499N78BEHappy Planes LLC · Boyertown, PABuilt 1978 · S/N E-1178N78BFSandbar Air LLC · Saint Petersburg, FLBuilt 1972 · S/N E-331N78DBGreenbrier Aviation LLC · Sevierville, TNBuilt 1980 · S/N TH-1152N78GGSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1977 · S/N CE-699N78GWCbs Aviation LLC · Jackson, MSBuilt 1978 · S/N E-1351N78HFFiorentini Henry · Lincolnshire, ILBuilt 1979 · S/N CE-887N78KGClayton Donald D · Sugar Land, TXBuilt 1975 · S/N E-643N78KKJim Heck Investments LLC · Findlay, OHBuilt 1977 · S/N D-10075N78KLNea Industrial LLC · Paragould, ARBuilt 1990 · S/N TH-1578N78PHFlorida Topsoil Inc · Jacksonville, FLBuilt 1986 · S/N CE-1100N78REKhg Aircraft Inc · Peachtree City, GAS/N TH-371N78RSSkorpiks Inc · Tyndall, SDBuilt 1980 · S/N D-10360N78UMDenver Air Support Inc · Englewood, COS/N TJ-84N78VCBb58 LLC · Greenville, MSBuilt 1995 · S/N TH-1743N78WHDel Rosi Anthony J · Key Largo, FLBuilt 1978 · S/N D-10145N78WWPark Avenue Group Inc · Stuart, FLBuilt 1995 · S/N TH-1747N7905RFlaherty Ryan J · Scottsdale, AZBuilt 1970 · S/N E-230N791AABonanza Paradise LLC · Queen Creek, AZBuilt 1979 · S/N E-1609N7920MWirt John P · Lake Havasu City, AZBuilt 1980 · S/N E-1714N792JHElgee Aviation LLC · Fairfield, NJBuilt 2001 · S/N TH-1988N7935HBaker Clark V · College Station, TXBuilt 1992 · S/N CE-1640N7936ABb Air Guys LLC · Scott City, KSBuilt 1978 · S/N E-1421
Back to AD 87-18-06 R1