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.

N314JLawrence B Botsford · Sanger, TXBuilt 2008 · S/N 3035N314JASharp Jerry L · Georgetown, TXBuilt 1984 · S/N 828N314JBBratton Johnny B · Williamsport, TNBuilt 1999 · S/N 2843226N314KBMatthews Grover C · Hardinsburg, KYBuilt 1958 · S/N 23-1391N314LARaintree Aviation LLC · Mesa, AZBuilt 2013 · S/N 172S11285N314MAircraft Partner Holdings Inc Trustee · BerlinBuilt 2010 · S/N 524-2010N314MFGobel Victor M · White City, ORBuilt 2023 · S/N JA5980920N314MPTeristar LLC · Lewes, DEBuilt 1958 · S/N 51634N314NFWillis Charlotte Y · Belleview, FLBuilt 1960 · S/N 52548N314PBBledsoe Mark · Saint Charles, ILBuilt 2025 · S/N 73196N314PTStrong Thomas W · Rigby, IDBuilt 2006 · S/N 90489N314PWJ&S Corley LLC · Peoria, AZBuilt 2000 · S/N 2844031N314PYKahn William D · Weddington, NCBuilt 1971 · S/N 18260879N314REvans Randall B Trustee · Fallon, NVBuilt 1998 · S/N 399-98N314RARochester Air Center LLC · Canandaigua, NYBuilt 1998 · S/N 17280489N314RSAcorn Mutual Flying Club Inc · Hershey, PABuilt 1977 · S/N 17269038N314RVRegistered aircraftBuilt 2007 · S/N 802N314SOrem John Marshall · Shallowater, TXBuilt 1956 · S/N 33981N314SAAeryn Innovations LLC · Dallas, TXBuilt 2003 · S/N 18281243N314SEZaludek Joseph S · Eugene, ORBuilt 2003 · S/N 40.328N314SHGrover Arlan K · Aurora, COBuilt 1999 · S/N 114N314SRRoesler Scott D · Homer, AKBuilt 1989 · S/N 314N314SYDeas James A · Independence, ORBuilt 2013 · S/N 72973N314TRShalexco LLC · Salt Lake City, UTBuilt 1979 · S/N R18201086N314TSSteele William G · Warrenton, VABuilt 2003 · S/N 80877N314TTSappa Valley Construction LLC · Oberlin, KSBuilt 1961 · S/N 18253457N314UPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1979 · S/N 310R1852N314YOlson Allen J · Ludington, MIBuilt 1975 · S/N 69N3150DTransmountain Aviation Inc · Kasilof, AKBuilt 1955 · S/N 31948N3150LS & S Aircraft Inc · El Dorado, ARBuilt 1965 · S/N 310J0150N3150WRegistration Pending · Olympia, WARegistration pendingBuilt 1979 · S/N VAC-126-79N31519Aerobatics Unlimited · Utica, ILBuilt 1981 · S/N 2250N3151DVan Aero LLC · Dover, DEBuilt 1955 · S/N 31949N3151EAviation Capital Management LLC · San Jose, CABuilt 1978 · S/N 17271453N3151FBentley Nicholas Klausing · Reading, PABuilt 1966 · S/N 18257251N3151JStava Robert D · Brainard, NEBuilt 1980 · S/N T18803609TN3151QRairdan Todd G · Vacaville, CABuilt 1967 · S/N 18258151N3151RBergstrom Danny · Stillwater, MNBuilt 1982 · S/N 353N3151SThomas Darryl · Belfield, NDBuilt 1964 · S/N 18255651N3151XJoseph Stern · Sherman, TXS/N 17702399N3151YVert James E · Davison, MIBuilt 1962 · S/N 18254151N3151ZOld Crow Flyers LLC · Mooresville, NCBuilt 1959 · S/N 22-7098N31526Trostel Manfred E · Longboat Key, FLBuilt 1989 · S/N E-2487N3152ERegional Medical Consulting Pllc · Mebane, NCBuilt 1994 · S/N E-2880N3152FJk Aviation LLC · Warden, WABuilt 1966 · S/N 18257252N3152QFff Aviation LLC · Land O Lakes, FLS/N 18258152N3152SDavis Lee W · Burns, ORFirst renewal noticeBuilt 1964 · S/N 18255652N3152ZMoultrie Zachariah D M · Grass Valley, CABuilt 1959 · S/N 22-7096N31531Storey James F · Gadsden, ALBuilt 1978 · S/N 28-7816558N31532Delaware Valley Aviation Inc · Langhorne, PABuilt 1978 · S/N 28-7890468
Back to AD 2007-04-19 R1