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.

N825XSktr Ac LLC · Fallbrook, CABuilt 2006 · S/N 3255043N82600Hendrickson Ryan H · Gunnison, UTBuilt 1978 · S/N 18-7909013N8260NSundberg Nicholas William · Stevensville, MTBuilt 1969 · S/N 28-25472N8260VRed Rifle Aviation LLC · Richmond, TXBuilt 1980 · S/N 28-8116029N8260YNew Peach Aviation LLC · Brooks, GABuilt 1980 · S/N 28-8116031N82613Wammen Ranch Llp · Reva, SDS/N 18-7909015N82616Fisher D Bradley · Cleveland, TNBuilt 1980 · S/N 28-8011142N82617Cooper Holly B · Friendswood, TXBuilt 1978 · S/N 18-7909017N82618Lechner Burdette J · Kodiak, AKBuilt 1978 · S/N 18-7909018N82619Cherry Hill Aviation Inc · Freetown, INBuilt 1978 · S/N 18-7909019N8261HOxford Flying Club Inc · Oxford, CTBuilt 1980 · S/N 28-8190025N8261PWarzek Mary Ann · Halfmoon, NYS/N 24-3514N8261SHoffmann David M · Mauston, WIBuilt 1980 · S/N 28-8190027N8261TDoss Brothers Inc · Lawrenceburg, TNBuilt 1980 · S/N 32-8024043N8261YWilliams Brannon R · Fort Worth, TXBuilt 1966 · S/N 30-1388N82629Dgf & Associates Inc · Irving, TXS/N 28-8216225N8262ASnider Jay T · Grove City, OHBuilt 1980 · S/N 28-8116033N8262ESee Robert W · Catawba, NCBuilt 1980 · S/N 28-8190033N8262HRegistration Pending · Bucyrus, OHRegistration pendingBuilt 1980 · S/N 28-8190034N8262JHarris James D · Lasalle, COS/N VAC-108-78N8262KHesston College · Hesston, KSBuilt 1982 · S/N 28-8290165N8262N40 Flight LLC · Fernandina Beach, FLBuilt 1969 · S/N 28-25474N8262SWisconsin Aviation - Four Lakes Inc · Madison, WIBuilt 1980 · S/N 28-8190035N8262UHorton Air Ventures LLC · Eustis, FLBuilt 1980 · S/N 28-8190036N8262WCalhoun Jerry H · Washington, NCBuilt 1965 · S/N 28-2413N8262YAchamp LLC · Memphis, TNBuilt 1966 · S/N 30-1390N82631Payne Chris · Lafayette, TNBuilt 1980 · S/N 28-8111003N82634Aircraft Wings LLC · Gresham, ORBuilt 1980 · S/N 28-8111004N82635Chase 13 LLC · Wilmington, DEBuilt 1978 · S/N 18-7909024N8263EN8263e LLC · Jackson, MIS/N 32-8024046N8263JIsaacs David R · Fort Wayne, INBuilt 1978 · S/N VAC-109-78N8263NPiper Partners Mbda LLC · Fairfield, ILBuilt 1969 · S/N 28-25475N8263WViking Crown LLC · Prescott, AZBuilt 1965 · S/N 28-2414N8263ZBecker Matthew P · Covington, LABuilt 1980 · S/N 28-8111002N82644Chandler Elijah J S · Pilot Mountain, NCBuilt 1988 · S/N 0760N82646Downs Ricky R Trustee · Roundup, MTS/N 36-7760127N8264GFornwalt Paul A · Linden, PABuilt 1980 · S/N 28-8011016N8264HAir Dakota Flite Inc · Hettinger, NDBuilt 1965 · S/N 1137N8264JCouch James L · Cochran, GABuilt 1978 · S/N VAC-110-78N8264NRegistered aircraftRegistration pendingBuilt 1969 · S/N 28-25477N8264PChavez Raul M · Comanche, TXBuilt 1963 · S/N 24-3517N8264VRuby Jeffrey Steven · Sharon, SCBuilt 1980 · S/N 28-8116035N8264WEyrich Richard L · Cave Creek, AZBuilt 1965 · S/N 28-2415N8264YPatterson Casey Paul · Kinston, ALBuilt 1966 · S/N 30-1392N82654Horomanski Eugene E · Duncansville, PABuilt 1980 · S/N 32-8024048N82656Souther Field Aviation Inc · Americus, GAFirst renewal noticeBuilt 1977 · S/N 36-7760134N8265CDelgado Francisco Trustee · Carmel, INBuilt 1980 · S/N 28-8190037N8265HSlinger LLC · Laramie, WYBuilt 1980 · S/N 28-8190039N8265JConley Donald · Claude, TXBuilt 1978 · S/N VAC-111-78N8265NImmanuel Baptist Church Of Kansas City Kansas · Basehor, KSBuilt 1969 · S/N 28-25478
Back to AD 87-10-06 R1