OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,495

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.

N741LFValley Aviation Inc · Lake Lillian, MNBuilt 1979 · S/N E-1529N741RVInternational Fun Place Hangar 32 LLC · Laughlin, NVBuilt 1987 · S/N CE-1198N741SCKaczorowski Michael T · Reisterstown, MDBuilt 2002 · S/N 0213N74206Chinn Larry · Anatone, WABuilt 1974 · S/N U20602457N7424NBuck Carl W · Longmont, COBuilt 1981 · S/N 18504325N742CHSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N 3240646N742DDPlane Fun Inc Tr Trustee · Snellville, GABuilt 2004 · S/N 1108N742NEPotkulski Daniel M · Locust Grove, GABuilt 1978 · S/N TK82N7433NFixed Gear LLC · Sherwood, ARBuilt 1977 · S/N U20603660N743CDHerrington James C Jr · Mullins, SCBuilt 2002 · S/N 0140N743HLanoue Edgar A · Stevensville, MTBuilt 1969 · S/N U206-1297N743TIsr Aviation LLC · Lewes, DEBuilt 1976 · S/N E-802N7444Tytex LLC · Dallas, TXS/N E1520N7444SBlkbrdz LLC · Grand Ledge, MIS/N D-8803N7445NSkyplane Pilots LLC · Bluffton, SCS/N 18263223N7448NCcx-2000-0111 LLC · Garberville, CABuilt 1977 · S/N U20603662N744BWDobson'S Leasing Co LLC · Ocoee, FLBuilt 1981 · S/N 414A0658N744CDCirrus Drivers Zoom LLC · Folsom, CABuilt 2001 · S/N 0024N744DDTaffet Jay · New Orleans, LABuilt 1984 · S/N 46-8408075N744MSSierra Foothill Properties LLC · Auburn, CABuilt 2002 · S/N 0204N744PZHemmingway Gray Inc · Los Gatos, CABuilt 1981 · S/N TJ-382N744RCastaneda Jose · Yakima, WABuilt 1974 · S/N 21060521N744TIverson Walter P · Nancy, KYBuilt 1977 · S/N TE-1096N744UJApproach Aviation LLC · Marion, OHBuilt 1968 · S/N TE-568N7459NGriggs William P · Bellingham, WABuilt 1968 · S/N CE-228N745EPSumner Michael · Hahira, GABuilt 1974 · S/N 414-0498N745KPPaklook Air Inc Dbi · Bethel, AKFirst renewal noticeBuilt 1974 · S/N 20700238N745TStoneman Thomas K · Friendswood, TXBuilt 1973 · S/N TE-900N745VKoritz Terence C · Ladera Ranch, CABuilt 1965 · S/N D-7953N7461NUniversal Coatings Inc · Fresno, CABuilt 1968 · S/N D-8832N7462NBartels Randall John · Wesley Chapel, FLBuilt 1968 · S/N D-8833N7463NTiger Owl Properties LLC · Centennial, COBuilt 1968 · S/N D-8834N7466NN7466n LLC · Bethpage, NYBuilt 1968 · S/N E-22N7468NParents Aviation One LLC · Mesa, AZBuilt 1968 · S/N E-27N746CBr Aviation LLC · Bellevue, WABuilt 2002 · S/N 0413N746CDSky West Aviation Inc Trustee · Albuquerque, NMS/N 0074N746DMBirds Birds LLC · Bradenton, FLS/N TH-354N746KPFox Aircraft LLC · Wasilla, AKBuilt 1983 · S/N 20700766N746ZXSlater R Winston Trustee · St Charles, ILS/N 21064368N7470NDryden Jason · Nowthen, MNBuilt 1968 · S/N E-29N7471NBritton Shawn · El Dorado Hills, CABuilt 1968 · S/N E-31N7475NN7475n LLC · Indianapolis, INBuilt 1968 · S/N D-8837N7476NGeorge Andrew N · Corvallis, ORBuilt 1968 · S/N D-8836N7476PMobley Aviation LLC · The Colony, TXBuilt 1976 · S/N CE-631N7476QSmith Keith S · Fredericksburg, TXBuilt 1973 · S/N U20602216N7478Hubbard Matthew L · Phoenix, AZBuilt 2002 · S/N 0420N747AQQuadrani Anthony L · Kingsford, MIBuilt 1974 · S/N 18502333N747BGMiller Bradley W · Conyngham, PABuilt 1966 · S/N CE-77N747BPRose James M · White Hall, ARBuilt 1973 · S/N D-9440N747DVUnrestricted Climb LLC · Muskego, WIBuilt 1996 · S/N E-3062
Back to AD 86-13-04 R3