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.

N3225WCherokee Aero Group Inc · Lakeland, FLBuilt 1965 · S/N 32-33N3225YSamaritans Purse · Boone, NCS/N 18254225N32265Norsesian Brandon · Valrico, FLBuilt 1974 · S/N 28-7525040N32267Top Flight Aviation LLC · Reedsburg, WIBuilt 1974 · S/N 28-7515105N32269Parker Air LLC · Mobile, ALBuilt 1974 · S/N 28-7515106N3226BSooner Aviation LLC · Norman, OKBuilt 1999 · S/N E3226N3226JSimms Matthew · Davie, FLBuilt 1994 · S/N E-2855N3226NDeuel Justin R · Mankato, MNS/N 243N3226QDenning Aviation Inc · Fort Madison, IABuilt 2000 · S/N E-3326N3226SJones David A · Wasilla, AKBuilt 1964 · S/N 18255726N3226WAlbert James R · Corpus Christi, TXBuilt 1965 · S/N 32-34N3226YVaughn William Harrison · San Antonio, TXBuilt 1962 · S/N 18254226N32271Tylka Edward · Lockport, ILBuilt 1974 · S/N 28-7505044N32274Simaan Daniel · Fontana, CABuilt 1974 · S/N 28-7525042N32276Price Company · Spokane, WABuilt 1974 · S/N 28-7515109N3227ABoho LLC · Lewes, DEBuilt 1980 · S/N 310R1881N3227CSnider Frederick A Jr · Morgantown, WVBuilt 1978 · S/N R18200258N3227E3227e LLC · Jacksonville, FLBuilt 1978 · S/N 17271475N3227GOgden Scott S · Collierville, TNBuilt 1995 · S/N E-2927N3227MParker Shon T · Wasilla, AKBuilt 1947 · S/N 12-2108N3227PTucker Patricia A · Hamilton, MTBuilt 1957 · S/N 23-1114N3227XSasar Inc · Wilmington, DEBuilt 1999 · S/N E-3227N32282Watson Scott E · Wichita, KSS/N 18267033N32288Habzansky Michael E · Greens Fork, INBuilt 1974 · S/N 287515112N3228DNulsen Eric Randall · Greenbrier, ARBuilt 1955 · S/N 32026N3228PPopejoy Marc · Fort Scott, KSBuilt 1958 · S/N 24-294N3228UTnt Rentals LLC · Wilmington, DEBuilt 1963 · S/N 18254628N3228WChris I Lee Md Inc · Rowland Heights, CABuilt 1995 · S/N E-2928N3228XN3228x LLC · Colusa, CABuilt 1995 · S/N E-2978N3228YFawley John M · Wisconsin Rapids, WIBuilt 1962 · S/N 18254228N32291Active Pilot Inc · Van Nuys, CABuilt 1974 · S/N 28-7515114N32292Mdr Rental Corp · Ann Arbor, MIBuilt 1974 · S/N 28-7515115N32293Stone James B · Springfield, VABuilt 1974 · S/N 28-7505046N32294Cloud Dancer Aviation Inc · Deland, FLBuilt 1974 · S/N 28R-7535041N32296Fly South Aviation LLC · Charlotte, NCBuilt 1974 · S/N 28-7525046N32299Lundahl Kristina N · Windsor, COBuilt 1974 · S/N 28-7515116N3229GAero-Mark LLC · Winchester, KYBuilt 2000 · S/N E-3329N3229UEdwards Scott A · Lindsay, CABuilt 1963 · S/N 18254629N322ALHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 2004 · S/N 10559N322ASHenning Kurt D · Auke Bay, AKBuilt 2000 · S/N 18049CN322ATAbkadirov Tagir · Tampa, FLS/N 1524N322BFVann Russell B · Mangum, OKBuilt 1979 · S/N 17273231N322BWRobl Christopher · Littleton, COBuilt 2003 · S/N 026N322CARoyal Majesty Aviation LLC · Atlanta, GAS/N 28R-7130013N322CDGnc Industries Inc · Pocahontas, ARBuilt 2005 · S/N 1272N322CHRayworth Lyle D · Carrollton, GAS/N 82992N322CSGlembot Troy M Trustee · Winchester, VABuilt 2012 · S/N 18282341N322CTGrover Michael P · Palm Coast, FLBuilt 1979 · S/N 28-7916545N322CWGallagher Maria J · Lakewood Ranch, FLBuilt 2004 · S/N 1098N322DRMcgrath James T · Campbell, CABuilt 2005 · S/N 81291
Back to AD 2007-04-19 R1