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.

N4192YDragon Grass LLC · Nashua, NHS/N 966-77N4192ZSwanson Amos W · Palmer, AKBuilt 1966 · S/N 18-8379N41937Calumet Aero LLC · Crown Point, INBuilt 1974 · S/N 28-7415365N4193RHunter Jeffrey Jay · Shreveport, LABuilt 1998 · S/N 17280636N4193YVan Dorpe Ross · Saint Charles, ILBuilt 1998 · S/N 18280359N41940Moughty Matthew · New Haven, VTS/N 28R-7435228N41949Ferg Robert B · New London, WIBuilt 1974 · S/N 28-7425301N4194QJacques Jerry J · Iliamna, AKS/N U2061359N4194SKilpatrick Bryan J · Poway, CABuilt 1975 · S/N E-677N4194WNicholson Jon S · Bethel, AKBuilt 1967 · S/N 1851203N4194YPyne James E · Tucson, AZS/N 602-77N41954Up And Up Aviation LLC · Magnolia, TXBuilt 1974 · S/N 28-7415368N4195EHusky Central LLC · Hugo, OKBuilt 1998 · S/N 18280363N4195RPlain LLC · Traverse City, MIBuilt 1998 · S/N 18280364N41960Tiffin Aviation Services Inc · Nogales, AZBuilt 1974 · S/N 34-7450165N41963Schafer Gary L · Greenwood, DEBuilt 1974 · S/N 28-7425302N41966Wray Jimmy Don · White House, TNBuilt 1974 · S/N 28-7425303N41967Krog Steven L · Hartford, WIBuilt 1974 · S/N 28-7415370N41969Lazy 8 Aviation LLC · Arden, NCBuilt 1974 · S/N 28-7415371N4196DCub Club Incdba · Fort Myers, FLBuilt 1999 · S/N 18280461N4196GProuse Craig H · Groveland, CABuilt 1998 · S/N 18280367N4196PHarmon Aviation LLC · Exeter, NHBuilt 1959 · S/N 23-1684N41973Legacy Aviation LLC · Murfreesboro, TNS/N 28-7405155N41977Augusti Group Enterprises Inc · Clayton, NCBuilt 1974 · S/N 28-7415375N41978Henderson Jason E · Corona, CABuilt 1974 · S/N 28-7415376N4197CAll In Aviation LLC · Townville, SCS/N 414-0513N4197KRichardson Walter J Jr · Aliceville, ALBuilt 1947 · S/N NAV-4-1197N4197QSumner Properties LLC · Somersworth, NHBuilt 1998 · S/N 18280370N4197SIndependence Aviation Inc · Scottsdale, AZBuilt 1975 · S/N D-9762N4197XBarr Air Patrol LLC · Mesquite, TXBuilt 1999 · S/N 18280449N4197ZBurns Barry D · Amarillo, TXS/N 18-8389N41980Warren Donald E · Pine Bluff, ARBuilt 1974 · S/N 28-7415377N41983Brotherman LLC · Hereford, TXBuilt 1974 · S/N 28-7415379N41985Aerospace Systems And Training LLC · Orange City, FLBuilt 1974 · S/N 28-7405157N4198BAero Flight Flying Club · Minneapolis, MNBuilt 1959 · S/N 23-1687N4198FRal Aviation LLC · Trumbull, CTBuilt 1976 · S/N 28-7790006N4198RTaf Aerial Services LLC · Beeville, TXBuilt 1999 · S/N 14096CN4198YGallo Michael R · High Falls, NYBuilt 1977 · S/N 292-77N4198ZMcfarlane Bradley J · Port Alsworth, AKBuilt 1966 · S/N 18-8391N41990R H K Of Kansas Inc · Overland Park, KSBuilt 1945 · S/N 1421N41992Stein Anthony J · Locust Grove, GABuilt 1974 · S/N 28-7415380N41995Columbus State Community College · Columbus, OHFirst renewal noticeBuilt 1974 · S/N 28-7415382N41997Caae Leasing LLC · Lake Zurich, ILBuilt 1974 · S/N 28R-7435235N4199HN4199h Club Llp · Oshkosh, WIBuilt 1978 · S/N 24-0661N4199JHallenbeck Jesse · Bellingham, WAS/N 28-22543N4199TEnga James Craig · Madison, SDBuilt 1998 · S/N 18280372N4199ZSymanowski Kevin · Reeder, NDBuilt 1966 · S/N 18-8392N419ACSimmons Scott · Anchorage, AKBuilt 2000 · S/N 408-99N419BCVagabond LLC · Baton Rouge, LABuilt 1982 · S/N 60-8265045N419BEVolar La Vida LLC · Kalispell, MTBuilt 1968 · S/N 18259409
Back to AD 2007-04-19 R1