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.

N35QTReady Aim Flyer LLC · New Castle, DES/N D-8839N35RCG5 Aviation Inc · Englewood, COBuilt 1964 · S/N D-7393N35REDakota Aero Inc · Steamboat Springs, COS/N D-8930N35SHulteen Grant S · Tumwater, WABuilt 1964 · S/N D-7481N35SCCramp Steven J · Cleveland, TXBuilt 1973 · S/N D-9442N35TBCencalcom Inc · Santa Barbara, CABuilt 1977 · S/N D-9985N35TEOusley James Dean Jr · Granbury, TXBuilt 1979 · S/N E-1550N35TJBeech D9462 LLC · Perry, OHBuilt 1973 · S/N D9462N35TPMccallister Mark A · Qulin, MOBuilt 1977 · S/N D-10018N35TTJ B & B LLC · Midwest City, OKBuilt 1965 · S/N D-7812N35VBEquipment Lessors Inc · Lake Hawatha, NJBuilt 1977 · S/N D-10000N35VCGomez Victor · Isabela, PRBuilt 1969 · S/N 401A0126N35VSRcp3 Enterprises LLC · Chesterfield, MOBuilt 1966 · S/N D-8247N35XLWilliams James R · Scotts Valley, CABuilt 1964 · S/N D-7321N35YRTonini Farm And Cattle Co · San Luis Obispo, CABuilt 1982 · S/N D-10397N3605PSmith Bryan · Wenatchee, WABuilt 1978 · S/N P21000040N360AStrong LLC · Norcross, GABuilt 1981 · S/N E-1904N360DCGolike Timothy R · Anchorage, AKS/N 185-02173N360FVRegistered aircraftBuilt 2014 · S/N E-4035N360MWMission Wings International Inc · Salem, OHS/N P206-0572N360NEGoldrivet · Stateline, NVBuilt 1980 · S/N EA-128N360PMBon Aire Inc · Middlesboro, KYBuilt 1978 · S/N E-1253N360RJOliver Paul D · Bozeman, MTBuilt 1964 · S/N 206-0225N360TThroop Greg J · Spokane, WABuilt 1967 · S/N D-8427N360UAdrenalyne Consulting LLC · Scottsdale, AZBuilt 1997 · S/N TH-1834N360WLLaughlin Linda · Bluff Dale, TXBuilt 2002 · S/N 0216N3611ASgmbb LLC · Seneca, SCBuilt 1979 · S/N E-1472N3619JFisher Ag Service LLC · Cardington, OHBuilt 1979 · S/N T18803565TN361AHHodge Cleophas U · St Thomas, VIBuilt 1980 · S/N TJ-308N361CWCk Aviation LLC · Brookhaven, MSBuilt 1980 · S/N E-1755N361DMLeibstein Guy · Babylon, NYBuilt 1975 · S/N E-670N361GCFff Leasing LLC · Dover, DES/N 414-0616N361JBCarroll Farm Management Company · Carthage, ILBuilt 2005 · S/N 1253N361KWFliteco Holdings LLC · Lewes, DEBuilt 1981 · S/N EA-264N361SCShelton Jaime David · Hurricane, UTBuilt 1969 · S/N TE-696N361WHubbard Kenneth Scott · Decatur, ALBuilt 2002 · S/N E-3438N3621RBateman Randy · Lindale, TXBuilt 1977 · S/N E-1095N3622AWing Bird Aviation LLC · Garland, TXBuilt 1969 · S/N TE-777N3622TShaw Aviation LLC · Greenleaf, IDBuilt 1974 · S/N TH-479N3627AHint Mart H · Peachtree City, GABuilt 1969 · S/N D-9079N3629ADarrow Mark A Trustee · Mukilteo, WABuilt 1969 · S/N D-9080N362ARegistered aircraftBuilt 1980 · S/N E-1745N362CDBmg Adventures LLC · Decatur, TXBuilt 2005 · S/N 1392N362DBBb36 LLC · East Helena, MTBuilt 2010 · S/N E3941N362DLBee Line LLC · Millwood, GABuilt 1992 · S/N TH-1653N362SBNilco Enterprises Inc · Irving, TXBuilt 1981 · S/N E-1848N362TBarnett Blake C · Boynton Beach, FLBuilt 1977 · S/N D-10025N3632APauly Adam · Macomb, MIBuilt 1969 · S/N D-9081N36363Klein John · Woodland, CABuilt 1975 · S/N D-9748N3636AScull Adam C · Hockessin, DEBuilt 1978 · S/N E-1399
Back to AD 86-13-04 R3