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.

N6728LHancock Aircraft Sales LLC · Baton Rouge, LAS/N TH-1095N6728RRegency Horizons Group LLC · Middletown, DEBuilt 1983 · S/N EA-380N6728YDashdale Aviation LLC · Fort Dodge, IABuilt 1980 · S/N D-10330N6728ZMccrorie LLC · Helena, MTBuilt 1980 · S/N EA-57N67290Price Edward Rollins Vii · Elon, NCBuilt 1980 · S/N TH-1108N6729RDfo Dynamic Aviation LLC · Glendale, AZBuilt 1966 · S/N T210-0129N6729ZMiddle Tennessee Aircraft Services LLC · Mount Pleasant, TNBuilt 1980 · S/N TH-1109N672CDRegistered aircraftBuilt 2004 · S/N 1207N672HBValiair Ltd Co Trustee · Casper, WYBuilt 1977 · S/N 340A0324N6731RHaidlen Ford Inc · Oakdale, CABuilt 1980 · S/N D-10331N6731ZJerry Slough Aviation LLC · Bakersfield, CAFirst renewal noticeBuilt 1980 · S/N TJ-255N6732ROregonian Flying Club · Wilmington, DEBuilt 1966 · S/N T210-0132N6732ZAir Pear LLC · Yakima, WAS/N E-1647N6733BWallace Scott D · Fairfield, CAS/N CE-919N6733MWilson Lawrence J · West Sacramento, CABuilt 1979 · S/N EA-37N6733YThormann Braulio Federico Cosme · Hollis Hills, NYBuilt 1980 · S/N CE-927N67343Gray Reece Allen · Buna, TXBuilt 1980 · S/N E-1649N6734UR E Bentz Inc · Monroe, LAS/N TK-117N6734XGood Deal Charlie Inc · Russellville, ARBuilt 1980 · S/N TH-1116N67352Ascension Aviation LLC · Gaylord, MIBuilt 1979 · S/N TH-1098N67353Registered aircraftBuilt 1983 · S/N E-2105N6735MJenks John W · Marlton, NJBuilt 1977 · S/N 21061987N6735ZGta Air Inc · Addison, TXBuilt 1979 · S/N E-1605N6736GKough Bryan · Scott City, KSBuilt 1980 · S/N E-1648N6736NSalter Aviation LLC · Bowdon, GABuilt 1980 · S/N E-1695N6736RD Kevin Lester Md Inc · Fresno, CABuilt 1966 · S/N T210-0136N6736SA36 Aviation LLC · Boise, IDBuilt 1982 · S/N E-1987N6736TBrakke Thomas · Clear Lake, IABuilt 1981 · S/N EA-242N6736VSharkey Lowell G · Manitou, KYBuilt 1979 · S/N E-1569N6737DMarlin Air LLC · Dallas, TXBuilt 1980 · S/N E-1651N6737RJpk LLC · Waterloo, NEBuilt 1966 · S/N T210-0137N6737VRiverview Ranches · Chowchilla, CAS/N EA-63N6739CPearce William · Grants Pass, ORBuilt 1980 · S/N TJ-262N6739TJoca Holdings LLC · Kittrell, NCBuilt 1980 · S/N E-1652N6739UKahler Automation Corp · Fairmont, MNBuilt 1979 · S/N E-1591N6739WSweigard Daniel J · Euless, TXBuilt 1980 · S/N CE-899N673ATCitizen Air LLC · Port Angeles, WABuilt 1976 · S/N U20603513N673CVNewton Donald O Jr · Gretna, NEBuilt 1977 · S/N CE-738N673DKBh Aero LLC · Hanover, MNBuilt 1979 · S/N 21063479N673HPBk Investment Co LLC · Jupiter, FLBuilt 1982 · S/N TH-1326N673TBalchunas Anthony B · Robinson, TXBuilt 1967 · S/N D-8470N67414Staley Clifford D · Delray Beach, FLBuilt 1980 · S/N E-1661N6741DPerformance Aircraft C LLC · Litchfield Park, AZBuilt 1983 · S/N TH-1395N6741MCooper Aviation LLC · Georgetown, SCBuilt 1980 · S/N TK-122N6741WDempsey Justin · Hazlet, NJBuilt 1980 · S/N E-1660N6742NCrazy Mountains Aviation LLC · Columbus, GAS/N TH-1140N6742PPrice Paul · Lancaster, VABuilt 1980 · S/N E-1709N6742SPowers Benjamin · Circleville, OHBuilt 1979 · S/N E-1635N6743RBas Part Sales LLC · Greeley, COBuilt 1966 · S/N T210-0143N6745MPerkins Communication LLC · Northport, ALBuilt 1980 · S/N TH-1124
Back to AD 86-13-04 R3