OpenAirDocs.org
AD 90-06-03 R1

Registered aircraft · 20,687

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-06-03-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-06-03-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.

N7678GTanner Michael J · Hooksett, NHS/N 17259378N7678XSandstone Point Cattle Co LLC · Seguin, TXBuilt 1960 · S/N 17248178N7679GShipp-Hove Kylan · Mesa, AZBuilt 1970 · S/N 17259379N767CDTyler Flyers Inc · Tyler, TXBuilt 1979 · S/N 17273607N767CGMindy Limited LLC · Muscatine, IAS/N 17269309N767CLMls Aviation LLC · Yorba Linda, CABuilt 2005 · S/N 172S9987N767CRAtp Aircraft 2 LLC · Wilmington, DEBuilt 2005 · S/N 172S10021N767RAClear Prop Aero Inc · Webster, MNBuilt 1959 · S/N 47078N767VKTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2023 · S/N 172S13021N7680GGulyash Michael J · Ukiah, CAS/N 17259380N7681GCompass Aviation Inc · Shelby, NCBuilt 1970 · S/N 17259381N7682TPittsburgh Institute Of Aeronautics · West Mifflin, PAS/N 17249073N7682XRosenlof Dean F · Tempe, AZBuilt 1961 · S/N 17248182N7683GBalgoyen James T · Charlotte, MIBuilt 1970 · S/N 17259383N7683TCleary Michael A · Folsom, CABuilt 1960 · S/N 47283N7687XMost Ronald · Apple Valley, CABuilt 1961 · S/N 17248187N7688TRodgers Bruce W · Pine Bluff, ARBuilt 1960 · S/N 47288N7688XMauldin Gary · Navajo Dam, NMBuilt 1960 · S/N 17248188N7689GMerrihew Jerry R · Ashby, NEBuilt 1970 · S/N 17259389N7689TMcclatchey Steven C · Linn Grove, IABuilt 1960 · S/N 47289N768SPLast Sea LLC · Saint Augustine, FLBuilt 2001 · S/N 172S8700N7690TFranwick Industries LLC · Westbrook, CTBuilt 1960 · S/N 47290N7690XNeu Aviation LLC · Benton, LABuilt 1960 · S/N 17248190N7691TDewitt Dennis M · Collinsville, ALBuilt 1960 · S/N 47291N7691XAndrade Nelson J · Redwood City, CABuilt 1960 · S/N 17248191N7692XJohnson Kevin D · Eldorado, KSS/N 17248192N7693GA J L M Partners LLC · Hershey, NEBuilt 1970 · S/N 17259393N7693TButler Richard A · Gatesville, TXFirst renewal noticeBuilt 1960 · S/N 47293N7694THeaps John J · Dunlap, IABuilt 1960 · S/N 47294N7695GPfeifer Kenneth J · Bridger, MTS/N 17259395N7697GFlight School Inc · Spring, TXBuilt 1970 · S/N 17259397N7697TElliott Jason Rex · Brawley, CABuilt 1960 · S/N 47297N7697XDecker Sidney R · San Marcos, TXBuilt 1961 · S/N 17248197N7698TGerman Jamison K · Greenville, MIBuilt 1960 · S/N 47298N7699GZhao He · Yaphank, NYBuilt 1970 · S/N 17259399N7699TThomas Ag Aerial Inc · Thomas, OKBuilt 1960 · S/N 47299N769CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11580N769FGMustang Sally Aviation LLC · Camden, SCBuilt 2007 · S/N 172S10584N769JBGibson Randy L · Clinton, TNBuilt 1968 · S/N 17257380N769SPWings Over Texas Holdings LLC · Denton, TXBuilt 2001 · S/N 172S8701N76FFFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 172S12939N76HJAmalong Timothy M · Tucson, AZBuilt 1976 · S/N 17266809N76JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1974 · S/N 17263122N76LCHacienda Hills Skyhawk LLC · Laveen, AZBuilt 1977 · S/N 17268925N76SSNorth Texas Aeronautics LLC · Burleson, TXS/N 17263711N76TAAhlhorn Travis W · New Braunfels, TXS/N 17276025N76UDAlf Ix LLC · Chicago, ILBuilt 2017 · S/N 172S12091N7700UJarvis Tree Service Inc · Heber Springs, ARBuilt 1964 · S/N 17251700N7700XRule Paul Crane Trustee · Wapato, WABuilt 1961 · S/N 17248200N7701UIyer Sundaresh R · Northborough, MABuilt 1964 · S/N 17251701
Back to AD 90-06-03 R1