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.

N6005UHaney William R · Pontotoc, MSBuilt 1970 · S/N 28-26906N6005ZMarstall Nancy T · Asheville, NCBuilt 1978 · S/N M-2127N6006DLedda Francesco · Canton, TXBuilt 1979 · S/N ME-133N6006WGreen William A · Memphis, TNBuilt 1964 · S/N 28-20006N60079Bacich Peter C · Brick, NJS/N 77-141N6007FMobley Barbara Alice · Kathleen, GABuilt 1979 · S/N WA-4N6007QRegistration Pending · Tampa, FLRegistration pendingBuilt 1965 · S/N 3225N6007TMinton Richard D · Longville, LABuilt 1979 · S/N WA-5N6007USteele Tucker L · The Colony, TXFirst renewal noticeBuilt 1970 · S/N 28-26817N6007WMoore Merritt · Mcarthur, CAS/N 28-20007N6007YAudubon Air Of Louisiana LLC · Bossier City, LABuilt 1978 · S/N M-2130N60083Kocik William J Jr · Shepherdstown, WVBuilt 1978 · S/N M-2083N60086Echo Bravo LLC · Helena, MTBuilt 1978 · S/N MC-617N6008DChristopher D Bock · Fishers, INBuilt 1979 · S/N MC-611N6008HSwartz Selden H Jr · Jacksonville, ORBuilt 1977 · S/N 28R-7837047N6008KShore Stephen · Longview, TXBuilt 1981 · S/N M-2086N6008LGawlik Leslie W · Reisterstown, MDBuilt 1978 · S/N M-2087N6008URasmussen John E · Seffner, FLBuilt 1978 · S/N MC-616N6008XMangum Gary W · Centreville, VABuilt 1969 · S/N 301836N60097Ratliff Frank O · Palestine, TXBuilt 1978 · S/N MC-619N6009ACampbell Bryan P · Naples, FLBuilt 2009 · S/N 91170N6009DKirkendall James A · N Richland Hills, TXS/N 22-4661N6009QDelone Charles P · Sarasota, FLBuilt 1965 · S/N 863N6009WLowman Jeffrey L · Clarksburg, WVBuilt 1964 · S/N 28-20009N600AMid Atlantic Air Museum · Reading, PABuilt 1955 · S/N 22-3N600AABrauer Jason R · Winnebago, ILBuilt 1968 · S/N 28-25102N600APToombs Todd J · Peyton, COBuilt 2007 · S/N 72378N600AVMountain Top Aviation Inc · Ebensburg, PABuilt 1978 · S/N 28-7916229N600BHBeaupre Harry R · Fallon, NVBuilt 2003 · S/N 2330N600CWWinn Kathy J · Spring, TXBuilt 1994 · S/N 20755N600EZMoore Glenn C · Elkhart Lake, WIS/N 102N600FSHome Free Aviation LLC · New Port Richey, FLBuilt 1974 · S/N 22-0044N600GGNlh Aviation LLC · College Station, TXBuilt 1980 · S/N 394-80N600HHFleming Mike R · Troy, MOBuilt 1974 · S/N 600N600HJRavotti Air LLC · Leechburg, PABuilt 1978 · S/N 28-7990004N600KKFeielin Kenneth M · Paris, OHBuilt 2007 · S/N 25488N600PCRudd Wayne · Basalt, COBuilt 1993 · S/N 714-93N600PFEastern Aviation Corp · Whitestone, NYBuilt 1977 · S/N 28-7816109N600RBGates Steven · Midlothian, TXBuilt 1974 · S/N 247N600SEMcgavock Randall J · Camp Verde, AZBuilt 1984 · S/N 1279N600TLLbaviation LLC · Wheatland, WYS/N 1148N600VVMindy Limited LLC · Muscatine, IABuilt 1975 · S/N 17264773N600WPort Of Tillamook Bay · Tillamook, ORS/N 1N600WTBaldauf Mark H · Nova, OHBuilt 1986 · S/N 1480N6010James Douglas M Trustee · Scottsdale, AZBuilt 1928 · S/N 539N60104Theo-N60104 LLC · Wilmington, DEBuilt 1978 · S/N M-2093N60106Lutzko Timothy R · Ocean View, DEBuilt 1978 · S/N M-2094N6010CBig Bend Community College · Moses Lake, WABuilt 1978 · S/N MB-905N6010DTrenkamp John F · Oskaloosa, IAS/N 22-4662N6010LBergstrom Robert L · Amelia, VABuilt 1972 · S/N AA5-0110
Back to AD 90-04-06 R1