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.

N8195YReynolds Richard T · Owens Cross Roads, ALBuilt 1980 · S/N 28-8016316N81962Sterling Colleen M Trustee · El Cajon, CABuilt 1990 · S/N 1N8196CStrout Carl D · Centerburg, OHBuilt 1954 · S/N 22-2301N8196NJensen Aviation LLC · Zephyrhills, FLBuilt 1969 · S/N 28-25394N8196WRensberger Scott C · Lake Jackson, TXBuilt 1965 · S/N 28-2324N8197Walsh Dennis Executor Et Al · Little Falls, NYS/N 74N81972Reile Roy H · Elmont, NYBuilt 1980 · S/N 28-8016318N8197YTyer Larry E Jr · Newnan, GABuilt 1966 · S/N 30-1316N81981Miloud Chadd K · Fort Worth, TXBuilt 1982 · S/N 28-8216147N81988Kephart John M · Franklin, INBuilt 1982 · S/N 28-8216148N8198AMorris Charles R · Holly, MIBuilt 2015 · S/N 697N8198CLee Jesse D · Pierre, SDBuilt 1954 · S/N 22-2303N8198HEckl James M · Florence, ALS/N 28-8090294N8198NSpooner John R Jr · Atascadero, CABuilt 1969 · S/N 28-25397N8198VRegion Flyers LLC · Valparaiso, INBuilt 1982 · S/N 28-8216145N8198WGreenshields Brett William · Eastvale, CABuilt 1965 · S/N 28-2326N8198YRoss Brian L · Eagle River, WIBuilt 1966 · S/N 30-1317N8198ZPlatz Trevor · Pine Grove, CABuilt 1982 · S/N 28-8216146N81999Schwartz Kenneth G · Lincoln, CABuilt 1980 · S/N 101-AN8199CKiokun Edward I · Mekoryuk, AKBuilt 1954 · S/N 22-2304N819BABig Bend Community College · Moses Lake, WABuilt 1977 · S/N MB-866N819CFParlor City Flying Club Inc · Bloomsburg, PABuilt 1998 · S/N 17280451N819DWMarchio Anthony J · Flower Mound, TXBuilt 2004 · S/N 25374N819GHFincher James B · Roanoke, ALBuilt 1999 · S/N 20319N819JBChance Billy M · Normangee, TXS/N 22-6693N819JKHaviland John G · Fenton, MIBuilt 2010 · S/N JK02N819JSZnamenacek Kevin L · Western, NEBuilt 1980 · S/N 28-8190044N819MWPussy Galore Aviation LLC · Kalispell, MTBuilt 2002 · S/N 80964N819PASkywest Leasing Inc · St George, UTBuilt 2019 · S/N 2881247N819PRHernandez Galin · Saint Augustine, FLBuilt 2001 · S/N 4052N819RTLeatherwood Michael W · Granbury, TXBuilt 2007 · S/N R001N819SMAnderson George M · Hattiesburg, MSBuilt 1979 · S/N 24-0802N819TTHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1992 · S/N 2161N819VKRosiere Jason Daniel · Haslet, TXBuilt 2004 · S/N 60200N819WWMaier Ryan D · Bemidji, MNBuilt 1991 · S/N 273N819YKBoswell Jeffrey · Kingsland, GABuilt 2017 · S/N 007N81ARTredway Robert J · Prescott, AZBuilt 1954 · S/N 22-2364N81BAAscent Aviation Inc · Van Nuys, CABuilt 1974 · S/N 28-7415440N81BHPalmer Robert E · Cedar Key, FLBuilt 2011 · S/N 542-2011N81BJBudahn Christopher W · Kenyon, MNBuilt 1989 · S/N 978N81BSFairchild Donald R · Ringgold, GAS/N 284N81CAColeman Aeroclub · Apo, AEBuilt 1989 · S/N 930N81CYKrueger Nicholas P · Somerset, WIBuilt 1982 · S/N 156N81DEElder Dennis R · Cookson, OKBuilt 1990 · S/N 107N81DGRae Seth R · Spotsylvania, VABuilt 1967 · S/N 28-4579N81DHMusser Scott S · Pasco, WABuilt 2000 · S/N 2064N81DNWaite John B · Tacoma, WABuilt 1997 · S/N 756N81DPStearman Group Inc · Dana Point, CABuilt 1941 · S/N 75-4479N81DSMarathon Leasing Inc · Elyria, OHBuilt 2004 · S/N 40.406N81EJSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1989 · S/N 001
Back to AD 90-04-06 R1