AD 2007-04-19 R1

Registered aircraft · 108,434

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:2007-04-19-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:2007-04-19-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.

N3857TAmt Services LLC · Virginia Beach, VABuilt 1967 · S/N 28R-30180N3857YLutz Matthew B · Jackson, TNBuilt 1964 · S/N 21058357N3857ZKnutson Wayne R · Tioga, NDS/N 18-7622N38580Avier LLC · Beverly, MABuilt 1977 · S/N 28-7725286N38587Swihart Painting LLC · Bolivar, MOBuilt 1977 · S/N 28R-7737100N3858MMachias Auto Parts Inc · Jonesport, MEBuilt 1978 · S/N 28-7816628N3858QPylant Eric Jon · Arnold, CABuilt 1971 · S/N 17259958N3858RBaugh David · Kirkland, WABuilt 1983 · S/N U20606496N3858TFlying Dots LLC · Daytona Beach, FLBuilt 1967 · S/N 28R-30181N3858ZGreat Basin Aviation LLC · Eagle River, AKBuilt 1961 · S/N 18-7629N3859CSweet Phillips R · Laguna Beach, CABuilt 1954 · S/N 31007N3859MWhite Roger L · Wallins Creek, KYS/N 28-7890336N3859NWilson Bryan J · Henderson, NCBuilt 1968 · S/N 680134N3859TYurek Allen L · Fairfax, VABuilt 1967 · S/N 28R-30182N3859WFast Lane Aviation Lllp · Hawkinsville, GAFirst renewal noticeBuilt 1966 · S/N 32-801N3859YMorse Donald W · Priest Lake, IDFirst renewal noticeS/N 21058359N3859ZBarnes Welding Inc · Waterville, WABuilt 1961 · S/N 18-7630N385ASCoraggio Joe · Chandler, AZBuilt 2005 · S/N L2K-202N385BRust Jeffrey J · San Antonio, TXBuilt 1960 · S/N D-6477N385BCRobinson Eric C · Palmer, AKS/N 526-2010N385BFGriffith Jonathan E · Newark, NJBuilt 2007 · S/N 6078N385CFoster Harry A · Birmingham, ALBuilt 2002 · S/N 0433N385CAHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0111N385CCCharlie Charlie Inc · Chimacum, WAS/N 9940CCN385CMCoastal Elite Air LLC · Helena, MTBuilt 2024 · S/N 14782N385DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843847N385DCDyncorp International Inc · Mcclellan, CABuilt 2021 · S/N 172S12651N385GRegistered aircraftS/N 64N385JBBeck Todd G · Clarkston, MIBuilt 1959 · S/N 35828N385KLIasco Flight Training Inc · Redding, CABuilt 1999 · S/N 172S8116N385MAPesek Larry Paul · Steinhatchee, FLBuilt 1998 · S/N 18280419N385RAdvanced Technology Distributors Inc · Ceres, CABuilt 1985 · S/N 46-8508038N385RBNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282199N385SCHogan William J · Libby, MTBuilt 1957 · S/N 18-5437N385SPAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1979 · S/N T18803452TN385TEBowers Nick · Mount Hope, WIBuilt 2012 · S/N 91324N385TWSheely Patrick D Trustee · Rapid City, SDS/N 40072N385WWeixler Ronald A · Salt Lake City, UTBuilt 2010 · S/N 90176N385XJohns Justin C · Dillingham, AKBuilt 1976 · S/N 7016CN38603Flight Share LLC · Charlotte, NCBuilt 1977 · S/N 28-7790570N38605Registration Pending · Kalispell, MTRegistration pendingBuilt 1977 · S/N 28R-7737102N3860RLundgren Christopher B · Graham, TXBuilt 1970 · S/N 28-5833N3860TTds Property Holdings LLC · Gilmer, TXBuilt 1967 · S/N 28R-30183N3860VAts LLC · Memphis, TNBuilt 1981 · S/N TC-2382N3860WBrasfield Jason · Bonnerdale, ARBuilt 1966 · S/N 32-802N3860XOverall Aviators LLC · Parsons, KSBuilt 1967 · S/N 155N3860ZKrueger Robert C · Glenburn, MEBuilt 1961 · S/N 18-7633N3861CBuben Michael · Chandler, AZBuilt 1954 · S/N 31009N3861NZekic Zivojin · Austin, TXBuilt 1968 · S/N 680136N3861PDellinger Jeremiah · Eagle River, AKBuilt 1955 · S/N 22-3553
Back to AD 2007-04-19 R1