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.

N4692JDingbat Ltd · Wilmington, DEBuilt 1968 · S/N 28R-30595N4692NWilliams Douglas J · Bristol, NHBuilt 1979 · S/N 18267290N4692QZulu Aircraft Leasing LLC · Grants Pass, ORBuilt 1973 · S/N 17261745N4692RKaresh Eli · Orlando, FLBuilt 1966 · S/N 28-21454N4692YBillingsley Robin Trustee · Chugiak, AKBuilt 1971 · S/N 18-8952N4693BSutton Aircraft Salvage LLC · Palmer, AKS/N 31591N4693D4 Knots LLC · Flower Mound, TXBuilt 1957 · S/N D-4906N4693EJayo Construction Inc · Boise, IDS/N 18268261N4693JThibodeaux Gerald J · Duson, LABuilt 1979 · S/N 17273663N4693QSievert David M · Santa Cruz, CABuilt 1973 · S/N 17261746N4693YKnutson Wayne R · Thompson, NDBuilt 1967 · S/N 25-4424N46941Haynes Aviation LLC · Caruthersville, MOS/N 35495N4694GRegistered aircraftBuilt 1979 · S/N 17273320N4694RKent Adam · Rogersville, MOBuilt 1966 · S/N 28-21457N4694SRegistered aircraftBuilt 1979 · S/N R18201384N4694YKempton Chevrolet Buick Ltd · Safford, AZBuilt 1980 · S/N 21063988N4694ZKyro Consulting LLC · Williamsburg, VABuilt 1988 · S/N 4608115N4695AAgarwal Ravi · Bath, PABuilt 1983 · S/N P21000816N4695JGrimm Jason Eddison · Sacramento, CAS/N 28R-30598N4695RDestination Flyer LLC · Memphis, TNBuilt 1966 · S/N 28-21459N4695SDavis Lawrence E · Melbourne, KYBuilt 1973 · S/N 003N4695YSnider Scott E DBA · Turner, MTBuilt 1973 · S/N 18-7309019N46962Soto Del Carpio Nhikitoa · Fairbanks, AKBuilt 1943 · S/N 195N4696ASokol Dennis A · Milan, OHBuilt 1956 · S/N 32293N4696DWings Of Hope · Skiatook, OKS/N D-4876N4696FTorres Roberto · Bavamon, PRBuilt 1979 · S/N 17273073N4696JRegistered aircraftBuilt 1968 · S/N 28R-30599N4696K96 Kilo LLC · Modesto, CABuilt 1975 · S/N 18263697N4696LKoontz Marina M · Seattle, WABuilt 1966 · S/N 17254691N4696PPolhemus Christopher · Carmichaels, PABuilt 1960 · S/N 27-225N4696RSchroter Jon A · La Crosse, KSBuilt 1966 · S/N 28-21460N4696THess Aero Corp Inc · Huntsville, ALBuilt 1981 · S/N R18201737N4697KMorgan James D · Denali Park, AKBuilt 1975 · S/N 18263698N4697RHolthaus Cody · Eden Prairie, MNBuilt 1966 · S/N 28-21461N46983Smale Christopher Cotrustee · Bakersfield, CABuilt 1995 · S/N 54N4698C98 Charlie LLC · Anchorage, AKBuilt 1974 · S/N 18502598N4698DDrm Aviation LLC · Glencoe, ALBuilt 1979 · S/N 17272333N4698FSmith Marciano S · Fort Lauderdale, FLS/N 28-7715061N4698JShea William Preston · Franklin, TNBuilt 1968 · S/N 28R-30601N4698KRegistered aircraftBuilt 1975 · S/N 18263699N4698RCorl Jason · Stanton, CABuilt 1969 · S/N CE-277N4699AReed Aviation LLC · Pearl, MSBuilt 1956 · S/N 32296N4699FStinson Ryan · Eagle, IDBuilt 1966 · S/N P206-0299N4699JBeach Robert E · Fairfax, VABuilt 1968 · S/N 28R-30602N4699PGv Air Inc · Medford, ORBuilt 1960 · S/N 27-227N4699RGillis Jeremiah · Cody, WYBuilt 1966 · S/N 28-21463N4699SStrike Allen P · Flint, MIBuilt 1969 · S/N 32-1158N4699UValdez David M · Shady Shores, TXBuilt 1964 · S/N 18051399N4699WN4699w LLC · Rutherford, CABuilt 1981 · S/N 18268131N4699YSandhill Soaring Club Inc · Brighton, MIBuilt 1967 · S/N 25-4417
Back to AD 2007-04-19 R1