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.

N2753WGleaton Marcus H · Weatherford, TXBuilt 1966 · S/N 3349N2753XStorer Charles E · Payette, IDBuilt 1965 · S/N 18051553N2754EGulf Coast Helicopters Inc · Pearland, TXBuilt 1978 · S/N 17271315N2754FOtter Mark E · Warrensburg, MOBuilt 1965 · S/N 18256854N2755BBoyce Aviation Inc · New Port Richey, FLBuilt 1965 · S/N 1541-105N2755CR & B Aviation LLC · Oakland, MIBuilt 1955 · S/N 31902N2755QBlessed With Wings LLC · Queen Creek, AZS/N 18257955N2755WEast Rick · Muscle Shoals, ALFirst renewal noticeBuilt 1966 · S/N 1047N2755XMcsheehy James B · Fallbrook, CABuilt 1965 · S/N 18051555N2755YNancy Aviation LLC · Fayston, VTBuilt 1958 · S/N TD-106N2756JSquatch Air LLC · Wasilla, AKBuilt 1969 · S/N 185-1506N2756QLett Brian R · Eden Prairie, MNBuilt 1967 · S/N 18257956N2756WJohnson Stephen C · Lake Tapps, WABuilt 1966 · S/N 1048N2757FNationwide Web Directory Ltd · Seattle, WABuilt 1965 · S/N 18256857N2757MHaring Clay · Lincoln, KSBuilt 1946 · S/N 121238N2757QFive Seven Quebec Incorporated · Lake Stevens, WABuilt 1967 · S/N 18257957N2757WDennis Christopher A · Richardson, TXBuilt 1966 · S/N 1049N2758Panair Flying Club Inc · Miami, FLBuilt 1975 · S/N 17265168N2758TLinn Anthony B · Westborough, MABuilt 1967 · S/N TE-367N2758XAerotechniques LLC · South Kent, CTBuilt 1965 · S/N 18051558N2759ARichards Thomas D · Saint Jo, TXBuilt 1946 · S/N 7AC-6389N2759PWilkinson Kevin · Alliance, NES/N 22-3067N2759RFord William(Bill) A III · Abilene, TXBuilt 1969 · S/N 28R-35284N2759TLopas Jon D Trustee · Prescott, AZBuilt 1967 · S/N D-8468N2759WBar F Aviation LLC · Scottsbluff, NES/N 3352N275AAAoa Kissimmee Inc · Kissimmee, FLBuilt 2014 · S/N 172S11442N275AMAerodynamic LLC · Aurora, ORBuilt 2022 · S/N 2881518N275BBrunsvold Gene R · Selma, ORBuilt 1970 · S/N D-9206N275BMWestchester Flying Club Inc · Purchase, NYBuilt 1966 · S/N D-8196N275CBCalifornia Baptist University · Riverside, CABuilt 2025 · S/N 2881916N275CCSellers Richard V · Byron, CABuilt 2001 · S/N 9922CCN275DFAspen Ring LLC · Bloomington, INS/N 2518N275DHHoward Henry · Justin, TXBuilt 2019 · S/N 136B-265B/266B-1347N275DMMaxfield Douglas R · Chico, CABuilt 1975 · S/N 18052558N275DSMebane Alfred Holt IV Trustee · San Diego, CABuilt 2003 · S/N 40.275N275FState Of Alaska Department Of Public Safety · Anchorage, AKS/N U20605207N275FAFly Gateway Aviation Institute · New Castle, DEBuilt 2022 · S/N 28020058N275FLFox Leasing Group LLC · Hollywood, FLBuilt 2023 · S/N 4496564N275GTPs N275gt LLC · Green Bay, WIBuilt 1978 · S/N 17271631N275HPRich Aviation Services LLC · Fort Worth, TXBuilt 1976 · S/N 18265173N275JKKrol Jeffrey P · Somers, CTBuilt 1969 · S/N 28-26151N275LESky Photoshop LLC · Winter Garden, FLBuilt 2026 · S/N 2858N275MAFranzoy Steve · Salem, NMS/N 1014-2006N275NDPlane Nonsense · Middletown, DEBuilt 2000 · S/N 2842097N275PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2007 · S/N 172S10515N275PTTruss Travis D · Stephenville, TXBuilt 1997 · S/N 18280088N275RBlue Card Aviation LLC · Conifer, COS/N TC-1885N275RCGianopoulous William · Lawrence, MAFirst renewal noticeBuilt 1979 · S/N 402C0117N275RMRodgers Kenneth · Appleton, WIBuilt 1974 · S/N 340-0511N275RVMccutchan Philip · Mount Vernon, INBuilt 2006 · S/N 80275
Back to AD 2007-04-19 R1