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.

N8955ZSimmons Louis Crispin · Williamsburg, VABuilt 1999 · S/N TH-1897N896TBcp Aero Operations LLC · Alpharetta, GAFirst renewal noticeBuilt 1989 · S/N CE-1341N897TRegistered aircraftBuilt 1972 · S/N D-9354N898DMMeis David Bradley · Belmont, NCS/N E-3216N898JBSalesapproach Inc · Marlborough, MABuilt 1975 · S/N E-704N898WPTriple B Aviation Inc · Idabel, OKBuilt 1990 · S/N CE-1513N899RBRoach John H · North Salem, NYBuilt 1976 · S/N CE634N899TEtherington Charles A Trustee · Vlg Loch Loyd, MOBuilt 1971 · S/N D-9297N89AUAllen Esta Ross III · Houston, TXBuilt 1987 · S/N CE-1129N89EDPage Daniel R · Raleigh, NCBuilt 1979 · S/N E-1479N89GPanousis Steve · Kennett, MOBuilt 1975 · S/N TH-616N89GTMinasian Paul Ryan Trustee · Oroville, CABuilt 1989 · S/N CE-1383N89KBJet Sense Aviation Aircraft Holdings Corp · Burlington, WIS/N EA-54N89LRA36 Gps LLC · Boone, NCBuilt 1982 · S/N E-2058N89LSCals Ltd · Harbor Springs, MIBuilt 1991 · S/N CE-1583N89PDCaleta Ventures LLC · Richmond, TXBuilt 1979 · S/N E-1554N89SGHatch Christopher L · Harpswell, MEBuilt 1989 · S/N CE-1357N89ZMDx Aviation LLC · Broken Arrow, OKBuilt 1989 · S/N CE-1413N8ADChelsea Build LLC · Brenham, TXS/N EA-359N8DPDelta Papa Aviation LLC · Wilmington, DES/N TH-1038N8FJCheap Thrills I LLC · Salida, COBuilt 1969 · S/N E-187N8FMSky Dawg LLC · Winterville, NCBuilt 1997 · S/N E-3068N8KWSigurdson Richard J · Olivia, MNBuilt 1977 · S/N D-10091N8MWHeckler Gary C · Carefree, AZBuilt 1976 · S/N D-9943N8NGRetail Contracting Group Inc · Oakdale, MNBuilt 1969 · S/N TH-19N8RFNeumann-Wheatley Farms Inc · Isabel, KSBuilt 1972 · S/N CE-366N8TMAdvanced Intelligent Computing Inc DBA · Houston, TXBuilt 1980 · S/N TJ-325N8TZTh Aero Services LLC · Leawood, KSBuilt 1983 · S/N E-2076N8URLoberg Kirk · Jonesboro, ARBuilt 1999 · S/N TH-1917N8WMBeardog Aviation LLC · Saint Augustine, FLBuilt 1977 · S/N E-1199N8WWLcam Aviation LLC · Springfield, MOBuilt 1976 · S/N TK-43N8YZFreeman William Joel · Moravian Falls, NCBuilt 1980 · S/N E1608N9001QSaransor Properties LLC · Eden Prairie, MNBuilt 1970 · S/N TH-57N9004QLuketavious Aviation LLC · Madison, MSBuilt 1970 · S/N D-9179N9006VBuckholts Texas LLC · Buckholts, TXBuilt 1969 · S/N D-9069N9007VHoster Keith DBA · Gordon, TXBuilt 1970 · S/N D-9088N9009QHanna Aviation Inc · Wheaton, ILBuilt 1970 · S/N D-9169N900AWBonanza Five Flying Club Inc · Roswell, GABuilt 1990 · S/N E-2524N900CFAxio Aviation LLC · Elmira, NYBuilt 1972 · S/N CE-382N900KBN900kb LLC · California, MDBuilt 1977 · S/N TH-863N900NXAlva Family Holdings LLC · Fort Denaud, FLBuilt 1976 · S/N TH-723N900PDV Claims LLC · Ainsworth, NEBuilt 1979 · S/N D-10195N900PMDungan Aerial Service Inc · Oro Valley, AZBuilt 1991 · S/N CE-1559N900TMRed Top Aviation Inc · Martinsville, INBuilt 1978 · S/N E-1302N900ZZ110me Inc · Lake Providence, LABuilt 1983 · S/N EA-398N9010VDrake Devin R · Senoia, GAS/N CE-324N9014VKestrel Inc · West Des Moines, IABuilt 1971 · S/N D-9290N9016VDowns Richard K · Prospect, KYBuilt 1971 · S/N E-287N9017QLong Lynn I · Van Alstyne, TXBuilt 1970 · S/N D-9171N9017VPost60 LLC · Lake Oswego, ORS/N E-274
Back to AD 87-18-06 R1