AD 90-04-06 R1

Registered aircraft · 68,377

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:90-04-06-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:90-04-06-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.

N4695YSnider Scott E DBA · Turner, MTBuilt 1973 · S/N 18-7309019N46962Soto Del Carpio Nhikitoa · Fairbanks, AKBuilt 1943 · S/N 195N46964Simsbury Aviation Services LLC · Simsbury, CTBuilt 1979 · S/N 15283152N4696FTorres Roberto · Bavamon, PRBuilt 1979 · S/N 17273073N4696JRegistered aircraftBuilt 1968 · S/N 28R-30599N4696LKoontz Marina M · Seattle, WABuilt 1966 · S/N 17254691N4696RSchroter Jon A · La Crosse, KSBuilt 1966 · S/N 28-21460N4697RHolthaus Cody · Eden Prairie, MNBuilt 1966 · S/N 28-21461N4697WKellermeyer Steven B · Tucson, AZBuilt 1978 · S/N 13273N4697ZAntesberger Edward A · Fairfax, VABuilt 1961 · S/N 22-8237N46983Smale Christopher Cotrustee · Bakersfield, CABuilt 1995 · S/N 54N4698DDrm Aviation LLC · Glencoe, ALBuilt 1979 · S/N 17272333N4698FSmith Marciano S · Fort Lauderdale, FLS/N 28-7715061N4698JShea William Preston · Franklin, TNBuilt 1968 · S/N 28R-30601N4698MTri-County Sprayers Inc · Hamlin, TXBuilt 1947 · S/N 11-207N4699JBeach Robert E · Fairfax, VABuilt 1968 · S/N 28R-30602N4699RGillis Jeremiah · Cody, WYBuilt 1966 · S/N 28-21463N469AKWells Kris G · Barron, WIBuilt 2018 · S/N CC18-0088N469DKKimbrough Duke III · Rhome, TXBuilt 1984 · S/N 249N469FAStratus Rr LLC · New Castle, DEBuilt 2022 · S/N 28020069N469FSSunderland Richard · Matthews, NCBuilt 2013 · S/N 73474N469GWRegistered aircraftBuilt 2010 · S/N 80858N469JHHolland John R · Jacksonville, FLBuilt 1975 · S/N 645N469JJTesmer Dean D · Rio, WIBuilt 1989 · S/N 1809030N469JSToole William B · Goochland, VAFirst renewal noticeBuilt 1966 · S/N MA-23N469KLM9 Flight LLC · Delhi, LABuilt 1966 · S/N 61N469NETauber Samara R · La Jolla, CAFirst renewal noticeBuilt 1983 · S/N 17275952N469RAChorice Kenneth · Bartlett, TNBuilt 1978 · S/N 38-78A0531N469RHShaughnessy Thomas E · Seabrook, NHBuilt 1941 · S/N 75-2252N469SMMyres Mark D · Freeland, WABuilt 2021 · S/N KA19290427N469TFHalf Penny Hangar Inc · Houston, TXBuilt 2022 · S/N 2881592N469TWEmge Douglas W · Albertville, ALBuilt 1989 · S/N 507N469YMyburgh Hendrick T · Petaluma, CABuilt 1930 · S/N M-4277N46AArcher Jimmy R · Houston, TXBuilt 2000 · S/N 002WBN46AARutan Aircraft Flying Experience · Waller, TXBuilt 1981 · S/N 46N46ABSchultz Lawrence D · San Diego, CABuilt 1991 · S/N 530N46AHDobbs Joseph D Jr · Charlotte, NCS/N 23180N46AJPosson John L Trustee · Petaluma, CABuilt 1998 · S/N 94-0155N46APMorris Christopher J · Crockett, TXBuilt 1963 · S/N 28-1203N46ATBurcar Mark L · Gig Harbor, WAS/N 1N46BEvans James · Tuolumne, CABuilt 1991 · S/N 1498N46BVPellerin Brian · Hermon, MEBuilt 2006 · S/N 80535N46CCCravens Clarence C · Fairview, OKBuilt 2019 · S/N 7218001N46CTBurns Donald E · Corning, CABuilt 2003 · S/N 5208N46DAPotts Timothy W · Oscoda, MIBuilt 1993 · S/N 1556N46DCMonberg James · Seattle, WABuilt 1981 · S/N 0001N46DHMusgrave John R · Morris, ILS/N 369N46DZLuepke Quinn L · Wasilla, AKS/N 001N46EAEssential Aviation LLC · Meridianville, ALBuilt 1970 · S/N 39-79N46ETNicholson Jim · Cody, WYBuilt 2012 · S/N 8-6894
Back to AD 90-04-06 R1