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.

N3015ZPittman Leo B · Stanfield, AZBuilt 1959 · S/N 22-6966N30166De Jager Henry · Smithville Flats, NYBuilt 1968 · S/N 17701093N3016CMoore Todd M · Peoria, ILBuilt 1958 · S/N D-5681N3016DHuybrechts Dirk J · Los Angeles, CAFirst renewal noticeBuilt 1978 · S/N 28-7911040N3016FLosleben William L · Duvall, WABuilt 1966 · S/N 18257116N3016MWild Wingdom LLC · Greenville, SCBuilt 1978 · S/N 28-7890284N3016NParker James C · Rescue, CABuilt 1979 · S/N 32-7940038N3016QBarnes David L · Palmer, AKBuilt 1967 · S/N 18258016N3016TWilson Michael L · Santa Maria, CABuilt 1979 · S/N 28-7916298N3016WBramble And Schaffer Aviation LLC · Raleigh, NCBuilt 1979 · S/N 28R-7918086N3016YWood James D · Mineral Bluff, GABuilt 1962 · S/N 18254016N30173Tolman William C · Maryville, TNBuilt 1978 · S/N 32R-7887270N30179Kowatra Anil K · Lilburn, GABuilt 1968 · S/N 17701103N3017HDavis Ronald C · Bloomington, MNS/N 28-7916184N3017PDragonfly Aviation LLC · Mirando City, TXBuilt 2007 · S/N 1820N3017WKirk Michael E · Alvin, TXBuilt 1973 · S/N D9520N30182Johnson Arnold R · Mina, SDBuilt 1968 · S/N 17701105N30184Cp Aviation Inc · Santa Paula, CABuilt 1974 · S/N 17264125N30189Onguard Aviation LLC · Cottonwood Falls, KSBuilt 1968 · S/N 17701108N3018FDietzler James J · Weyauwega, WIBuilt 1966 · S/N 18257118N3018QAndre Eric J · Somerset, WIBuilt 1967 · S/N 18258018N3018SPerez Daniel · Pembroke Pines, FLBuilt 1965 · S/N TC-960N3018YGranger Airplane LLC · Granger, INBuilt 1962 · S/N 18254018N3018ZGorman Robert L · Los Gatos, CABuilt 1979 · S/N 28-7916398N30195Palmer Peter L · Mission, TXBuilt 1968 · S/N 17701113N30198Thomas Mark J · Vacaville, CABuilt 1968 · S/N 17701115N3019FMadison Richard Christopher · Little Rock, ARBuilt 1966 · S/N 18257119N3019LWatkins Daniel J · Kennett Square, PABuilt 1983 · S/N 7-0136N3019PNelson Matthew J · Frewsburg, NYBuilt 1957 · S/N 23-928N3019QHatfield Brothers LLC · Gooding, IDBuilt 1967 · S/N 18258019N3019SSmith Jason E · Calliham, TXBuilt 2007 · S/N 4150N3019TDanner Eric C · Benton, KSBuilt 2007 · S/N 23099CN3019YSheets Jeffrey M · Salmon, IDBuilt 1979 · S/N 28-7911148N301ACFlying Squirrel Aviation LLC · Shirley, MABuilt 1995 · S/N 744-95N301AVJackson Charles A · Winchester, KYBuilt 1976 · S/N 28-7715070N301BHTraxler Shane C · West Monroe, LABuilt 1997 · S/N 3246080N301BLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020284N301BPPrecision Aviators LLC · Iuka, ILBuilt 1991 · S/N 1983N301BZPin High LLC · Ruston, LABuilt 2005 · S/N E-3642N301CFSunrise Aviation Inc · Ormond Beach, FLBuilt 2002 · S/N 17281135N301CPWhy Not Fly Aviation LLC · Gainesville, VAS/N 414A0105N301CTVatm Sky Investments LLC · Thomson, GABuilt 1980 · S/N TH-1166N301DBDon Davis Aviation Inc · Henderson, KYBuilt 1977 · S/N 310R0891N301DDRockalong Holdings LLC · Stanton, TXBuilt 1979 · S/N 18503985N301DETentacle Corp · Walnut Creek, CABuilt 1997 · S/N 041N301EHinckley Harry W · Coralville, IABuilt 1989 · S/N 62N301EBQuesnel William G · Truckee, CABuilt 1978 · S/N 21062524N301ECF N A Aviation LLC · Wakefield, MABuilt 2025 · S/N 2881980N301EFRegistered aircraftBuilt 2002 · S/N 3RX105N301EMMcconwell Edward A · Mission, KSBuilt 1965 · S/N 30-916
Back to AD 2007-04-19 R1