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.

N4934SFerrell Charles A · Stockton, CABuilt 1980 · S/N R18201473N4934USatriana Robert L · Belen, NMBuilt 1965 · S/N 21058634N49353Skye Equipment LLC · Asheboro, NCBuilt 1992 · S/N 1217N49354Staple Three Sheep Co · Midwest, WYBuilt 1991 · S/N 1199N49357Miller Blaine Nathan · Brooks, GABuilt 1992 · S/N 1223N4935AVucetic Miroslav · Coral Springs, FLBuilt 1956 · S/N 32332N4935GKip'S Flying Service LLC · Bankston, ALBuilt 1979 · S/N 17273482N4935LCurnutt Aviation LLC · Fort Stockton, TXBuilt 1968 · S/N 28-5127N4935QHaygar Berlin Inc · Shorewood, MNBuilt 1978 · S/N 18503578N49362Schubert Paul · Raleigh, NCBuilt 1992 · S/N 1221N49363Back Country Aviation LLC · Kalispell, MTBuilt 1993 · S/N 1234N49365Mcdonald Ryan James · Chelan, WAS/N 1250N49366Kellogg John H · Skaneateles, NYBuilt 1994 · S/N 1257N4936AAnderson Dennis G · Eagle River, AKBuilt 1956 · S/N 32333N4936LBluse James · Bethlehem, GABuilt 1967 · S/N 28-4304N4936NSwett Alan · Panora, IABuilt 1979 · S/N 18267463N4936TDakma LLC · Parma, OHBuilt 1981 · S/N R18201794N49370Powell Weston G · Washoe Valley, NVBuilt 1994 · S/N 1273N49371Hebert Max C · Hartstown, PABuilt 1995 · S/N 1277N49372Walker Scott E · Fort Collins, COBuilt 1995 · S/N 1284N4937FRegistered aircraftBuilt 1976 · S/N 28-7790075N4937GInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 17273484N4937JSwirsding David J · Chalfont, PABuilt 1977 · S/N 310R0952N4937RAllred Bobby A · Centre, ALBuilt 1975 · S/N 18802454TN4937SRauch James A III · Cayce, SCBuilt 1980 · S/N R18201476N4937TSalsbery Enterprises Inc · Sharpsville, INBuilt 1981 · S/N R18201795N4938AK E R Air LLC · Fort Myers, FLBuilt 1978 · S/N 310R1406N4938TTilney Five LLC · Belleair, FLBuilt 1981 · S/N R18201796N4938YAerial Banners Inc · Pembroke Pines, FLBuilt 1968 · S/N 25-4738N4939CBard Ralph M · Tullahoma, TNBuilt 1979 · S/N 21063680N4939LNorcross Tracy D · Saint Joseph, MOBuilt 1967 · S/N 28-4309N4939RMiller Farms Jv · Opheim, MTBuilt 1975 · S/N 18802456TN4939SLeriche Daniel R · Wolcott, VTBuilt 1980 · S/N R18201478N4939VFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1980 · S/N 172RG0420N4939YDavidson Dan F · Ozona, TXBuilt 1980 · S/N 21064050N493BTRegistration Pending · Deltona, FLRegistration pendingBuilt 1975 · S/N 17702318N493CAMccann James M · Ennis, MTBuilt 1967 · S/N 32-346N493CDCocozzoli Kevin A · Crestview, FLBuilt 2005 · S/N 1603N493CKTaylor Mark Steven · Goshen, OHBuilt 2012 · S/N 493N493CPCivil Air Patrol · Maxwell Afb, ALBuilt 2010 · S/N 18282265N493DSDelaware State University · Dover, DEBuilt 1983 · S/N 28-8416011N493DWWayman Daniel M · Medford, ORBuilt 2005 · S/N 126N493EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12260N493FLPalmenteri Louis J · Rhome, TXS/N 28-7125308N493GCClayton Neil K · Oviedo, FLFirst renewal noticeBuilt 2007 · S/N 493N493KPCatalano Gerry · Shingle Springs, CABuilt 1988 · S/N CE-1231N493MAGreat Planes Aviation Inc · Rochester, MNBuilt 2001 · S/N 2843486N493RMRaritan Valley Flying School · Princeton, NJBuilt 1999 · S/N 17280784N493SHForsman David G Co-Trustee · South Haven, MNBuilt 1968 · S/N 17256881N493TSoaring Concepts Inc · Sturgis, MIBuilt 1961 · S/N CD-309
Back to AD 2007-04-19 R1