AD 90-04-06 R1

Registered aircraft · 68,369

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.

N113JWGrass Roots Aviation LLC · Bend, ORBuilt 2004 · S/N RV623839N113JYFreeman Alan M · San Antonio, TXS/N 482RN113KRIal Corp · Lewes, DEBuilt 1974 · S/N 28-7415211N113MAMyllyla Ray J · Woodland Hills, CABuilt 1999 · S/N 304N113MEButler Robyn L · Vale, ORS/N 909-76N113MSFly2walk LLC · Loveland, COBuilt 1996 · S/N 1217-96N113MXN113mx LLC · Redding, CAS/N 002N113NShaw Brandon L · Juneau, AKBuilt 1998 · S/N 1422N113PATundra Aviation Inc · Casselton, NDBuilt 1948 · S/N 14-113N113PCProp & Jet Air Museum Inc · Romoland, CABuilt 1982 · S/N 1N113PJLang Carl · Harper, TXBuilt 2003 · S/N 9957CCN113PVVaneau Philip M · Kerrville, TXBuilt 1987 · S/N DENTON GIVENS 1N113RVMason Chance L · Elwood, INBuilt 1988 · S/N 1029N113SJGlumac Stanley Jr · Grindstone, PABuilt 1993 · S/N 21400N113SWFargo Jet Center LLC · Fargo, NDBuilt 1977 · S/N 28-7890298N113TSMilitary Aviation Museum · Virginia Beach, VABuilt 2012 · S/N 081295N113UDRv8rs Anonymous LLC · Cincinnati, OHBuilt 2002 · S/N 80459N113VGN113vg LLC · Princeton, NJBuilt 1993 · S/N 2391N113WYRyals Barry · Rhine, GABuilt 1974 · S/N 28R-7535055N114Cooper Michael D · North Turner, MEBuilt 1954 · S/N 18-3937N1140CAtkins Alvin R · Barnstead, NHBuilt 1953 · S/N 22-973N1140JGardner John D · Tallahassee, FLBuilt 1974 · S/N 140N1140PCromley Amanda J · Lewisburg, PABuilt 1955 · S/N 23-152N1141Callaway Don · Leona Valley, CABuilt 1942 · S/N 77-48N11411Baca Marciano A · Los Angeles, CAS/N 1506-20N1141MSunshine Flyers · Auburn, CAS/N 17260152N1141UFlight School Inc · Spring, TXBuilt 1976 · S/N 17266870N11429Schwartz David J · Bellaire, MIBuilt 1975 · S/N 17702338N1142QSteely Paul · Williamsburg, KYBuilt 1977 · S/N 28-7790378N1143ENevarrow Leon · Spring Valley, CABuilt 1977 · S/N 1215-77N1143JDurrah Anthony E Sr · Charlotte, NCBuilt 1974 · S/N 143N1143MCastelletti Mark Anthony Trustee · Casa Grande, AZBuilt 1970 · S/N 17259443N1144AKramer John Edward · Conroe, TXBuilt 1951 · S/N 18-737N1144JLee Carl B · Bullard, TXBuilt 1974 · S/N 186N1144KYoung Bradley M · Vancouver, WABuilt 1981 · S/N 24-1185N1144LComposite Sign Products Inc · Zeeland, MIBuilt 1964 · S/N 306N1144MCcr Aviation LLC · Kalispell, MTS/N 17259444N1144WNimmo Lawrence · Cordova, MDBuilt 1981 · S/N 24-1189N1144XFly Texas Sky LLC · Arlington, TXFirst renewal noticeBuilt 1975 · S/N 28-7505215N1144ZBay Lux Ventures LLC · Tampa, FLBuilt 1977 · S/N 287890231N1145JPrestridge Austin · Newark, OHBuilt 1974 · S/N 145N1145TWilliams Thomas J · Burr Ridge, ILBuilt 1981 · S/N 24-1191N1146LSak Aviation LLC · Cheney, KSBuilt 1981 · S/N 24-1198N1146VPlane Cents LLC · Henderson, NVBuilt 1996 · S/N 2641N1147N7371y LLC · Waterford, MIBuilt 1964 · S/N 30-423N11476Shannon Kenneth H · Washington, DCBuilt 1975 · S/N 17702340N1147JSandel Henry Adrian III · Natchez, MSBuilt 1974 · S/N 132N1147LLandry Lonny Reid · Fort Worth, TXBuilt 1964 · S/N 309N1147XPax Flyers LLC · Hollywood, MDBuilt 1975 · S/N 28R-7535259N1148ATyrrell Luke L · Fairbanks, AKBuilt 1951 · S/N 18-742
Back to AD 90-04-06 R1