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.

N3646WWap Air LLC · Newburgh, INBuilt 1966 · S/N 32-550N3646YAerohawk Aviation Inc · Idaho Falls, IDBuilt 1963 · S/N 21058146N36470Proctor Charles H · Conroe, TXBuilt 1978 · S/N 28-7890518N3647CSmith Kristopher D · Wickenburg, AZBuilt 1954 · S/N 31145N3647DVmc Aviation · Upland, CAS/N 35347N3647KRayman Bethany A · Salem, SDS/N 28-23666N3647PHubbard Robert Thomas · Atlanta, GABuilt 1955 · S/N 22-3398N3647RRegistration Pending · Indianapolis, INRegistration pendingBuilt 1970 · S/N 28-5744N3647UAdams Verne Franklin · Madera, CABuilt 1963 · S/N 18255047N3647WNichols Robert H Jr · Normandy, TNBuilt 1966 · S/N 32-551N3648BMcgill Aviation Inc · Greensboro, GABuilt 1981 · S/N 62P08668165006N3648DFerry Theodore D · Bellevue, WABuilt 1956 · S/N 35348N3648KBonanno John W · Oceanside, NYBuilt 1967 · S/N 28-23667N3648QRegistration Pending · Graham, WARegistration pendingBuilt 1967 · S/N MA-233N3648UMerlin Aviation LLC · Grants Pass, ORBuilt 1963 · S/N 18255048N3648ZMow The Sky LLC · Midway, UTBuilt 1960 · S/N 22-7545N3649151st Aero Squadron LLC · Hoover, ALBuilt 1978 · S/N 28-7890519N3649CBayou Flight LLC · Parker, COBuilt 1954 · S/N 31147N3649PHelmer Daniel W · Eagle, AKBuilt 1955 · S/N 22-3400N3649QSteinberg Stephen M · Happy Valley, ORBuilt 1967 · S/N MA-234N3649RCummings Jason M · San Rafael, CABuilt 1969 · S/N 28-5746N3649USteele Aerospace Service LLC · Tulsa, OKS/N 18255049N3649WTurbo Six LLC · Wilmington, DEBuilt 1966 · S/N 32-554N364ACWalker Geri G · Carrollton, GABuilt 1998 · S/N E-3148N364AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LABuilt 2025 · S/N 2881990N364APMartin John T · Paradise, CAS/N 35340N364AU364au LLC · Ames, IABuilt 2014 · S/N E-4031N364BBSocio Aviation Services LLC · Benton, KYBuilt 1999 · S/N E-3240N364BFFlying B Partners LLC · Wichita, KSBuilt 1977 · S/N E-1166N364BSHusky 89 LLC · Bethany, OKBuilt 2007 · S/N E-3786N364BTFlying B Land And Timber Co LLC · Pineville, LABuilt 2013 · S/N 25621N364CMoore Charles K · Woodinville, WABuilt 1978 · S/N 18266262N364CKSchneider William J Jr · Cedar Key, FLS/N 17260354N364DRegistered aircraftBuilt 2014 · S/N 172S11373N364DBHirsch Benjamin M · Orange Park, FLBuilt 1995 · S/N E-2963N364DDJd Bonanza LLC · Mesa, AZBuilt 1996 · S/N E3056N364DFBlackley Nathan · Eugene, ORBuilt 1997 · S/N E-3091N364DMMoon David A · Valkaria, FLS/N 1001N364EMountain Desert Aviation LLC · Lake Havasu City, AZBuilt 2010 · S/N E-3944N364ELFiorini Randy · Turlock, CABuilt 1988 · S/N CE-1268N364EMSafeco Leasing LLC · Port Alsworth, AKBuilt 1968 · S/N E-56N364FSN927nw LLC · Watchung, NJBuilt 2000 · S/N 23065CN364GSpruce Creek Consultants LLC · Port Orange, FLBuilt 1972 · S/N 17701776N364GGTddc Ventures LLC · Dublin, CABuilt 1990 · S/N EA-501N364GWHdh Aircraft Leasing LLC · Carrollton, TXBuilt 2003 · S/N 172S9364N364HKoberg Lance L · Dallas, GABuilt 1974 · S/N 364N364HPZadeh Alidad Trustee · El Centro, CABuilt 1973 · S/N E-402N364JBBlazie Marketing Services Inc · Street, MDBuilt 1997 · S/N E-3079N364MNakamura Hajime Trustee · Long Beach, CAS/N 0364N364MCLesser Antilles Corp Trustee · Wilmington, DEBuilt 1973 · S/N 32-7300039
Back to AD 2007-04-19 R1