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.

N490SPSky Training LLC · West Milford, NJBuilt 1998 · S/N 172S8031N490TBowen Edmund L · Laguna Beach, CAS/N D-6644N491Acadiana Fixed Wing Rotor Wing Inc · Carencro, LABuilt 1978 · S/N 18503597N49105Carlyle Properties LLC · Columbia Falls, MTS/N 203N4910AEverett Laurence B · Berkley, CABuilt 1956 · S/N 32307N4910DN4910d LLC · Delavan, WIBuilt 1979 · S/N 17272394N4910JGyure Ronald J · Fort Worth, TXBuilt 1968 · S/N 28R-30629N4910LPeake Alexander · Tacoma, WABuilt 1967 · S/N 28-4275N4910PWilkens Jacob James · Eagle River, AKBuilt 1962 · S/N 18-7832N4910SMarden John E · Oakland, MEBuilt 1980 · S/N R18201449N4910UN4910u LLC · Cushing, OKBuilt 1965 · S/N 21058610N4911ASatra Jerry J · Sidney, MTBuilt 1956 · S/N 32308N4911CGianni David C · Fairbanks, AKBuilt 1975 · S/N 18502653N4911ESchumacher Gregory Luther · Anchorage, AKBuilt 1979 · S/N 18503904N4911FFreed Michael L · Sylmar, CABuilt 1976 · S/N 28-7725035N4911JDarter Lloyd R · Mountain Grove, MOBuilt 1981 · S/N T18803778TN4911LMccown Brian W · Janesville, CABuilt 1967 · S/N 28-4276N4911XLake Superior Helicopters LLC · Duluth, MNBuilt 2006 · S/N 1675N4912EAdams Bruce M · Santa Fe, NMBuilt 1982 · S/N 18268284N4912FNab LLC · Wichita, KSBuilt 1976 · S/N 28-7715079N4912GHardee Christopher D · Smyrna, TNBuilt 1979 · S/N 17273459N4912SStevens Joel N · Monticello, ARBuilt 1980 · S/N R18201451N4913AOlson David J · Eugene, ORBuilt 1956 · S/N 32310N4913DRosies Procurement LLC · Midlothian, TXBuilt 1979 · S/N 17272395N4913GLeading Edge Flight Academy LLC · Bend, ORBuilt 1979 · S/N 17273460N4913JPassmore Stephen B DBA · Lacrosse, WABuilt 1981 · S/N T18803780TN4913KRabbit Hole Solutions LLC · Helena, MTS/N NAV-4-1913N4913LHaven Mark · Springfield, TNBuilt 1967 · S/N 28-4278N4913UGarvey F Patrick · Churubusco, INBuilt 1965 · S/N 21058613N4914FCb N4914f LLC · Coventry, CTBuilt 1976 · S/N 28-7715080N4914LWallace Aviation Inc · Wallace, NEBuilt 1967 · S/N 28-4279N4914QGudgel Daniel R · Lemoore, CABuilt 1976 · S/N 18802649N4914UCaldwell Gregg P · Desert Hot Springs, CAFirst renewal noticeBuilt 1965 · S/N 21058614N4915CLang Carl R · Harper, TXBuilt 1975 · S/N 18502657N4915JFox Richard A · Boynton Beach, FLBuilt 1968 · S/N 28R-30634N4915LRoss Robert J · Landisville, PABuilt 1967 · S/N 28-4280N4915VPegasus Aviation LLC · Rogersville, MOS/N 30139N4916APerkins Larry L DBA · Lake Elsinore, CABuilt 1956 · S/N 32313N4916DHoward Dan E · Hurricane, UTBuilt 1958 · S/N 51016N4916FSkaggs Steven L · Winters, CABuilt 1966 · S/N U206-0616N4916GOngstad Anne Whitman · Robinson, NDBuilt 1979 · S/N 17273463N4916JRegistration Pending · Townsend, GARegistration pendingBuilt 1968 · S/N 28R-30635N4916LMl Monkeybar Inc · Mammoth Lakes, CABuilt 1967 · S/N 28-4281N4916PPiper Aviation Museum Foundation · Lock Haven, PABuilt 1962 · S/N 27-506N4916TArithansa LLC · Big Bear City, CABuilt 1972 · S/N 28-7225281N4917AAtp Aircraft 7 LLC · Wilmington, DEBuilt 2008 · S/N 4496254N4917DWright Tyler C · Wilmington, NCBuilt 1958 · S/N 51017N4917GCarter Richard W · Bumpass, VABuilt 1979 · S/N 17273464N4917JTendall Timothy A · Sudbury, MABuilt 1968 · S/N 28R-30637N4917LBlankenbaker Myron K · Jacksonville Beach, FLBuilt 1967 · S/N 28-4282
Back to AD 2007-04-19 R1